Creating DSN while installing

RainMan
08-17-2002, 01:48 PM
I have created an database application using VB and Access 2000. In the program I have created connection to the database using DSN (Data Source Names).I am wondering that when I install the application on the end Users system i will have to create the DSN on his system too. How can I include the DSN creation code(I know the code) so that it runs when the application is installed. Will it be OK if I include the DSN creating code in the Package and Deployment forms (by editing them offcourse.). ?

Or is it a better idea to use OLE connections to the database? How can I gaurd againts errors arising if the user changes the name of the folder that contains the database.

Thanks

Thinker
08-17-2002, 03:45 PM
OLEDB provider connections are always better if you can do them.
At the least, it removes the ODBC layer which just slows things
down.

There isn't any practical way to include DSN installation in the
P&DW. Ideally, you would include the code in the app itself, and
when it is run for the first time, it would go ahead and create the
DSN.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum