DSN

[Jamie]

Hello

How can I make a User DSN or System DSN with VBA??


Thanks

 

[JAmie]

Hi,

The only problem is : it didn't accept UID and PWD ??? my
SQL SERVER require UID and PWD

any idea

 

[Douglas J. Steele]

The second site Dan listed includes UID and PWD in its code.

 

[Jamie]

Hi Doug,

I test the code but the Create DSN Failed, the code test
the connection before creating the DSN

Did you test this code?

Thanks

 

[Douglas J. Steele]

I don't use DSNs: I go DSN-less.

See http://members.rogers.com/douglas.j.steele/DSNLessLinks.html (in
conjunction with the information about Connection Strings at Carl Prothman's
http://www.able-consulting.com/ado_conn.htm )