Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Connection failed: Database server not found

1,596 views
Skip to first unread message

Krishna

unread,
Dec 17, 2002, 1:24:41 PM12/17/02
to
Receiving following error message while connecting using ODBC Test
Connection.

'Connection failed: Database server not found'

Network: Windows-NT, SQLAnywhere studio (10 user) 8.0.1 version.

Servername, startline everything is as it should be. Even for asa8demo
client is not getting connected.

Anyhelp is greately appreciated.

Thanks,

Chris Keating

unread,
Dec 17, 2002, 8:42:37 PM12/17/02
to
What specifically are your odbc settings?

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8
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 CaseXpress to report bugs http://casexpress.sybase.com

<Krishna> wrote in message
news:FCB81A8D2839D30C0065231485256C92.0065232585256C92@webforums...

Krishna.

unread,
Dec 18, 2002, 11:17:34 AM12/18/02
to
ODBC entry details:

DSN name for example DSN_ONE
on the Database tab, server name DSN_ONE
at Start line:
C:\Program Files\Sybase\SQL Anywhere 8\win32\dbeng8.exe -c 8m

on the client pc, only server name is given. There are two ODBC entries
(two databases) a PB application is using. Second one is created similar to
first one as...

DSN name for example DSN_TWO
on the Database tab, server name DSN_TWO
at Start line:
C:\Program Files\Sybase\SQL Anywhere 8\win32\dbeng8.exe -c 8m

Only one ODBC entry is getting connected, not the other.


Any help is greately appreciated.

Thanks,

Wayne A. Darby

unread,
Dec 31, 2002, 10:46:02 AM12/31/02
to
In my experience if you have a servername in the servername line in the
database tab and you have a the startline filled in it will not work. Try
taking the server name out and testing the connection. This should then
work.

<Krishna.> wrote in message
news:A99ECBD6BE43485C00597FB985256C93.000D466285256C93@webforums...

Scott

unread,
Dec 16, 2004, 7:31:35 PM12/16/04
to
Krishna,

If I understand the situation, you're starting two personal database
services on a server machine (by making an ODBC connection to each),
and connecting to those services from a client machine. Clever, but it
seems like you would need to run a network database service to do this
(based upon dbsrv8.exe rather than dbeng8.exe). The service can be
created and managed interactively through SQL Central or through the
dbsvc command-line utility.

As for the reply about leaving a personal-server name blank (in the
ODBC parameters along with the dbeng8.exe start line), I don't think
that's required. In fact, server names can come in handy: if you want
to connect simultaneously to a number of databases with non-unique
names (in different folders), just give each of them a unique server
name, and they'll all run at once.

--Scott

Krishna. wrote:
> ODBC entry details:
>
> server name: DSN_ONE
> Start line: ...dbeng8.exe...
>
> server name: DSN_TWO
> Start line: ...dbeng8.exe...
>
> Only one client ODBC entry is getting connected, not the other.

Scott

unread,
Dec 16, 2004, 7:32:58 PM12/16/04
to
Krishna,

--Scott

> Only one client ODBC entry is getting connected, not the other.

0 new messages