PDA

View Full Version : Setup Data Source On Install



NewsArchive
01-11-2017, 03:09 AM
Hi All

Question - when installing an app on a computer I need to be able to
setup the MS Access data source with login and password. Has anyone
done this with SetupBuilder?

Cheers
Andre

NewsArchive
01-11-2017, 03:09 AM
Hi Andre,

> Question - when installing an app on a computer I need to be able to
> setup the MS Access data source with login and password. Has anyone
> done this with SetupBuilder?

I have not done it with Access, but I have with SQL Anywhere. It's
actually just a couple of registry keys that are added and Friedrich has
a Create ODBC data source action to help with it:) I think the only
thing you need to know is the name of the driver. If you are installing
the driver as well, then you need to know the location of the ODBC
driver DLL and you're good to go.

Take a look at the "HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC" key in
the registry to see how it's all hooked together.

The installed datasources are enumerated in the
"HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBC. INI\ODBC Data
Sources" key.

The installed drivers are enumerated in the
"HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBCI NST.INI\ODBC Drivers"
key.

Best regards,


--
Arnor Baldvinsson
Icetips Alta LLC

NewsArchive
01-11-2017, 08:08 AM
Hi Arnor

Thanks for that. I have solved it with DSN-Less and a connection string
but will certainly be filing this advice away in case I need it going
forward.

Cheers
Andre

NewsArchive
01-11-2017, 08:09 AM
Hi Andre,

the MS Access documentation should list the exact name/value pairs used to
provide additional configuration parameters for the DSN. Similar to the
screenshots in the "Config ODBC Data Source" function in the manual. Some
years ago I have done it for TopSpeed/SoftVelocity TPS ODBC and SQL
Anywhere.

Friedrich

NewsArchive
01-12-2017, 04:14 AM
Thanks Friedrich.

Andre Labuschagne