Adaptive Server Anywhere V9 ODBC Connection failed: Database Server not found

[Former Member]

None of my workstations can connect to an Adaptive Server Anywhere V9 database. The application connects to the database when executed off the server. All workstations give me an error as follows:

ODBC Connection failed: Database Server not found

[graeme_perrow]

We'll need some more information before we can help you. What is the connection string being used by the client application? What is the start line you use when starting the server?

[MCMartin]

Quicklist of things to check:

• is the server really running
• is the server using the server name you have specified in ODBC (or more general everything configured well?)
• are server and clients using tcp/ip
• any firewall blocking the access on the server or client
• is the server reachable from the client (try using ping)
• is the server in a different network, then most often the broadcast packets by SQLA will not go through
• any network switch in between which is blocking broadcasts

[former_SQLA_member1694874]

and maybe check it's running using dbsrv9.exe and not dbeng9.exe.

[Former Member]

Assuming your server is up and running check your connection string includes "Links=tcpip(Host=servername);" if the database server resides on a different subnet to the client.

http://www.connectionstrings.com/sybase-adaptive#p40

I think the provider will normally discover the IP address of a database server on the same subnet but won't be able to on a different subnet.

[Breck_Carter]

An entire website devoted to connection strings! ...that just made my day ...I will never again feel that I am being too focussed or too specialized 🙂

[justin_willey]

Something that can quickly help narrow down which of the possible problems Martin and Daz mention apply to your situation is to turn on the odbc driver's logging facility:

This gives detailed information - if the problem isn't then obvious, do post the results here to see if anyone can help further.