Error creating File DSN

[rbelcher]

Hello, I am trying to connect to the symposium dataviews via a VB application. When trying to create a File DSN I get the following error:

[SYBASE[]ODBC Sybase driver][Sybase]ct_connect(): user api layer: internal Client Library error: HAFAILOVER: Trying to connect to server.

I have the correct database name, id, and pw. I get this same error trying to create a User DSN and in my DSN-less connection string in my VB app. I have symposium installed on my machine and everything works fine. I can also connect to the data via Microsoft Access using the Machine System DSN (ICCM_PREVIEW_DSN); however, I receive the error above if I try to use the connection string :

strConnect = "DSN=ICCM_PREVIEW_DSN;" & _
"Uid=***;" & _
"Pwd=***"

Any help is appreciated. Thanks.

Randy

 

[Supernn]

Is this entry correct in the SQL.INI? Otherwise it doesn't work.
If you have a Novell network you should also install the drivers within Sybase for Novell Netware.

 

[Gobla]

Hey

You have to add ICCM_PREVIEW in DSEDIT. For ip address, but the symposium server address then a comma and the port number which is 5000. This should allow you to connect.