DSN

Jamie · Aug 13, 2003

Hello

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

Thanks

JAmie · Aug 13, 2003

Hi,

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

any idea

Douglas J. Steele · Aug 13, 2003

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

Jamie · Aug 13, 2003

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 · Aug 16, 2003

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 )