I'm trying to setup an ODBC datasource as a SYSTEM DSN, rather than a User DSN (which is the default).
First, I created a new project using an ODBC-DAO Template. Then, I edited the "_drivers" script file under the "Setup" tab by doing the following:
Going to my datasource section and ADDING the field: ISODBCDSNType=system.
I then compile and run my program, but it still only sets the DSN as a User DSN, despite the change I made above.
Do you have any advice to this? Have you experienced this at all, and if so, how do you get around it? Below is the EXACT copy of my _driver section for reference:
[Sample Data Source]
Description=This data source used for testing.
ISODBCDriverDesc=Microsoft Access Driver (*.mdb)
Driver=<WINSYSDIR>\odbcjt32.dll
DSN=TESTING
DefaultDir=
DBQ=<TARGETDIR>\sampledb.mdb
UID=
ISODBCUninstDSN=TRUE
ISODBCComponentName=ISODBC Drivers\Microsoft Access Driver
ISODBCDSNType=system
I am using a Windows 2000 system and InstallShield 5.5 Professional.
Let me know if you can help me.
Jeff
email- jeff@scimage.com