ODBC configuration

[Pat]

Hi
I am using the InstallODBC.ini file to configure a DSN as described in the Knowledge Base article that explains this process. The install works just fine but the DSN gets configured as a UserDSN and I need it as a SystemDSN. Where or how do I alter this parameter?

[Mark]

Re: ODBC configuration

Hi,
You should use: ODBC_CONFIG_SYS_DSN instead of: ODBC_ADD_DSN.

mark.

[Pat]

Re: ODBC configuration

Hi Mark
Just tried your suggestion and, on shutdown when I run the InstallODBC.exe, I got an error that InstallODBC.exe cannot be executed - when I looked at the folder that I created, I saw that the .exe was not installed into this folder, along with the .ini file and a bunch of others, whereas before I made the change from ODBC_ADD_DSN to ODBC_CONFIG_SYS_DSN, I got no problems apart from the DSN being configured as UserDSN instead of SystemDSN...here's the InstallODBC.ini script...

[IndigoRose]
ID=IRINSTODBC
Desc=Indigo Rose ODBC Configuration Utility
Copyright=Copyright (c) 1999 Indigo Rose Corporation
License=Please contact Indigo Rose Corporation for licensing info
Info=http://www.indigorose.com

[Settings]
MyChat
Title=Configuring ODBC
LoadMessage=Configuring ODBC Drivers...

[InstallManager]
Install=0

[Drivers]
Driver1=Microsoft Access Driver (*.mdb)\0Driver=odbcjt32.dll\0Setup=odbcjt32.dll\0 FileUsage=1\0FileExtns=*.mdb\0APILevel=1\0ConnectF unctions=YYN\0CPTimeout=60\0DriverODBCVer=02.50\0s =YYN\0SQLLevel=0\0\0

[Data Sources]
DSDriver1=Microsoft Access Driver (*.mdb)
DSAttrib1=DSN=MyChat\0DBQ=D:\Inetpub\wwwroot\MyCha t\Database\MyChat.mdb\0UID=\0UserCommitSync=Yes\0T hreads=3\0SafeTransactions=0\0PageTimeout=5\0MaxSc anRows=8\0MaxBufferSize=2048\0 FIL=MS Access\0DriverId=25\0\0
DSRequest1=ODBC_CONFIG_SYS_DSN


This doesn't work, however, with DSRequest1=ODBC_ADD_DSN, it works but writes to UserDSN instead of SystemDSN.

Any thoughts?...

ps I repeated the install several times to check and it's the same each time...

[Pat]

Re: ODBC configuration

Hi Mark...OK...I have found my error...if I use ODBC_ADD_SYS_DSN everything's fine...sorry to bug you!!