Create Setup for TopSpeed ODBC Driver

[NewsArchive]

I would like to create an installation that includes installing the TopSpeed
ODBC Driver. I have purchased the reseller license but I am not sure about
what SetupBuilder settings I need. Has anyone done this?

Peter Gysegem
Beaver Creek Software

[NewsArchive]

Hi Peter,

>I would like to create an installation that includes installing the TopSpeed
>ODBC Driver. I have purchased the reseller license but I am not sure about
>what SetupBuilder settings I need. Has anyone done this?

Installing an ODBC driver is fairly simple, it's all registry
settings. You copy the driver dll to a folder and then in the
registry you set up the right entries for it.

You install the driver to
HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI

You need two keys there, one in "ODBC Drivers" and the other one is
the name of the driver you are installing. For example I have in ODBC
Drivers:

Value: Adaptive Server Anywhere 9.0
Data: Installed

Then in the HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI\Adap tive
Server Anywhere 9.0 I have:

Value: CPTimeout
Data: <not pooled>

Value: Driver
Data: C:\TheDatabasePathASA9\dbodbc9.dll

Value: Setup
Data: C:\TheDatabasePathASA9\dbodbc9.dll

That's it. This installs the SQL Anywhere driver for SQL Anywhere
9.0. Obviously you need to install the .dll also.

I'd install it on your machine and see exactly what keys and values
are written to those two keys.

ODBC connection are then created in the
HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI key. There is an option to
do that in SB, but I did it using the registry and it's very easy to
do. Just create a demo connection on your machine and then look at
how it was created in the registry key and it's simple to duplicate:)

Best regards,

Arnór Baldvinsson
Icetips Creative, Inc.
San Antonio, Texas, USA
www.icetips.com


Subscribe to information from Icetips.com:
http://www.icetips.com/subscribe.php

[NewsArchive]

Peter,

You can do this with the ODBC Driver functions. You can even automaticaly
import the settings from your machine into the SB6 project.

Check the "ODBC Driver Visualizer". And of course, there are various other
built-in ODBC drier functions. For example: "Config ODBC Data Source...",
"Delete ODBC Data Source...", "Delete ODBC Driver...", "Delete ODBC
Translator...", "Install ODBC Driver...", "Install ODBC Translator...".

You can also do this via registry manipulation, but I would suggest to use
the ODBC functions. They directly call the Windows ODBC APIs.

Does this help?

Friedrich

[NewsArchive]

Hi Friedrich,

>Translator...", "Install ODBC Driver...", "Install ODBC Translator...".

Cool! Been so long since I did this (using SB5.0 at the time:) that I
haven't looked at all the goodies in later versions:)

>You can also do this via registry manipulation, but I would suggest to use
>the ODBC functions. They directly call the Windows ODBC APIs.

I agree. Back when I was doing this I ran into some problems with it
in SB5 so I just did it in the registry - not exactly rocket
science<g> But I'd strongly recommend doing it the easy and lazy
way<g>

Best regards,

Arnór Baldvinsson
Icetips Creative, Inc.
San Antonio, Texas, USA
www.icetips.com


Subscribe to information from Icetips.com:
http://www.icetips.com/subscribe.php

[NewsArchive]

Friedrich and Arnor,

Thanks, that is pretty much what I thought but wasn't sure.

Peter Gysegem
Beaver Creek Software