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

asked 26 Jul '12, 15:35

Introuble's gravatar image

Introuble
31113
accept rate: 0%

3

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

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's gravatar image

Martin
8.6k116150237
accept rate: 14%

2

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

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

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%20Willey's gravatar image

Justin Willey
6.7k108138208
accept rate: 20%

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's gravatar image

Robert2
91348
accept rate: 0%

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
Your answer
toggle preview

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

Question tags:

×125
×124

question asked: 26 Jul '12, 15:35

question was seen: 4,738 times

last updated: 27 Jul '12, 09:43