Problems with ODBC creation

[BruceMcK]

Hi,

Can anyone help with adding SQL Server ODBC entries. I'm trying to add a new ODBC (DSN) entry modified from an existing DSN on my system, but when I run the installer, it reports:

ODBC error 8: Invalid keyword-value pairs. Verify that the file exists and you can access it.

The attributes are:

Server=[MYSERVER]
Database=[MYDATABASE]
LastUser=[MYUSER]

where $MYSERVER$, $MYDATABASE$ and $MYUSER$ are all variable in my MSI script.

I also tried adding an existing ODBC entry, unmodified, but the didn't work either.

I have MDAC 2.8 SP1 as a pre-requisite in the installer.

Any suggestions?

Cheers, Bruce.

[MichaelNesmith]

Did you specify the remaining fields correcty? If so, please post a minimum setup that illustrates the issue so we can take a look at it.

[BruceMcK]

Michael,

My test setup is enclosed. What I've done is create a new install project with the wizard, and I've then added a single DSN entry by selecting an existing DSN from the 'Data Source Name' combo box.

After posting, I managed to work around the problem by including one line only in the Attributes box:

Server=[MYSERVER]

As soon as I did this, the installer was able to create the DSN on the target machine for me.

Cheers, Bruce.

File Attached:

OdbcTest.ZIP

[MichaelNesmith]

I see. I suppose the other fields were not supported then for some reason on the target system?

[BruceMcK]

Michael,

Is there any way to trap errors with DSN creation? I'm still seeing an intermittent problem with creation on Win2000 Svr and Win2003 Svr. The DSNs are either created or not, but the installer never throws an error.

The systems are logged in with admin rights, and MDAC 2.8 is a pre-req for the installer.

Cheers,

Bruce.

[MichaelNesmith]

I'd use logging on those systems to find out what's going on...