[AccessD] Creating a DSN via code

I suggest that you:

1.  Use the DSN wizard that you get in Control Pane\ODBC to make a file DSN
for your SQL Server link.  Save it where you can find it.  This gets you a
working Connection string the easy way.
2.  Open the file DSN with notepad and make the contents the body of a
DSN-less Connection string in your code.  It sounds like it can be
completely canned and the same for all your workstations.


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jeffrey
Majchrzak
Sent: Friday, April 09, 2004 11:03 AM
To: accessD at databaseadvisors.com
Subject: [AccessD] Creating a DSN via code


I have an application that is going to have the backend upsized to SQL
Server 2000.  This application sits on about 50 desktops.  Would anyone have
any code examples that I can view to create a DSN connection?  The DSN will
have the same username and password for all users so I would like the code
to auto fill the username and password when creating the DSN.



Thank you in advance for all your help.



Jeffrey Majchrzak

Empire Computer Consulting

--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com