Software Deployment

Do you have the ODBC information in the Registry table AS WELL AS the ODBC tables?

Thanks Brent,
I had to drop this for a while as I was not making any progress, yes I do have ODBC information in the registry, ODBCAttribute and ODBCDriver, is this wrong?

Hi,

You should either handle ODBC driver installation through the proper ODBC tables or via the registry and file tables - the registry table should contain the required \SOFTWARE\ODBC\ODBC.INI and \SOFTWARE\ODBC\ODBCINST.INI entries and the file table containing and driver files required over and above those provided with the OS (e.g. for Oracle databases).

Probably easiest to just use the proper tables via the Wise / Installshield GUI unless you have a reason to do it the other way... Out of interest which forum post were you reading about using the reistry table to setup ODBC?

Hope this helps,
Rob.

Hi,
I got it from this link
http://itninja.com/question/sequence-question7[/link]

I research this when I first installed and the package hung at the ODBC stage, so importing the registry values did not make a difference, well did not improve things

OK well try dropping the entries in the ODBCAttribute and ODBCDriver tables, but make sure you have any required driver files (e.g. sqora32.dll, sqoras32.dll, sqresus.dll) included in your install..

Regards,
Rob.

Yeah, you can only add ODBC entries to a computer using one of the ways (either by the registry table or the ODBC tables.)

Hi,
Thanks Rob and Mr Hunter, sorry that it has taken me some time to respond but every time I tried to access a message from work i got a some kind of VB script error I think our firewall now prevents me from accessing the messages. I could only see the topic page but not the messages. Anyway , I did remove the entries from ODBCAttribute and ODBCDriver and it worked, though I came across other errors which i am now trying to resolve.
Thanks
Tony

What other errors are you getting now?

Two of the most common errors are when you don't include the 'driver' or 'setup' registry values in the ODBC.INI or ODBCINST.INI registry keys.

Also, if installing ODBC drivers, make sure that you also add the Driver Name into the 'ODBC Drivers' registry key.