Sybase 6.0 Connection String!

[johnvai]

Dear friends:

the connection string in VB6 that I am using to connect to sybase 5.0.5 database is:
Db.ConnectionString = "Provider=MSDASQL.1;Password=6things;Persist Security Info=True;User ID=dba;Data Source=POS"

but while trying to open a sybase 6 database the same conenction is not working and giving microsoft error.

can you help me please?
thanks

 

[VDavid]

Im not sure with ASA 6, but i've been using this with ASA 5.5 and ASA 7 and it works for me.
(Taking your data)

 UID = "dba"
 PWD = "6things"
 OpenString = "PROVIDER=MSDASQL.1;DSN=POS;"
 DataEnvironment1.Connection1.Open OpenString, UID, PWD

For more info on the DataEnvironment and security, you should refer to the vb6 forum.

Hope this helps,

David.