Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Database Problem

17 posts in General Discussion Last posting was on 2007-06-26 01:48:02.0Z
Avaal Technology Solutions Posted on 2007-06-25 14:48:22.0Z
From: "Avaal Technology Solutions" <admin@avaal.com>
Newsgroups: ianywhere.public.general
Subject: Database Problem
Lines: 60
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
NNTP-Posting-Host: toroon12-1177740551.sdsl.bell.ca
X-Original-NNTP-Posting-Host: toroon12-1177740551.sdsl.bell.ca
Message-ID: <467fd5b6@forums-1-dub>
Date: 25 Jun 2007 07:48:22 -0700
X-Trace: forums-1-dub 1182782902 70.50.229.7 (25 Jun 2007 07:48:22 -0700)
X-Original-Trace: 25 Jun 2007 07:48:22 -0700, toroon12-1177740551.sdsl.bell.ca
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6093
Article PK: 2550

Hi,

We currently have a web application running on IIS on Windows Server 2003.
We
have a second server (also running Windows Server 2003), which has a Sybase,
SQL Anywhere 10 DB on it. We are having difficulty connecting to the
database,
because it resides on another server. We keep getting an erorr saying the
database cannot be found, regardless of whether we use a DSN or DSN-Less
connection string.

However, when we configure a system DSN through windows and point to the DB
on
the DB server, we are able to connect successfuly. For this reason, I am
assuming we maybe missing a few parameters in the DSN connection string
embedded in our code. We are using ASP for the web app. The DSN connection
string is as follows:

<% Constring = "dsn=Project;uid=username;pwd=password;" %>

We have also tried to use a DSN-Less connection string, which is as follows:

<% Constring = "Driver={SQL Anywhere
10};Dbf=Y:\path\project.db;Uid=username;Pwd=password;" %>

The database on the second server, is located in a folder on the C drive. We
have mapped this drive on our frist server, as drive Y and have also shared
the
directory.

Please note: We are able to open the database on both servers through Sybase
Central. We cannot however, connect to the database on both servers, at the
same time. If one server is connected to the databse through Sybase, the
other
server will receive an error message when trying to open the DB saying that
the
"Specified database is in use".

Our main concern is being able to connect to the DB from both servers
simultaneously. If this problem can be resolved, we are fine. The web
application requires a database connection through sybase, in order to write
records to the database. There is a Java application on the second server
which
requires an active connection to the database through sybase, in order to
run.
The java app connects to the db using JDBC drivers.

As you can see this creates an issue, if we can only have one system
connected
to the DB through sybase. We have to be able to connect to the same db, at
the
same time, through both servers in order for all this to work.


Any help in this matter would be greatly appreciated, as we are on a tight
deadline, and need to resolve this problem asap.

Thanks in advance.


Stephen Rice Posted on 2007-06-25 15:50:08.0Z
From: "Stephen Rice" <sriceATianywhereDOTcom>
Newsgroups: ianywhere.public.general
References: <467fd5b6@forums-1-dub>
Subject: Re: Database Problem
Lines: 108
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
NNTP-Posting-Host: srice-xp2.sybase.com
X-Original-NNTP-Posting-Host: srice-xp2.sybase.com
Message-ID: <467fe430$1@forums-1-dub>
Date: 25 Jun 2007 08:50:08 -0700
X-Trace: forums-1-dub 1182786608 10.25.98.210 (25 Jun 2007 08:50:08 -0700)
X-Original-Trace: 25 Jun 2007 08:50:08 -0700, srice-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6095
Article PK: 2548

So, I gather your architecture resembles

Machine #1
Bunch of software including SQL Anywhere 10 client libraries

Machine #2
SQL Anywhere 10 Database

This is a pretty standard network connection.

On Machine #2 you need to have already have started the Network Server

The DSNs on both machines are the same. They will specify:
- on the Database tab specify the ServerName to be whatever you started the
Network Server with and the database name to be the name of the database
- on the Network tab check TCPIP
- on the Login tab specify the userid and password. Once it's all working
you can remove them and specify them when you connect

Once you have this push the Test Connection button and it should be working.
If it doesn't start your server with the -z switch to trace the network from
the server side and on the Advanced tab, in the Additional connection
parameters area, specify LOGFILE=<filespec> to capture a client
communications trace in the file specified by <filespec> If the error is
not obvious post the results back here.


--
/steve

Stephen Rice
Sybase iAnywhere

* Register now for TechWave 2007 August 6-10 in Las Vegas . Visit
www.sybase.com/techwave

"Avaal Technology Solutions" <admin@avaal.com> wrote in message
news:467fd5b6@forums-1-dub...
> Hi,
>
> We currently have a web application running on IIS on Windows Server 2003.
> We
> have a second server (also running Windows Server 2003), which has a
> Sybase,
> SQL Anywhere 10 DB on it. We are having difficulty connecting to the
> database,
> because it resides on another server. We keep getting an erorr saying the
> database cannot be found, regardless of whether we use a DSN or DSN-Less
> connection string.
>
> However, when we configure a system DSN through windows and point to the
> DB on
> the DB server, we are able to connect successfuly. For this reason, I am
> assuming we maybe missing a few parameters in the DSN connection string
> embedded in our code. We are using ASP for the web app. The DSN connection
> string is as follows:
>
> <% Constring = "dsn=Project;uid=username;pwd=password;" %>
>
> We have also tried to use a DSN-Less connection string, which is as
> follows:
>
> <% Constring = "Driver={SQL Anywhere
> 10};Dbf=Y:\path\project.db;Uid=username;Pwd=password;" %>
>
> The database on the second server, is located in a folder on the C drive.
> We
> have mapped this drive on our frist server, as drive Y and have also
> shared the
> directory.
>
> Please note: We are able to open the database on both servers through
> Sybase
> Central. We cannot however, connect to the database on both servers, at
> the
> same time. If one server is connected to the databse through Sybase, the
> other
> server will receive an error message when trying to open the DB saying
> that the
> "Specified database is in use".
>
> Our main concern is being able to connect to the DB from both servers
> simultaneously. If this problem can be resolved, we are fine. The web
> application requires a database connection through sybase, in order to
> write
> records to the database. There is a Java application on the second server
> which
> requires an active connection to the database through sybase, in order to
> run.
> The java app connects to the db using JDBC drivers.
>
> As you can see this creates an issue, if we can only have one system
> connected
> to the DB through sybase. We have to be able to connect to the same db, at
> the
> same time, through both servers in order for all this to work.
>
>
> Any help in this matter would be greatly appreciated, as we are on a tight
> deadline, and need to resolve this problem asap.
>
> Thanks in advance.
>
>


Avaal Technology Solutions Posted on 2007-06-25 18:07:31.0Z
From: "Avaal Technology Solutions" <admin@avaal.com>
Newsgroups: ianywhere.public.general
References: <467fd5b6@forums-1-dub> <467fe430$1@forums-1-dub>
Subject: Re: Database Problem
Lines: 122
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
NNTP-Posting-Host: toroon12-1177740551.sdsl.bell.ca
X-Original-NNTP-Posting-Host: toroon12-1177740551.sdsl.bell.ca
Message-ID: <46800463$1@forums-1-dub>
Date: 25 Jun 2007 11:07:31 -0700
X-Trace: forums-1-dub 1182794851 70.50.229.7 (25 Jun 2007 11:07:31 -0700)
X-Original-Trace: 25 Jun 2007 11:07:31 -0700, toroon12-1177740551.sdsl.bell.ca
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6100
Article PK: 2555

Hi,

How do I setup the network server. When I open sybase, does it not start by
default, or do I have to configure this server in a certain way?

Thanks.

"Stephen Rice" <sriceATianywhereDOTcom> wrote in message
news:467fe430$1@forums-1-dub...
> So, I gather your architecture resembles
>
> Machine #1
> Bunch of software including SQL Anywhere 10 client libraries
>
> Machine #2
> SQL Anywhere 10 Database
>
> This is a pretty standard network connection.
>
> On Machine #2 you need to have already have started the Network Server
>
> The DSNs on both machines are the same. They will specify:
> - on the Database tab specify the ServerName to be whatever you started
> the Network Server with and the database name to be the name of the
> database
> - on the Network tab check TCPIP
> - on the Login tab specify the userid and password. Once it's all working
> you can remove them and specify them when you connect
>
> Once you have this push the Test Connection button and it should be
> working. If it doesn't start your server with the -z switch to trace the
> network from the server side and on the Advanced tab, in the Additional
> connection parameters area, specify LOGFILE=<filespec> to capture a client
> communications trace in the file specified by <filespec> If the error is
> not obvious post the results back here.
>
>
> --
> /steve
>
> Stephen Rice
> Sybase iAnywhere
>
> * Register now for TechWave 2007 August 6-10 in Las Vegas . Visit
> www.sybase.com/techwave
>
>
>
> "Avaal Technology Solutions" <admin@avaal.com> wrote in message
> news:467fd5b6@forums-1-dub...
>> Hi,
>>
>> We currently have a web application running on IIS on Windows Server
>> 2003. We
>> have a second server (also running Windows Server 2003), which has a
>> Sybase,
>> SQL Anywhere 10 DB on it. We are having difficulty connecting to the
>> database,
>> because it resides on another server. We keep getting an erorr saying the
>> database cannot be found, regardless of whether we use a DSN or DSN-Less
>> connection string.
>>
>> However, when we configure a system DSN through windows and point to the
>> DB on
>> the DB server, we are able to connect successfuly. For this reason, I am
>> assuming we maybe missing a few parameters in the DSN connection string
>> embedded in our code. We are using ASP for the web app. The DSN
>> connection
>> string is as follows:
>>
>> <% Constring = "dsn=Project;uid=username;pwd=password;" %>
>>
>> We have also tried to use a DSN-Less connection string, which is as
>> follows:
>>
>> <% Constring = "Driver={SQL Anywhere
>> 10};Dbf=Y:\path\project.db;Uid=username;Pwd=password;" %>
>>
>> The database on the second server, is located in a folder on the C drive.
>> We
>> have mapped this drive on our frist server, as drive Y and have also
>> shared the
>> directory.
>>
>> Please note: We are able to open the database on both servers through
>> Sybase
>> Central. We cannot however, connect to the database on both servers, at
>> the
>> same time. If one server is connected to the databse through Sybase, the
>> other
>> server will receive an error message when trying to open the DB saying
>> that the
>> "Specified database is in use".
>>
>> Our main concern is being able to connect to the DB from both servers
>> simultaneously. If this problem can be resolved, we are fine. The web
>> application requires a database connection through sybase, in order to
>> write
>> records to the database. There is a Java application on the second server
>> which
>> requires an active connection to the database through sybase, in order to
>> run.
>> The java app connects to the db using JDBC drivers.
>>
>> As you can see this creates an issue, if we can only have one system
>> connected
>> to the DB through sybase. We have to be able to connect to the same db,
>> at the
>> same time, through both servers in order for all this to work.
>>
>>
>> Any help in this matter would be greatly appreciated, as we are on a
>> tight
>> deadline, and need to resolve this problem asap.
>>
>> Thanks in advance.
>>
>>
>
>


Luis Porras Posted on 2007-06-25 15:01:16.0Z
From: "Luis Porras" <luis.porras@gmail.com>
Newsgroups: ianywhere.public.general
References: <467fd5b6@forums-1-dub>
Subject: Re: Database Problem
Lines: 85
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1896
NNTP-Posting-Host: 200.91.79.163
X-Original-NNTP-Posting-Host: 200.91.79.163
Message-ID: <467fd8bc$1@forums-1-dub>
Date: 25 Jun 2007 08:01:16 -0700
X-Trace: forums-1-dub 1182783676 200.91.79.163 (25 Jun 2007 08:01:16 -0700)
X-Original-Trace: 25 Jun 2007 08:01:16 -0700, 200.91.79.163
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6094
Article PK: 2549

I'm having the same problem with a Windows 2000 Server + SA 10... The
temporary solution I found was adding to the connection string the

ENG=DB_ServerName;

But I'm still looking for an explanation on this issue.

HTH,

~Luis

"Avaal Technology Solutions" <admin@avaal.com> wrote in message
news:467fd5b6@forums-1-dub...
> Hi,
>
> We currently have a web application running on IIS on Windows Server 2003.
> We
> have a second server (also running Windows Server 2003), which has a
Sybase,
> SQL Anywhere 10 DB on it. We are having difficulty connecting to the
> database,
> because it resides on another server. We keep getting an erorr saying the
> database cannot be found, regardless of whether we use a DSN or DSN-Less
> connection string.
>
> However, when we configure a system DSN through windows and point to the
DB
> on
> the DB server, we are able to connect successfuly. For this reason, I am
> assuming we maybe missing a few parameters in the DSN connection string
> embedded in our code. We are using ASP for the web app. The DSN connection
> string is as follows:
>
> <% Constring = "dsn=Project;uid=username;pwd=password;" %>
>
> We have also tried to use a DSN-Less connection string, which is as
follows:
>
> <% Constring = "Driver={SQL Anywhere
> 10};Dbf=Y:\path\project.db;Uid=username;Pwd=password;" %>
>
> The database on the second server, is located in a folder on the C drive.
We
> have mapped this drive on our frist server, as drive Y and have also
shared
> the
> directory.
>
> Please note: We are able to open the database on both servers through
Sybase
> Central. We cannot however, connect to the database on both servers, at
the
> same time. If one server is connected to the databse through Sybase, the
> other
> server will receive an error message when trying to open the DB saying
that
> the
> "Specified database is in use".
>
> Our main concern is being able to connect to the DB from both servers
> simultaneously. If this problem can be resolved, we are fine. The web
> application requires a database connection through sybase, in order to
write
> records to the database. There is a Java application on the second server
> which
> requires an active connection to the database through sybase, in order to
> run.
> The java app connects to the db using JDBC drivers.
>
> As you can see this creates an issue, if we can only have one system
> connected
> to the DB through sybase. We have to be able to connect to the same db, at
> the
> same time, through both servers in order for all this to work.
>
>
> Any help in this matter would be greatly appreciated, as we are on a tight
> deadline, and need to resolve this problem asap.
>
> Thanks in advance.
>
>


Avaal Technology Solutions Posted on 2007-06-25 16:06:07.0Z
From: "Avaal Technology Solutions" <admin@avaal.com>
Newsgroups: ianywhere.public.general
References: <467fd5b6@forums-1-dub> <467fd8bc$1@forums-1-dub>
Subject: Re: Database Problem
Lines: 100
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
NNTP-Posting-Host: toroon12-1177740551.sdsl.bell.ca
X-Original-NNTP-Posting-Host: toroon12-1177740551.sdsl.bell.ca
Message-ID: <467fe7ef$1@forums-1-dub>
Date: 25 Jun 2007 09:06:07 -0700
X-Trace: forums-1-dub 1182787567 70.50.229.7 (25 Jun 2007 09:06:07 -0700)
X-Original-Trace: 25 Jun 2007 09:06:07 -0700, toroon12-1177740551.sdsl.bell.ca
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6096
Article PK: 2551

Hi,

So once you added that string, your application was able to connect to the
db on the other server? Were you using a DSN or DSN-Less connection string?

Thanks.

"Luis Porras" <luis.porras@gmail.com> wrote in message
news:467fd8bc$1@forums-1-dub...
> I'm having the same problem with a Windows 2000 Server + SA 10... The
> temporary solution I found was adding to the connection string the
>
> ENG=DB_ServerName;
>
> But I'm still looking for an explanation on this issue.
>
> HTH,
>
> ~Luis
>
>
> "Avaal Technology Solutions" <admin@avaal.com> wrote in message
> news:467fd5b6@forums-1-dub...
>> Hi,
>>
>> We currently have a web application running on IIS on Windows Server
>> 2003.
>> We
>> have a second server (also running Windows Server 2003), which has a
> Sybase,
>> SQL Anywhere 10 DB on it. We are having difficulty connecting to the
>> database,
>> because it resides on another server. We keep getting an erorr saying the
>> database cannot be found, regardless of whether we use a DSN or DSN-Less
>> connection string.
>>
>> However, when we configure a system DSN through windows and point to the
> DB
>> on
>> the DB server, we are able to connect successfuly. For this reason, I am
>> assuming we maybe missing a few parameters in the DSN connection string
>> embedded in our code. We are using ASP for the web app. The DSN
>> connection
>> string is as follows:
>>
>> <% Constring = "dsn=Project;uid=username;pwd=password;" %>
>>
>> We have also tried to use a DSN-Less connection string, which is as
> follows:
>>
>> <% Constring = "Driver={SQL Anywhere
>> 10};Dbf=Y:\path\project.db;Uid=username;Pwd=password;" %>
>>
>> The database on the second server, is located in a folder on the C drive.
> We
>> have mapped this drive on our frist server, as drive Y and have also
> shared
>> the
>> directory.
>>
>> Please note: We are able to open the database on both servers through
> Sybase
>> Central. We cannot however, connect to the database on both servers, at
> the
>> same time. If one server is connected to the databse through Sybase, the
>> other
>> server will receive an error message when trying to open the DB saying
> that
>> the
>> "Specified database is in use".
>>
>> Our main concern is being able to connect to the DB from both servers
>> simultaneously. If this problem can be resolved, we are fine. The web
>> application requires a database connection through sybase, in order to
> write
>> records to the database. There is a Java application on the second server
>> which
>> requires an active connection to the database through sybase, in order to
>> run.
>> The java app connects to the db using JDBC drivers.
>>
>> As you can see this creates an issue, if we can only have one system
>> connected
>> to the DB through sybase. We have to be able to connect to the same db,
>> at
>> the
>> same time, through both servers in order for all this to work.
>>
>>
>> Any help in this matter would be greatly appreciated, as we are on a
>> tight
>> deadline, and need to resolve this problem asap.
>>
>> Thanks in advance.
>>
>>
>
>


Luis Porras Posted on 2007-06-25 16:09:20.0Z
From: "Luis Porras" <luis.porras@gmail.com>
Newsgroups: ianywhere.public.general
References: <467fd5b6@forums-1-dub> <467fd8bc$1@forums-1-dub> <467fe7ef$1@forums-1-dub>
Subject: Re: Database Problem
Lines: 119
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1896
NNTP-Posting-Host: 200.91.79.163
X-Original-NNTP-Posting-Host: 200.91.79.163
Message-ID: <467fe8b0$1@forums-1-dub>
Date: 25 Jun 2007 09:09:20 -0700
X-Trace: forums-1-dub 1182787760 200.91.79.163 (25 Jun 2007 09:09:20 -0700)
X-Original-Trace: 25 Jun 2007 09:09:20 -0700, 200.91.79.163
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6097
Article PK: 2552

Yes, exactly either using DSN-Less or DSN connection strings. Also, using
e.g. dbisql with -c parameter.

~Luis

"Avaal Technology Solutions" <admin@avaal.com> wrote in message
news:467fe7ef$1@forums-1-dub...
> Hi,
>
> So once you added that string, your application was able to connect to the
> db on the other server? Were you using a DSN or DSN-Less connection
string?
>
> Thanks.
>
> "Luis Porras" <luis.porras@gmail.com> wrote in message
> news:467fd8bc$1@forums-1-dub...
> > I'm having the same problem with a Windows 2000 Server + SA 10... The
> > temporary solution I found was adding to the connection string the
> >
> > ENG=DB_ServerName;
> >
> > But I'm still looking for an explanation on this issue.
> >
> > HTH,
> >
> > ~Luis
> >
> >
> > "Avaal Technology Solutions" <admin@avaal.com> wrote in message
> > news:467fd5b6@forums-1-dub...
> >> Hi,
> >>
> >> We currently have a web application running on IIS on Windows Server
> >> 2003.
> >> We
> >> have a second server (also running Windows Server 2003), which has a
> > Sybase,
> >> SQL Anywhere 10 DB on it. We are having difficulty connecting to the
> >> database,
> >> because it resides on another server. We keep getting an erorr saying
the
> >> database cannot be found, regardless of whether we use a DSN or
DSN-Less
> >> connection string.
> >>
> >> However, when we configure a system DSN through windows and point to
the
> > DB
> >> on
> >> the DB server, we are able to connect successfuly. For this reason, I
am
> >> assuming we maybe missing a few parameters in the DSN connection string
> >> embedded in our code. We are using ASP for the web app. The DSN
> >> connection
> >> string is as follows:
> >>
> >> <% Constring = "dsn=Project;uid=username;pwd=password;" %>
> >>
> >> We have also tried to use a DSN-Less connection string, which is as
> > follows:
> >>
> >> <% Constring = "Driver={SQL Anywhere
> >> 10};Dbf=Y:\path\project.db;Uid=username;Pwd=password;" %>
> >>
> >> The database on the second server, is located in a folder on the C
drive.
> > We
> >> have mapped this drive on our frist server, as drive Y and have also
> > shared
> >> the
> >> directory.
> >>
> >> Please note: We are able to open the database on both servers through
> > Sybase
> >> Central. We cannot however, connect to the database on both servers, at
> > the
> >> same time. If one server is connected to the databse through Sybase,
the
> >> other
> >> server will receive an error message when trying to open the DB saying
> > that
> >> the
> >> "Specified database is in use".
> >>
> >> Our main concern is being able to connect to the DB from both servers
> >> simultaneously. If this problem can be resolved, we are fine. The web
> >> application requires a database connection through sybase, in order to
> > write
> >> records to the database. There is a Java application on the second
server
> >> which
> >> requires an active connection to the database through sybase, in order
to
> >> run.
> >> The java app connects to the db using JDBC drivers.
> >>
> >> As you can see this creates an issue, if we can only have one system
> >> connected
> >> to the DB through sybase. We have to be able to connect to the same db,
> >> at
> >> the
> >> same time, through both servers in order for all this to work.
> >>
> >>
> >> Any help in this matter would be greatly appreciated, as we are on a
> >> tight
> >> deadline, and need to resolve this problem asap.
> >>
> >> Thanks in advance.
> >>
> >>
> >
> >
>
>


Chris Keating (Sybase iAnywhere) Posted on 2007-06-25 16:29:30.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating@iAnywhere.Dot.com>
User-Agent: Thunderbird 1.5.0.12 (Windows/20070509)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Database Problem
References: <467fd5b6@forums-1-dub>
In-Reply-To: <467fd5b6@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: keating-dm20.sybase.com
X-Original-NNTP-Posting-Host: keating-dm20.sybase.com
Message-ID: <467fed6a$1@forums-1-dub>
Date: 25 Jun 2007 09:29:30 -0700
X-Trace: forums-1-dub 1182788970 10.25.99.119 (25 Jun 2007 09:29:30 -0700)
X-Original-Trace: 25 Jun 2007 09:29:30 -0700, keating-dm20.sybase.com
Lines: 56
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6098
Article PK: 2553

there are a couple of points that I can make for the connection strings
that you provided and the description of the problem:

1) ENG and DBN, while optional, should be provided as best practice both
in engine start lines and connection strings. For connections to remote
engines, ENG should always be provided couples with the communications
link type to be used.
2)Your DSNLess connection is insufficient to make a remote connection.
It is attempting to start a database engine on the local machine. It is
trying to start a file on a network location that is not generally
visible to the IIS service (see point 3 for reason).

You should not run database files over a mapped share. See
http://www.ianywhere.com/developer/technotes/asa_db_file_stored_remotely.html

3) The SYSTEM DSN works as it is visible to the IIS. IIS generally is
run against local system account and it has visiblity only to local
resources i.e., it cannot see mapped drives or User DSNs. The System DSN
is visible to the default IIS setup.

A recommended DSNLess conn str is

"
Driver={SQL Anywhere 10};
Eng=<your database engine name>;
DBN=<your database name>;
LINKS=<your connection protocol i.e., TCPIP>
Uid=<username>;
Pwd=<password>;
"


--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************

Sign up today for your copy of the SQL Anywhere Studio 10 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/downloads/software/sql_anywhere_intro.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************


Avaal Technology Solutions Posted on 2007-06-25 18:11:08.0Z
From: "Avaal Technology Solutions" <admin@avaal.com>
Newsgroups: ianywhere.public.general
References: <467fd5b6@forums-1-dub> <467fed6a$1@forums-1-dub>
Subject: Re: Database Problem
Lines: 73
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
NNTP-Posting-Host: toroon12-1177740551.sdsl.bell.ca
X-Original-NNTP-Posting-Host: toroon12-1177740551.sdsl.bell.ca
Message-ID: <4680053c@forums-1-dub>
Date: 25 Jun 2007 11:11:08 -0700
X-Trace: forums-1-dub 1182795068 70.50.229.7 (25 Jun 2007 11:11:08 -0700)
X-Original-Trace: 25 Jun 2007 11:11:08 -0700, toroon12-1177740551.sdsl.bell.ca
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6101
Article PK: 2557

Hi,

I used the connection string and made the following modifications:

<% ConnString = "Driver={SQL Anywhere
10};eng=acedb;dbn=manifest.db;links=tcpip;Uid=test;Pwd=test;" %>

I got an error message in the browser saying "Database server not found". I
had sybase running and it was connected to the database on the server. The
name of the computer is acedb. Is this the same as the database engine name?

Thanks.

"Chris Keating (Sybase iAnywhere)" <keating@iAnywhere.Dot.com> wrote in
message news:467fed6a$1@forums-1-dub...
> there are a couple of points that I can make for the connection strings
> that you provided and the description of the problem:
>
> 1) ENG and DBN, while optional, should be provided as best practice both
> in engine start lines and connection strings. For connections to remote
> engines, ENG should always be provided couples with the communications
> link type to be used.
> 2)Your DSNLess connection is insufficient to make a remote connection. It
> is attempting to start a database engine on the local machine. It is
> trying to start a file on a network location that is not generally visible
> to the IIS service (see point 3 for reason).
>
> You should not run database files over a mapped share. See
> http://www.ianywhere.com/developer/technotes/asa_db_file_stored_remotely.html
>
> 3) The SYSTEM DSN works as it is visible to the IIS. IIS generally is run
> against local system account and it has visiblity only to local resources
> i.e., it cannot see mapped drives or User DSNs. The System DSN is visible
> to the default IIS setup.
>
> A recommended DSNLess conn str is
>
> "
> Driver={SQL Anywhere 10};
> Eng=<your database engine name>;
> DBN=<your database name>;
> LINKS=<your connection protocol i.e., TCPIP>
> Uid=<username>;
> Pwd=<password>;
> "
>
>
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
>
> *****************************************************************************
>
> Sign up today for your copy of the SQL Anywhere Studio 10 Developer
> Edition =and try out the market-leading database for mobile, embedded and
> small to medium sized business environments for free!
>
> http://www.ianywhere.com/downloads/software/sql_anywhere_intro.html
>
> *****************************************************************************
>
> iAnywhere Solutions http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at http://www.iAnywhere.com/developer
> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> ** Use Case Express to report bugs http://case-express.sybase.com
>
> *****************************************************************************


Luis Porras Posted on 2007-06-25 18:48:42.0Z
From: "Luis Porras" <luis.porras@gmail.com>
Newsgroups: ianywhere.public.general
References: <467fd5b6@forums-1-dub> <467fed6a$1@forums-1-dub> <4680053c@forums-1-dub>
Subject: Re: Database Problem
Lines: 105
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1896
NNTP-Posting-Host: 200.91.79.163
X-Original-NNTP-Posting-Host: 200.91.79.163
Message-ID: <46800e0a$1@forums-1-dub>
Date: 25 Jun 2007 11:48:42 -0700
X-Trace: forums-1-dub 1182797322 200.91.79.163 (25 Jun 2007 11:48:42 -0700)
X-Original-Trace: 25 Jun 2007 11:48:42 -0700, 200.91.79.163
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6102
Article PK: 2558

AFAIK, it should be DB_hostname...

probably, you need to add links=tcpip{host=HOSTNAME}

So it will be something like this:

<% ConnString = "Driver={SQL Anywhere
10};eng=DB_acedb;dbn=manifest.db;links=tcpip{host=acedb};Uid=test;Pwd=test;"
%>

~Luis

"Avaal Technology Solutions" <admin@avaal.com> wrote in message
news:4680053c@forums-1-dub...
> Hi,
>
> I used the connection string and made the following modifications:
>
> <% ConnString = "Driver={SQL Anywhere
> 10};eng=acedb;dbn=manifest.db;links=tcpip;Uid=test;Pwd=test;" %>
>
> I got an error message in the browser saying "Database server not found".
I
> had sybase running and it was connected to the database on the server. The
> name of the computer is acedb. Is this the same as the database engine
name?
>
> Thanks.
>
> "Chris Keating (Sybase iAnywhere)" <keating@iAnywhere.Dot.com> wrote in
> message news:467fed6a$1@forums-1-dub...
> > there are a couple of points that I can make for the connection strings
> > that you provided and the description of the problem:
> >
> > 1) ENG and DBN, while optional, should be provided as best practice both
> > in engine start lines and connection strings. For connections to remote
> > engines, ENG should always be provided couples with the communications
> > link type to be used.
> > 2)Your DSNLess connection is insufficient to make a remote connection.
It
> > is attempting to start a database engine on the local machine. It is
> > trying to start a file on a network location that is not generally
visible
> > to the IIS service (see point 3 for reason).
> >
> > You should not run database files over a mapped share. See
> >
http://www.ianywhere.com/developer/technotes/asa_db_file_stored_remotely.html
> >
> > 3) The SYSTEM DSN works as it is visible to the IIS. IIS generally is
run
> > against local system account and it has visiblity only to local
resources
> > i.e., it cannot see mapped drives or User DSNs. The System DSN is
visible
> > to the default IIS setup.
> >
> > A recommended DSNLess conn str is
> >
> > "
> > Driver={SQL Anywhere 10};
> > Eng=<your database engine name>;
> > DBN=<your database name>;
> > LINKS=<your connection protocol i.e., TCPIP>
> > Uid=<username>;
> > Pwd=<password>;
> > "
> >
> >
> > --
> >
> > Chris Keating
> > Sybase Adaptive Server Anywhere Professional Version 8
> >
> >

****************************************************************************
*
> >
> > Sign up today for your copy of the SQL Anywhere Studio 10 Developer
> > Edition =and try out the market-leading database for mobile, embedded
and
> > small to medium sized business environments for free!
> >
> > http://www.ianywhere.com/downloads/software/sql_anywhere_intro.html
> >
> >
****************************************************************************
*
> >
> > iAnywhere Solutions http://www.iAnywhere.com
> >
> > ** Please only post to the newsgroup
> >
> > ** Whitepapers can be found at http://www.iAnywhere.com/developer
> > ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> > ** Use Case Express to report bugs http://case-express.sybase.com
> >
> >
****************************************************************************
*
>
>


Avaal Technology Solutions Posted on 2007-06-25 19:33:58.0Z
From: "Avaal Technology Solutions" <admin@avaal.com>
Newsgroups: ianywhere.public.general
References: <467fd5b6@forums-1-dub> <467fed6a$1@forums-1-dub> <4680053c@forums-1-dub> <46800e0a$1@forums-1-dub>
Subject: Re: Database Problem
Lines: 121
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
NNTP-Posting-Host: toroon12-1177740551.sdsl.bell.ca
X-Original-NNTP-Posting-Host: toroon12-1177740551.sdsl.bell.ca
Message-ID: <468018a6@forums-1-dub>
Date: 25 Jun 2007 12:33:58 -0700
X-Trace: forums-1-dub 1182800038 70.50.229.7 (25 Jun 2007 12:33:58 -0700)
X-Original-Trace: 25 Jun 2007 12:33:58 -0700, toroon12-1177740551.sdsl.bell.ca
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6103
Article PK: 2556

Hey,

Thanks for the connection string. I think one other problem that I am having
is I don't have the network server setup properly. I noticed when you
install the database it comes with a network server sample. Do you know how
to setup the network server?

Thanks again!

"Luis Porras" <luis.porras@gmail.com> wrote in message
news:46800e0a$1@forums-1-dub...
> AFAIK, it should be DB_hostname...
>
> probably, you need to add links=tcpip{host=HOSTNAME}
>
> So it will be something like this:
>
> <% ConnString = "Driver={SQL Anywhere
> 10};eng=DB_acedb;dbn=manifest.db;links=tcpip{host=acedb};Uid=test;Pwd=test;"
> %>
>
> ~Luis
>
>
> "Avaal Technology Solutions" <admin@avaal.com> wrote in message
> news:4680053c@forums-1-dub...
>> Hi,
>>
>> I used the connection string and made the following modifications:
>>
>> <% ConnString = "Driver={SQL Anywhere
>> 10};eng=acedb;dbn=manifest.db;links=tcpip;Uid=test;Pwd=test;" %>
>>
>> I got an error message in the browser saying "Database server not found".
> I
>> had sybase running and it was connected to the database on the server.
>> The
>> name of the computer is acedb. Is this the same as the database engine
> name?
>>
>> Thanks.
>>
>> "Chris Keating (Sybase iAnywhere)" <keating@iAnywhere.Dot.com> wrote in
>> message news:467fed6a$1@forums-1-dub...
>> > there are a couple of points that I can make for the connection strings
>> > that you provided and the description of the problem:
>> >
>> > 1) ENG and DBN, while optional, should be provided as best practice
>> > both
>> > in engine start lines and connection strings. For connections to remote
>> > engines, ENG should always be provided couples with the communications
>> > link type to be used.
>> > 2)Your DSNLess connection is insufficient to make a remote connection.
> It
>> > is attempting to start a database engine on the local machine. It is
>> > trying to start a file on a network location that is not generally
> visible
>> > to the IIS service (see point 3 for reason).
>> >
>> > You should not run database files over a mapped share. See
>> >
> http://www.ianywhere.com/developer/technotes/asa_db_file_stored_remotely.html
>> >
>> > 3) The SYSTEM DSN works as it is visible to the IIS. IIS generally is
> run
>> > against local system account and it has visiblity only to local
> resources
>> > i.e., it cannot see mapped drives or User DSNs. The System DSN is
> visible
>> > to the default IIS setup.
>> >
>> > A recommended DSNLess conn str is
>> >
>> > "
>> > Driver={SQL Anywhere 10};
>> > Eng=<your database engine name>;
>> > DBN=<your database name>;
>> > LINKS=<your connection protocol i.e., TCPIP>
>> > Uid=<username>;
>> > Pwd=<password>;
>> > "
>> >
>> >
>> > --
>> >
>> > Chris Keating
>> > Sybase Adaptive Server Anywhere Professional Version 8
>> >
>> >
> ****************************************************************************
> *
>> >
>> > Sign up today for your copy of the SQL Anywhere Studio 10 Developer
>> > Edition =and try out the market-leading database for mobile, embedded
> and
>> > small to medium sized business environments for free!
>> >
>> > http://www.ianywhere.com/downloads/software/sql_anywhere_intro.html
>> >
>> >
> ****************************************************************************
> *
>> >
>> > iAnywhere Solutions http://www.iAnywhere.com
>> >
>> > ** Please only post to the newsgroup
>> >
>> > ** Whitepapers can be found at http://www.iAnywhere.com/developer
>> > ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
>> > ** Use Case Express to report bugs http://case-express.sybase.com
>> >
>> >
> ****************************************************************************
> *
>>
>>
>
>


Luis Porras Posted on 2007-06-25 19:48:52.0Z
From: "Luis Porras" <luis.porras@gmail.com>
Newsgroups: ianywhere.public.general
References: <467fd5b6@forums-1-dub> <467fed6a$1@forums-1-dub> <4680053c@forums-1-dub> <46800e0a$1@forums-1-dub> <468018a6@forums-1-dub>
Subject: Re: Database Problem
Lines: 155
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1896
NNTP-Posting-Host: 200.91.79.163
X-Original-NNTP-Posting-Host: 200.91.79.163
Message-ID: <46801c24$1@forums-1-dub>
Date: 25 Jun 2007 12:48:52 -0700
X-Trace: forums-1-dub 1182800932 200.91.79.163 (25 Jun 2007 12:48:52 -0700)
X-Original-Trace: 25 Jun 2007 12:48:52 -0700, 200.91.79.163
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6106
Article PK: 2560

You can use Sybase Central to setup/create the database and the service for
the DB. I use a config file and I put this information in the newly created
service.

The .cfg file has the server information and the database(s) information, it
should be something like this:

-c 290M -p 1490 -x tcpip{DOBROADCAST=NO;HOST=HOSTNAME} -ti 0 -n
DB_HOSTNAME -qi
C:\Databases\db_01.db -m
C:\Databases\db_02.db -m

In the configuration tab, in the service configuration you must write the
executable filename, somthing like this:

"Avaal Technology Solutions" <admin@avaal.com> wrote in message
news:468018a6@forums-1-dub...
> Hey,
>
> Thanks for the connection string. I think one other problem that I am
having
> is I don't have the network server setup properly. I noticed when you
> install the database it comes with a network server sample. Do you know
how
> to setup the network server?
>
> Thanks again!
>
>
> "Luis Porras" <luis.porras@gmail.com> wrote in message
> news:46800e0a$1@forums-1-dub...
> > AFAIK, it should be DB_hostname...
> >
> > probably, you need to add links=tcpip{host=HOSTNAME}
> >
> > So it will be something like this:
> >
> > <% ConnString = "Driver={SQL Anywhere
> >
10};eng=DB_acedb;dbn=manifest.db;links=tcpip{host=acedb};Uid=test;Pwd=test;"
> > %>
> >
> > ~Luis
> >
> >
> > "Avaal Technology Solutions" <admin@avaal.com> wrote in message
> > news:4680053c@forums-1-dub...
> >> Hi,
> >>
> >> I used the connection string and made the following modifications:
> >>
> >> <% ConnString = "Driver={SQL Anywhere
> >> 10};eng=acedb;dbn=manifest.db;links=tcpip;Uid=test;Pwd=test;" %>
> >>
> >> I got an error message in the browser saying "Database server not
found".
> > I
> >> had sybase running and it was connected to the database on the server.
> >> The
> >> name of the computer is acedb. Is this the same as the database engine
> > name?
> >>
> >> Thanks.
> >>
> >> "Chris Keating (Sybase iAnywhere)" <keating@iAnywhere.Dot.com> wrote in
> >> message news:467fed6a$1@forums-1-dub...
> >> > there are a couple of points that I can make for the connection
strings
> >> > that you provided and the description of the problem:
> >> >
> >> > 1) ENG and DBN, while optional, should be provided as best practice
> >> > both
> >> > in engine start lines and connection strings. For connections to
remote
> >> > engines, ENG should always be provided couples with the
communications
> >> > link type to be used.
> >> > 2)Your DSNLess connection is insufficient to make a remote
connection.
> > It
> >> > is attempting to start a database engine on the local machine. It is
> >> > trying to start a file on a network location that is not generally
> > visible
> >> > to the IIS service (see point 3 for reason).
> >> >
> >> > You should not run database files over a mapped share. See
> >> >
> >
http://www.ianywhere.com/developer/technotes/asa_db_file_stored_remotely.html
> >> >
> >> > 3) The SYSTEM DSN works as it is visible to the IIS. IIS generally is
> > run
> >> > against local system account and it has visiblity only to local
> > resources
> >> > i.e., it cannot see mapped drives or User DSNs. The System DSN is
> > visible
> >> > to the default IIS setup.
> >> >
> >> > A recommended DSNLess conn str is
> >> >
> >> > "
> >> > Driver={SQL Anywhere 10};
> >> > Eng=<your database engine name>;
> >> > DBN=<your database name>;
> >> > LINKS=<your connection protocol i.e., TCPIP>
> >> > Uid=<username>;
> >> > Pwd=<password>;
> >> > "
> >> >
> >> >
> >> > --
> >> >
> >> > Chris Keating
> >> > Sybase Adaptive Server Anywhere Professional Version 8
> >> >
> >> >
> >
****************************************************************************
> > *
> >> >
> >> > Sign up today for your copy of the SQL Anywhere Studio 10 Developer
> >> > Edition =and try out the market-leading database for mobile, embedded
> > and
> >> > small to medium sized business environments for free!
> >> >
> >> > http://www.ianywhere.com/downloads/software/sql_anywhere_intro.html
> >> >
> >> >
> >
****************************************************************************
> > *
> >> >
> >> > iAnywhere Solutions http://www.iAnywhere.com
> >> >
> >> > ** Please only post to the newsgroup
> >> >
> >> > ** Whitepapers can be found at http://www.iAnywhere.com/developer
> >> > ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> >> > ** Use Case Express to report bugs http://case-express.sybase.com
> >> >
> >> >
> >
****************************************************************************
> > *
> >>
> >>
> >
> >
>
>


Jeff Albion (iAnywhere Solutions) Posted on 2007-06-25 20:07:09.0Z
From: "Jeff Albion (iAnywhere Solutions)" <firstname.lastname@ianywhere.com>
User-Agent: Thunderbird 2.0.0.0 (Windows/20070326)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Database Problem
References: <467fd5b6@forums-1-dub> <467fed6a$1@forums-1-dub> <4680053c@forums-1-dub> <46800e0a$1@forums-1-dub> <468018a6@forums-1-dub>
In-Reply-To: <468018a6@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: jalbion-xp.sybase.com
X-Original-NNTP-Posting-Host: jalbion-xp.sybase.com
Message-ID: <4680206d$1@forums-1-dub>
Date: 25 Jun 2007 13:07:09 -0700
X-Trace: forums-1-dub 1182802029 10.25.98.200 (25 Jun 2007 13:07:09 -0700)
X-Original-Trace: 25 Jun 2007 13:07:09 -0700, jalbion-xp.sybase.com
Lines: 168
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6108
Article PK: 2561

Here are some tips in getting your server up and running:

============
Point #1:

How is the SA server started? You will need to start the "Database
Server" (dbsrv10), not the "Database Engine" (dbeng10). The database
server allows network connections, whereas the engine only allows local
connections.

See the SA Documentation:

SQL Anywhere® Server - Database Administration > Running the Database
Server > Introduction to running SQL Anywhere database servers
http://www.ianywhere.com/developer/product_manuals/sqlanywhere/1001/en/html/dbdaen10/da-introductionrunning.html

To get it started, you can use a System Service (which can be set up in
Sybase Central, or using the "dbsvc" utility) *OR* start it manually
from the command-line. Here's an example of how to start it via the
command-line. (Start -> Run -> 'cmd')

(On computer with an IP of '192.168.0.1')
>> dbsrv10 -n myengine C:\db\mydatabase.db -n mydatabase

I should then be able to connect to it via a remote machine with the
connection string (DSN-less):

"Driver={SQL Anywhere
10};uid=dba;pwd=sql;eng=myengine;dbn=mydatabase;links=tcpip(host=192.168.0.1)"

If you wanted to use a DSN connection string to connect, you will have
to use a "System DSN" as Chris has already mentioned due to the IIS
server running as the LOCAL SYSTEM account, which cannot access User DSNs.

============
Point #2:

2) Your "DBN" parameter specifies a ".db" on the end of it. This is
incorrect - remove the ".db"

Regards,

--
Jeff Albion, Product Support Analyst
iAnywhere Solutions

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0

Avaal Technology Solutions wrote:
> Hey,
>
> Thanks for the connection string. I think one other problem that I am having
> is I don't have the network server setup properly. I noticed when you
> install the database it comes with a network server sample. Do you know how
> to setup the network server?
>
> Thanks again!
>
>
> "Luis Porras" <luis.porras@gmail.com> wrote in message
> news:46800e0a$1@forums-1-dub...
>> AFAIK, it should be DB_hostname...
>>
>> probably, you need to add links=tcpip{host=HOSTNAME}
>>
>> So it will be something like this:
>>
>> <% ConnString = "Driver={SQL Anywhere
>> 10};eng=DB_acedb;dbn=manifest.db;links=tcpip{host=acedb};Uid=test;Pwd=test;"
>> %>
>>
>> ~Luis
>>
>>
>> "Avaal Technology Solutions" <admin@avaal.com> wrote in message
>> news:4680053c@forums-1-dub...
>>> Hi,
>>>
>>> I used the connection string and made the following modifications:
>>>
>>> <% ConnString = "Driver={SQL Anywhere
>>> 10};eng=acedb;dbn=manifest.db;links=tcpip;Uid=test;Pwd=test;" %>
>>>
>>> I got an error message in the browser saying "Database server not found".
>> I
>>> had sybase running and it was connected to the database on the server.
>>> The
>>> name of the computer is acedb. Is this the same as the database engine
>> name?
>>> Thanks.
>>>
>>> "Chris Keating (Sybase iAnywhere)" <keating@iAnywhere.Dot.com> wrote in
>>> message news:467fed6a$1@forums-1-dub...
>>>> there are a couple of points that I can make for the connection strings
>>>> that you provided and the description of the problem:
>>>>
>>>> 1) ENG and DBN, while optional, should be provided as best practice
>>>> both
>>>> in engine start lines and connection strings. For connections to remote
>>>> engines, ENG should always be provided couples with the communications
>>>> link type to be used.
>>>> 2)Your DSNLess connection is insufficient to make a remote connection.
>> It
>>>> is attempting to start a database engine on the local machine. It is
>>>> trying to start a file on a network location that is not generally
>> visible
>>>> to the IIS service (see point 3 for reason).
>>>>
>>>> You should not run database files over a mapped share. See
>>>>
>> http://www.ianywhere.com/developer/technotes/asa_db_file_stored_remotely.html
>>>> 3) The SYSTEM DSN works as it is visible to the IIS. IIS generally is
>> run
>>>> against local system account and it has visiblity only to local
>> resources
>>>> i.e., it cannot see mapped drives or User DSNs. The System DSN is
>> visible
>>>> to the default IIS setup.
>>>>
>>>> A recommended DSNLess conn str is
>>>>
>>>> "
>>>> Driver={SQL Anywhere 10};
>>>> Eng=<your database engine name>;
>>>> DBN=<your database name>;
>>>> LINKS=<your connection protocol i.e., TCPIP>
>>>> Uid=<username>;
>>>> Pwd=<password>;
>>>> "
>>>>
>>>>
>>>> --
>>>>
>>>> Chris Keating
>>>> Sybase Adaptive Server Anywhere Professional Version 8
>>>>
>>>>
>> ****************************************************************************
>> *
>>>> Sign up today for your copy of the SQL Anywhere Studio 10 Developer
>>>> Edition =and try out the market-leading database for mobile, embedded
>> and
>>>> small to medium sized business environments for free!
>>>>
>>>> http://www.ianywhere.com/downloads/software/sql_anywhere_intro.html
>>>>
>>>>
>> ****************************************************************************
>> *
>>>> iAnywhere Solutions http://www.iAnywhere.com
>>>>
>>>> ** Please only post to the newsgroup
>>>>
>>>> ** Whitepapers can be found at http://www.iAnywhere.com/developer
>>>> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
>>>> ** Use Case Express to report bugs http://case-express.sybase.com
>>>>
>>>>
>> ****************************************************************************
>> *
>>>
>>
>
>


Luis Porras Posted on 2007-06-25 19:51:46.0Z
From: "Luis Porras" <luis.porras@gmail.com>
Newsgroups: ianywhere.public.general
References: <467fd5b6@forums-1-dub> <467fed6a$1@forums-1-dub> <4680053c@forums-1-dub> <46800e0a$1@forums-1-dub> <468018a6@forums-1-dub>
Subject: Re: Database Problem
Lines: 172
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1896
NNTP-Posting-Host: 200.91.79.163
X-Original-NNTP-Posting-Host: 200.91.79.163
Message-ID: <46801cd2$1@forums-1-dub>
Date: 25 Jun 2007 12:51:46 -0700
X-Trace: forums-1-dub 1182801106 200.91.79.163 (25 Jun 2007 12:51:46 -0700)
X-Original-Trace: 25 Jun 2007 12:51:46 -0700, 200.91.79.163
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6107
Article PK: 2562

You can use Sybase Central to setup/create the database and the service for
the DB. I use a config file and I put this information in the newly created
service.

The .cfg file has the server information and the database(s) information, it
should be something like this:

-c 290M -p 1490 -x tcpip{DOBROADCAST=NO;HOST=HOSTNAME} -ti 0 -n
DB_HOSTNAME -qi
C:\Databases\db_01.db -m
C:\Databases\db_02.db -m

In the configuration tab, in the service configuration you must write the
executable filename, somthing like this:

C:\Program Files\SQL Anywhere 10\win32\dbsrv10.exe

In the parameters box (same tab) you must write the full path\filename of
the cfg file:

@"C:\Databases\ConfigDB.cfg"

You can also download the manuals from Sybase site...

HTH

~Luis

P.S.

The last message was incomplete because of an internet connection failure...

Thanks!

"Avaal Technology Solutions" <admin@avaal.com> wrote in message
news:468018a6@forums-1-dub...
> Hey,
>
> Thanks for the connection string. I think one other problem that I am
having
> is I don't have the network server setup properly. I noticed when you
> install the database it comes with a network server sample. Do you know
how
> to setup the network server?
>
> Thanks again!
>
>
> "Luis Porras" <luis.porras@gmail.com> wrote in message
> news:46800e0a$1@forums-1-dub...
> > AFAIK, it should be DB_hostname...
> >
> > probably, you need to add links=tcpip{host=HOSTNAME}
> >
> > So it will be something like this:
> >
> > <% ConnString = "Driver={SQL Anywhere
> >
10};eng=DB_acedb;dbn=manifest.db;links=tcpip{host=acedb};Uid=test;Pwd=test;"
> > %>
> >
> > ~Luis
> >
> >
> > "Avaal Technology Solutions" <admin@avaal.com> wrote in message
> > news:4680053c@forums-1-dub...
> >> Hi,
> >>
> >> I used the connection string and made the following modifications:
> >>
> >> <% ConnString = "Driver={SQL Anywhere
> >> 10};eng=acedb;dbn=manifest.db;links=tcpip;Uid=test;Pwd=test;" %>
> >>
> >> I got an error message in the browser saying "Database server not
found".
> > I
> >> had sybase running and it was connected to the database on the server.
> >> The
> >> name of the computer is acedb. Is this the same as the database engine
> > name?
> >>
> >> Thanks.
> >>
> >> "Chris Keating (Sybase iAnywhere)" <keating@iAnywhere.Dot.com> wrote in
> >> message news:467fed6a$1@forums-1-dub...
> >> > there are a couple of points that I can make for the connection
strings
> >> > that you provided and the description of the problem:
> >> >
> >> > 1) ENG and DBN, while optional, should be provided as best practice
> >> > both
> >> > in engine start lines and connection strings. For connections to
remote
> >> > engines, ENG should always be provided couples with the
communications
> >> > link type to be used.
> >> > 2)Your DSNLess connection is insufficient to make a remote
connection.
> > It
> >> > is attempting to start a database engine on the local machine. It is
> >> > trying to start a file on a network location that is not generally
> > visible
> >> > to the IIS service (see point 3 for reason).
> >> >
> >> > You should not run database files over a mapped share. See
> >> >
> >
http://www.ianywhere.com/developer/technotes/asa_db_file_stored_remotely.html
> >> >
> >> > 3) The SYSTEM DSN works as it is visible to the IIS. IIS generally is
> > run
> >> > against local system account and it has visiblity only to local
> > resources
> >> > i.e., it cannot see mapped drives or User DSNs. The System DSN is
> > visible
> >> > to the default IIS setup.
> >> >
> >> > A recommended DSNLess conn str is
> >> >
> >> > "
> >> > Driver={SQL Anywhere 10};
> >> > Eng=<your database engine name>;
> >> > DBN=<your database name>;
> >> > LINKS=<your connection protocol i.e., TCPIP>
> >> > Uid=<username>;
> >> > Pwd=<password>;
> >> > "
> >> >
> >> >
> >> > --
> >> >
> >> > Chris Keating
> >> > Sybase Adaptive Server Anywhere Professional Version 8
> >> >
> >> >
> >
****************************************************************************
> > *
> >> >
> >> > Sign up today for your copy of the SQL Anywhere Studio 10 Developer
> >> > Edition =and try out the market-leading database for mobile, embedded
> > and
> >> > small to medium sized business environments for free!
> >> >
> >> > http://www.ianywhere.com/downloads/software/sql_anywhere_intro.html
> >> >
> >> >
> >
****************************************************************************
> > *
> >> >
> >> > iAnywhere Solutions http://www.iAnywhere.com
> >> >
> >> > ** Please only post to the newsgroup
> >> >
> >> > ** Whitepapers can be found at http://www.iAnywhere.com/developer
> >> > ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> >> > ** Use Case Express to report bugs http://case-express.sybase.com
> >> >
> >> >
> >
****************************************************************************
> > *
> >>
> >>
> >
> >
>
>


Jeff Albion (iAnywhere Solutions) Posted on 2007-06-25 20:16:45.0Z
From: "Jeff Albion (iAnywhere Solutions)" <firstname.lastname@ianywhere.com>
User-Agent: Thunderbird 2.0.0.4 (Windows/20070604)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Database Problem
References: <467fd5b6@forums-1-dub> <467fed6a$1@forums-1-dub> <4680053c@forums-1-dub> <46800e0a$1@forums-1-dub> <468018a6@forums-1-dub> <46801cd2$1@forums-1-dub>
In-Reply-To: <46801cd2$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: jalbion-xp.sybase.com
X-Original-NNTP-Posting-Host: jalbion-xp.sybase.com
Message-ID: <468022ad$1@forums-1-dub>
Date: 25 Jun 2007 13:16:45 -0700
X-Trace: forums-1-dub 1182802605 10.25.98.200 (25 Jun 2007 13:16:45 -0700)
X-Original-Trace: 25 Jun 2007 13:16:45 -0700, jalbion-xp.sybase.com
Lines: 197
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6109
Article PK: 2563

Thanks Luis for this information. There is only one thing I'd like to
comment on, and that is the use of the -m switch on the lines below.

iAnywhere does not recommend running with this switch as this can impede
recovery options in the case of media failure. You should only run with
this switch if you have a strong backup solution, or you don't care
about recovering your data in the case of corruption of the main .db file.

My recommendation would be to change the line:

C:\Databases\db_01.db -m

to simply:

C:\Databases\db_01.db

See the manual for more information:

SQL Anywhere® Server - Database Administration > The Database Server >
The SQL Anywhere database server > Database server options > -m server
option

http://www.ianywhere.com/developer/product_manuals/sqlanywhere/1001/en/html/dbdaen10/da-m-database-dbengine.html

Regards,

--
Jeff Albion, Product Support Analyst
iAnywhere Solutions

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0

Luis Porras wrote:
> You can use Sybase Central to setup/create the database and the service for
> the DB. I use a config file and I put this information in the newly created
> service.
>
> The .cfg file has the server information and the database(s) information, it
> should be something like this:
>
> -c 290M -p 1490 -x tcpip{DOBROADCAST=NO;HOST=HOSTNAME} -ti 0 -n
> DB_HOSTNAME -qi
> C:\Databases\db_01.db -m
> C:\Databases\db_02.db -m
>
> In the configuration tab, in the service configuration you must write the
> executable filename, somthing like this:
>
> C:\Program Files\SQL Anywhere 10\win32\dbsrv10.exe
>
> In the parameters box (same tab) you must write the full path\filename of
> the cfg file:
>
> @"C:\Databases\ConfigDB.cfg"
>
> You can also download the manuals from Sybase site...
>
> HTH
>
> ~Luis
>
> P.S.
>
> The last message was incomplete because of an internet connection failure...
>
> Thanks!
>
>
> "Avaal Technology Solutions" <admin@avaal.com> wrote in message
> news:468018a6@forums-1-dub...
>> Hey,
>>
>> Thanks for the connection string. I think one other problem that I am
> having
>> is I don't have the network server setup properly. I noticed when you
>> install the database it comes with a network server sample. Do you know
> how
>> to setup the network server?
>>
>> Thanks again!
>>
>>
>> "Luis Porras" <luis.porras@gmail.com> wrote in message
>> news:46800e0a$1@forums-1-dub...
>>> AFAIK, it should be DB_hostname...
>>>
>>> probably, you need to add links=tcpip{host=HOSTNAME}
>>>
>>> So it will be something like this:
>>>
>>> <% ConnString = "Driver={SQL Anywhere
>>>
> 10};eng=DB_acedb;dbn=manifest.db;links=tcpip{host=acedb};Uid=test;Pwd=test;"
>>> %>
>>>
>>> ~Luis
>>>
>>>
>>> "Avaal Technology Solutions" <admin@avaal.com> wrote in message
>>> news:4680053c@forums-1-dub...
>>>> Hi,
>>>>
>>>> I used the connection string and made the following modifications:
>>>>
>>>> <% ConnString = "Driver={SQL Anywhere
>>>> 10};eng=acedb;dbn=manifest.db;links=tcpip;Uid=test;Pwd=test;" %>
>>>>
>>>> I got an error message in the browser saying "Database server not
> found".
>>> I
>>>> had sybase running and it was connected to the database on the server.
>>>> The
>>>> name of the computer is acedb. Is this the same as the database engine
>>> name?
>>>> Thanks.
>>>>
>>>> "Chris Keating (Sybase iAnywhere)" <keating@iAnywhere.Dot.com> wrote in
>>>> message news:467fed6a$1@forums-1-dub...
>>>>> there are a couple of points that I can make for the connection
> strings
>>>>> that you provided and the description of the problem:
>>>>>
>>>>> 1) ENG and DBN, while optional, should be provided as best practice
>>>>> both
>>>>> in engine start lines and connection strings. For connections to
> remote
>>>>> engines, ENG should always be provided couples with the
> communications
>>>>> link type to be used.
>>>>> 2)Your DSNLess connection is insufficient to make a remote
> connection.
>>> It
>>>>> is attempting to start a database engine on the local machine. It is
>>>>> trying to start a file on a network location that is not generally
>>> visible
>>>>> to the IIS service (see point 3 for reason).
>>>>>
>>>>> You should not run database files over a mapped share. See
>>>>>
> http://www.ianywhere.com/developer/technotes/asa_db_file_stored_remotely.html
>>>>> 3) The SYSTEM DSN works as it is visible to the IIS. IIS generally is
>>> run
>>>>> against local system account and it has visiblity only to local
>>> resources
>>>>> i.e., it cannot see mapped drives or User DSNs. The System DSN is
>>> visible
>>>>> to the default IIS setup.
>>>>>
>>>>> A recommended DSNLess conn str is
>>>>>
>>>>> "
>>>>> Driver={SQL Anywhere 10};
>>>>> Eng=<your database engine name>;
>>>>> DBN=<your database name>;
>>>>> LINKS=<your connection protocol i.e., TCPIP>
>>>>> Uid=<username>;
>>>>> Pwd=<password>;
>>>>> "
>>>>>
>>>>>
>>>>> --
>>>>>
>>>>> Chris Keating
>>>>> Sybase Adaptive Server Anywhere Professional Version 8
>>>>>
>>>>>
> ****************************************************************************
>>> *
>>>>> Sign up today for your copy of the SQL Anywhere Studio 10 Developer
>>>>> Edition =and try out the market-leading database for mobile, embedded
>>> and
>>>>> small to medium sized business environments for free!
>>>>>
>>>>> http://www.ianywhere.com/downloads/software/sql_anywhere_intro.html
>>>>>
>>>>>
> ****************************************************************************
>>> *
>>>>> iAnywhere Solutions http://www.iAnywhere.com
>>>>>
>>>>> ** Please only post to the newsgroup
>>>>>
>>>>> ** Whitepapers can be found at http://www.iAnywhere.com/developer
>>>>> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
>>>>> ** Use Case Express to report bugs http://case-express.sybase.com
>>>>>
>>>>>
> ****************************************************************************
>>> *
>>>>
>>>
>>
>
>


Luis Porras Posted on 2007-06-25 20:36:54.0Z
From: "Luis Porras" <luis.porras@gmail.com>
Newsgroups: ianywhere.public.general
References: <467fd5b6@forums-1-dub> <467fed6a$1@forums-1-dub> <4680053c@forums-1-dub> <46800e0a$1@forums-1-dub> <468018a6@forums-1-dub> <46801cd2$1@forums-1-dub> <468022ad$1@forums-1-dub>
Subject: Re: Database Problem
Lines: 225
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1896
NNTP-Posting-Host: 200.91.79.163
X-Original-NNTP-Posting-Host: 200.91.79.163
Message-ID: <46802766$1@forums-1-dub>
Date: 25 Jun 2007 13:36:54 -0700
X-Trace: forums-1-dub 1182803814 200.91.79.163 (25 Jun 2007 13:36:54 -0700)
X-Original-Trace: 25 Jun 2007 13:36:54 -0700, 200.91.79.163
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6110
Article PK: 2564

I agree with you, the configuration I sent you was from one of the test
servers I have.

Thanks!

"Jeff Albion (iAnywhere Solutions)" <firstname.lastname@ianywhere.com> wrote
in message news:468022ad$1@forums-1-dub...
> Thanks Luis for this information. There is only one thing I'd like to
> comment on, and that is the use of the -m switch on the lines below.
>
> iAnywhere does not recommend running with this switch as this can impede
> recovery options in the case of media failure. You should only run with
> this switch if you have a strong backup solution, or you don't care
> about recovering your data in the case of corruption of the main .db file.
>
> My recommendation would be to change the line:
>
> C:\Databases\db_01.db -m
>
> to simply:
>
> C:\Databases\db_01.db
>
> See the manual for more information:
>
> SQL Anywhere® Server - Database Administration > The Database Server >
> The SQL Anywhere database server > Database server options > -m server
> option
>
>
http://www.ianywhere.com/developer/product_manuals/sqlanywhere/1001/en/html/dbdaen10/da-m-database-dbengine.html
>
> Regards,
>
> --
> Jeff Albion, Product Support Analyst
> iAnywhere Solutions
>
> iAnywhere Developer Community : http://www.ianywhere.com/developer
> iAnywhere Documentation :
http://www.ianywhere.com/developer/product_manuals
> ASA Patches and EBFs :
>
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
>
> Luis Porras wrote:
> > You can use Sybase Central to setup/create the database and the service
for
> > the DB. I use a config file and I put this information in the newly
created
> > service.
> >
> > The .cfg file has the server information and the database(s)
information, it
> > should be something like this:
> >
> > -c 290M -p 1490 -x tcpip{DOBROADCAST=NO;HOST=HOSTNAME} -ti 0 -n
> > DB_HOSTNAME -qi
> > C:\Databases\db_01.db -m
> > C:\Databases\db_02.db -m
> >
> > In the configuration tab, in the service configuration you must write
the
> > executable filename, somthing like this:
> >
> > C:\Program Files\SQL Anywhere 10\win32\dbsrv10.exe
> >
> > In the parameters box (same tab) you must write the full path\filename
of
> > the cfg file:
> >
> > @"C:\Databases\ConfigDB.cfg"
> >
> > You can also download the manuals from Sybase site...
> >
> > HTH
> >
> > ~Luis
> >
> > P.S.
> >
> > The last message was incomplete because of an internet connection
failure...
> >
> > Thanks!
> >
> >
> > "Avaal Technology Solutions" <admin@avaal.com> wrote in message
> > news:468018a6@forums-1-dub...
> >> Hey,
> >>
> >> Thanks for the connection string. I think one other problem that I am
> > having
> >> is I don't have the network server setup properly. I noticed when you
> >> install the database it comes with a network server sample. Do you know
> > how
> >> to setup the network server?
> >>
> >> Thanks again!
> >>
> >>
> >> "Luis Porras" <luis.porras@gmail.com> wrote in message
> >> news:46800e0a$1@forums-1-dub...
> >>> AFAIK, it should be DB_hostname...
> >>>
> >>> probably, you need to add links=tcpip{host=HOSTNAME}
> >>>
> >>> So it will be something like this:
> >>>
> >>> <% ConnString = "Driver={SQL Anywhere
> >>>
> >
10};eng=DB_acedb;dbn=manifest.db;links=tcpip{host=acedb};Uid=test;Pwd=test;"
> >>> %>
> >>>
> >>> ~Luis
> >>>
> >>>
> >>> "Avaal Technology Solutions" <admin@avaal.com> wrote in message
> >>> news:4680053c@forums-1-dub...
> >>>> Hi,
> >>>>
> >>>> I used the connection string and made the following modifications:
> >>>>
> >>>> <% ConnString = "Driver={SQL Anywhere
> >>>> 10};eng=acedb;dbn=manifest.db;links=tcpip;Uid=test;Pwd=test;" %>
> >>>>
> >>>> I got an error message in the browser saying "Database server not
> > found".
> >>> I
> >>>> had sybase running and it was connected to the database on the
server.
> >>>> The
> >>>> name of the computer is acedb. Is this the same as the database
engine
> >>> name?
> >>>> Thanks.
> >>>>
> >>>> "Chris Keating (Sybase iAnywhere)" <keating@iAnywhere.Dot.com> wrote
in
> >>>> message news:467fed6a$1@forums-1-dub...
> >>>>> there are a couple of points that I can make for the connection
> > strings
> >>>>> that you provided and the description of the problem:
> >>>>>
> >>>>> 1) ENG and DBN, while optional, should be provided as best practice
> >>>>> both
> >>>>> in engine start lines and connection strings. For connections to
> > remote
> >>>>> engines, ENG should always be provided couples with the
> > communications
> >>>>> link type to be used.
> >>>>> 2)Your DSNLess connection is insufficient to make a remote
> > connection.
> >>> It
> >>>>> is attempting to start a database engine on the local machine. It is
> >>>>> trying to start a file on a network location that is not generally
> >>> visible
> >>>>> to the IIS service (see point 3 for reason).
> >>>>>
> >>>>> You should not run database files over a mapped share. See
> >>>>>
> >
http://www.ianywhere.com/developer/technotes/asa_db_file_stored_remotely.html
> >>>>> 3) The SYSTEM DSN works as it is visible to the IIS. IIS generally
is
> >>> run
> >>>>> against local system account and it has visiblity only to local
> >>> resources
> >>>>> i.e., it cannot see mapped drives or User DSNs. The System DSN is
> >>> visible
> >>>>> to the default IIS setup.
> >>>>>
> >>>>> A recommended DSNLess conn str is
> >>>>>
> >>>>> "
> >>>>> Driver={SQL Anywhere 10};
> >>>>> Eng=<your database engine name>;
> >>>>> DBN=<your database name>;
> >>>>> LINKS=<your connection protocol i.e., TCPIP>
> >>>>> Uid=<username>;
> >>>>> Pwd=<password>;
> >>>>> "
> >>>>>
> >>>>>
> >>>>> --
> >>>>>
> >>>>> Chris Keating
> >>>>> Sybase Adaptive Server Anywhere Professional Version 8
> >>>>>
> >>>>>
> >
****************************************************************************
> >>> *
> >>>>> Sign up today for your copy of the SQL Anywhere Studio 10 Developer
> >>>>> Edition =and try out the market-leading database for mobile,
embedded
> >>> and
> >>>>> small to medium sized business environments for free!
> >>>>>
> >>>>> http://www.ianywhere.com/downloads/software/sql_anywhere_intro.html
> >>>>>
> >>>>>
> >
****************************************************************************
> >>> *
> >>>>> iAnywhere Solutions http://www.iAnywhere.com
> >>>>>
> >>>>> ** Please only post to the newsgroup
> >>>>>
> >>>>> ** Whitepapers can be found at http://www.iAnywhere.com/developer
> >>>>> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> >>>>> ** Use Case Express to report bugs http://case-express.sybase.com
> >>>>>
> >>>>>
> >
****************************************************************************
> >>> *
> >>>>
> >>>
> >>
> >
> >


Chris Keating (Sybase iAnywhere) Posted on 2007-06-26 01:45:25.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating@iAnywhere.Dot.com>
User-Agent: Thunderbird 1.5.0.12 (Windows/20070509)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Database Problem
References: <467fd5b6@forums-1-dub> <467fed6a$1@forums-1-dub> <4680053c@forums-1-dub> <46800e0a$1@forums-1-dub> <468018a6@forums-1-dub> <46801cd2$1@forums-1-dub>
In-Reply-To: <46801cd2$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: cpe001217e36468-cm0014e8868e10.cpe.net.cable.rogers.com
X-Original-NNTP-Posting-Host: cpe001217e36468-cm0014e8868e10.cpe.net.cable.rogers.com
Message-ID: <46806fb5$1@forums-1-dub>
Date: 25 Jun 2007 18:45:25 -0700
X-Trace: forums-1-dub 1182822325 72.143.69.7 (25 Jun 2007 18:45:25 -0700)
X-Original-Trace: 25 Jun 2007 18:45:25 -0700, cpe001217e36468-cm0014e8868e10.cpe.net.cable.rogers.com
Lines: 26
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6111
Article PK: 2566

Please take caution in using -m as it impairs recoverability.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************

Sign up today for your copy of the SQL Anywhere Studio 10 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/downloads/software/sql_anywhere_intro.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************


Chris Keating (Sybase iAnywhere) Posted on 2007-06-26 01:48:02.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating@iAnywhere.Dot.com>
User-Agent: Thunderbird 1.5.0.12 (Windows/20070509)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Database Problem
References: <467fd5b6@forums-1-dub> <467fed6a$1@forums-1-dub> <4680053c@forums-1-dub> <46800e0a$1@forums-1-dub>
In-Reply-To: <46800e0a$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: cpe001217e36468-cm0014e8868e10.cpe.net.cable.rogers.com
X-Original-NNTP-Posting-Host: cpe001217e36468-cm0014e8868e10.cpe.net.cable.rogers.com
Message-ID: <46807052$1@forums-1-dub>
Date: 25 Jun 2007 18:48:02 -0700
X-Trace: forums-1-dub 1182822482 72.143.69.7 (25 Jun 2007 18:48:02 -0700)
X-Original-Trace: 25 Jun 2007 18:48:02 -0700, cpe001217e36468-cm0014e8868e10.cpe.net.cable.rogers.com
Lines: 29
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6112
Article PK: 2565

DBN is the database name not the file name. So, remove the .db is a
very likely reason why you may encounter problems.

Please post your engine start line so that we can provide a solution
that is specific to your configuration.
--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************

Sign up today for your copy of the SQL Anywhere Studio 10 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/downloads/software/sql_anywhere_intro.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************