Multiple DSN

Hi I need a program to create multiple DSN on a server.

Please let me know if anyone can help
-rohan
LVL 7
rohanbairat3Asked:
Who is Participating?
 
rohanbairat3Author Commented:
Thanks ,

The DSN is getting created but then after creation i try to check it and it says test failed ????

How can i test the DSN ????

Also my sql odb is set up on server authentication mode ...and in the code i never provide a password.

please let me know

-rohan
0
 
rohanbairat3Author Commented:
Thanks I can create it now ...

-rohan
0
 
EDDYKTCommented:
>>How can i test the DSN ????


You need to use ADO to test it

>>Also my sql odb is set up on server authentication mode ...and in the code i never provide a password.

You can use DSN-less instead of using DSN

http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForSQLServer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.