System DSN

[jmatte]

I've created a system DSN to access a SQLServer 2000 database. I need to access this DSN in an ActiveX DLL that uses ADO. I've tried using a connection string dsn=__;uid=__;pw=__ but that couldn't find the system DSN I created.

What is the correct syntax for doing this?

Thanks in advance for your help.

 

[SUNRlSE]

Hi there,
Try

objCN.Open "DSN=" & sDSN & ";UID=" & sUserID & ";PWD=" & sPassword

hope that helps

:¿)