I would just like to know once and for all...how do you add SQL Server DSNs using the ODBC table. I know some attribute names:

Server = servername
Description = name of DSN
Database = name of default database

However I cannot find the attribute names for the following:

The description field of the DSN
The username field (it is not UID or LastUser as I have tried these among others)

I would really appreciate if someone could let me know what are the names of these attributes that I need to use in the ODBC table - I would prefer to not have to use registry settings to create the DSNs.

0 Comments   [ - ] Hide Comments


Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity


Hi David,
One trick I use when repackaging an app that uses ODBCs connections is that I don't repackage them, I manually add those ODBCs in my host machine, where I edit the msi (ism), and add them by the editor after repackaging.
After that, I can delete the unneeded ODBCs from my machine, but the ism-msi still gots them.

Hope it helps :)

Answered 02/12/2007 by: KrisBcn
Purple Belt

Please log in to comment

Some attributes cannot be set by the ODBC tables. I think UID and LastUser are among them. For these attributes, you have no choice but to set them via the registry (somebody correct me if I'm wrong).

Only certain attributes can be set via the ODBC tables. Server, Description, and Database are certainly among of them. (Description, BTW, is the attribute for the DSN description; the DSN name is a key name, not a separate attribute.)

If someone could post a list of all of the allowable (and maybe some of the disallowed) attributes for an ODBC entry, that would be welcome.

Answered 02/18/2007 by: mazessj
Blue Belt

Please log in to comment