ODBC Resources Installshield
I am working with an installer which queries the oracle or sql server based on user input and gives the list of servers... SQLLogin dialog. But I am unable to understand ODBC Resources view. Helpnet even doesn't provide complete information. How can I add a dsn to an exixting database or is it querying for a new database connection . Any help appreciated. This would make me more than clear about installshield.
Answers (1)
The UI allows you to create DNS entries linked to a specific driver.
Try capturing the manual creation (odbcad32.exe) of the entry you would like, this should give you the fields you'd want to add to the entry.
The above being said, I've personally always preferred to capture DNS entries directly into the registry, since they're independent of the driver.
Comments:
-
I still didn't get your answer. I played with various things in installshield but not aware how ODBC Resources work. If you could elaborate i would be pleased. I need to connect to sql Database on the client computer. How could i sort out using odbc resources... What exactly does it query. Never got a chance to work on it before... - mareddy9999 10 years ago
-
like I said, try making an msi from capturing the changes you want on a test machine. I'm pretty sure the required added fields differ for different connection types (oracle/sql/..)
so just start repack.exe - make a connection of the type you want - stop capture
Open the resulting irp file, and in Advanced Settings make sure you select 'Map registry data to the appropriate ODBC tables'
This will give you a nice 'template' ism that you can use to get your package the way you want it. - pjgeutjens 10 years ago
