c00lbeans
07-08-2003, 12:50 PM
Hi
I am using a DSN (Con.Open "dsn=testconnection") to connect to a database on a shared drive.
When i run the package and depolyment wizard, is there a way i can include this DSN file along wih it. Otherwise it gives me an error if i try to install on another machine. Or do i have to go and create the DSN on each and every machine where i depoly??
Is it better to use the entire directory path to connect to the database rather than using DSN??
thanks
Sam
I am using a DSN (Con.Open "dsn=testconnection") to connect to a database on a shared drive.
When i run the package and depolyment wizard, is there a way i can include this DSN file along wih it. Otherwise it gives me an error if i try to install on another machine. Or do i have to go and create the DSN on each and every machine where i depoly??
Is it better to use the entire directory path to connect to the database rather than using DSN??
thanks
Sam