Setting up the ODBC connection using ASA 9.0.2 driver

[picklespeach]

I have a Sybase ASA 9.0.2 database on a server in a remote location. I want to setup an ODBC connection to that database on my workstation. I have the driver on my workstation, but I can't get the connection to work. The error I get is "Connection failed: database server not found." Which implies that it doesn't know where the server is. I know nothing about Sybase and this driver is completely foreign to me. It's just not as straightforward as say, Oracle or SQL Server ODBC connections. I'm sure that there's just something that I don't know how to define, but I don't know what. I don't even know what I don't know. And now I'm rambling. Any advice?

 

[mrdenny]

You should start by checking the connectivity from your workstation to the database server. Here is an FAQ which should cover the basics faq962-5481. It's written for SQL Server but should be mostly the same.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[picklespeach]

Thank you, mrdenny. My connection to the server from my workstation is fine. It's not the technical aspect of the connection that alludes me. It's the proper configuration of the driver that I'm having trouble with.

For instance, on the Network tab I have selected TCP/IP as the protocol and defined the host as:

host=w2k3-viewpoint:49163

where w2k3-viewpoint is the name of the server and 49163 is the port on which the database listens. I can ping that server by name and I can telnet to the port. But, is this the proper syntax to use in the driver?

 

[mrdenny]

This site has a list of connection strings for Sybase perhaps this can shed some light on the subject.

http://www.connectionstrings.com/?carrier=sybase

I see in one of the examples it uses a "," instead of a ":".

Perhaps that will help?

I see on another page that the port is a seperate flag in the connection string "Server Port Address=5001". That may help.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[picklespeach]

Well, I've come back to this again after dropping it for a while. The link you sent was good, but still it won't find the database server.

 

[mrmitchmitchell]

Try replacing the server name in the TCP/IP box with the ip address of the server.
Host=192.168.XX.XX;MyIP=NONE;ServerPort=49163;TO=45
On the database tab, put in the server name.
On the login tab, put your username and password.
Click test connection on the ODBC tab and see what you get.
Mitch