How to use the ODBC Table to add an SQL Server DSN
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.
Thanks!
David
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.
Thanks!
David
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
KrisBcn
17 years ago
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 :)
KrisBcn
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 :)
KrisBcn
Posted by:
mazessj
17 years ago
David,
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.
--Josh
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.
--Josh
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
