Vb & Sybase Conectivity

[Sundar]

Hi guys,


I am trying to connect Sybase (System 11 on AIX) from VB.

I am using VB4 (16-bit).


I have setup an ODBC (32-bit), with the datasource as 'mydatabase'.


While connecting from VB, I am getting the following error

ODBC-- Connection to 'mydatabase' failed.


the connection string that I am using is

sConnect = "ODBC;DSN=mydatabase;UID=myname;PWD=mypwd;DATABASE=mydatabase'"

set db = OpenDatabase("",False,False,sconnect)


I can connect to Sybase thru ISQL. But I am unable to

connect it thru MS-Access or VB4.


Thanx in advance

Sundar

mail to: sunda@ecomm.com.sg