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 |
Quicklist of things to check:
|
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. |
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. 1
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 :)
(27 Jul '12, 09:43)
Breck Carter
|
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?