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

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

connection odbc

asked 26 Jul '12, 15:35

Introuble
31●1●1●3
accept rate: 0%

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?

(26 Jul '12, 16:12) Graeme Perrow

flat view

3 Answers:

active answers oldest answers newest answers popular answers

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

permanent link

answered 27 Jul '12, 03:22

Martin
9.0k●130●169●257
accept rate: 14%

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

(27 Jul '12, 03:41) Daz Liquid

flat view

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:

alt text

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

permanent link

answered 27 Jul '12, 05:35

Justin Willey
7.6k●137●179●249
accept rate: 20%

flat view

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.

permanent link

answered 27 Jul '12, 07:57

Robert2
91●3●4●8
accept rate: 0%

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

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

connection ×159
odbc ×145

question asked: 26 Jul '12, 15:35

question was seen: 10,392 times

last updated: 27 Jul '12, 09:43

SAP SQL Anywhere

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

Follow this question

Related questions