PDA

View Full Version : ODBC - USER/SYSTEM DSNs



Rakeshp
11-05-2001, 09:28 AM
We are currently using Express version 2.13. Our software requires a DSN to be set up for connectivity to an access database.

The problem is with the user/system dsn install shield creates. If we set up a user DSN, with the correct data source name and description (both are the name of the program) the software runs OK.

If a different user logs onto the system, the software does not work.

Thus we created a system dsn in installshield for the set up profile. But this creates a DSN with a data source name as 'MS Access Database' and not the name of the program, and thus the software fails to run.

Does anyone have any ideas or are we being silly?

Thankyou in advance.