SB installing an ODBC DSN

[NewsArchive]

Trying to create an installer which will create a Clarion TPS ODBC DSN, for
..NET data import purposes.

I assume I use:
1. Install ODBC driver, followed by
2. Configure ODBC source

This I have done - attached pic. shows dialog.
But there is NO subsequent entry for the TPS-based DSN on the target
computer.

I have tried System and non-system DSNs...

I'm doing something wrong?

Steve

[NewsArchive]

Steve,

Data Source Attributes have to be exactly as described in the ODBC manual
for that driver. Otherwise, Windows can't "register" it.

Friedrich

[NewsArchive]

IIRC, you have to enable the "Display Configuration Dialogs" for that
TopSpeed read-only driver.

Friedrich

[NewsArchive]

Similar to the attached screenshots (licensed ODBC driver, not the
"developer only" version)

Friedrich

[NewsArchive]

And a link to an interesting reading:

http://www.caraworks.com/Articles/UseCSWithTPSFiles.htm#SampleConnectionString

Friedrich

[NewsArchive]

Now that *is* interesting... thanks!

Steve Bywaters

[NewsArchive]

Friedrich

Many thanks for this tip..

Naturally, it didn't work at first <g>- but it led me down a path which bore
fruit.

On some machines I was getting driver error 126 - tho' I knew the driver was
there and the Registry was correctly set.
At last I thought of checking dependencies - found that the TPS ODBC DLL
driver requires OTSW32.DLL (whatever the hell that is)... missing.

Copied the file over, and its now working - can read TPS in .NET
(Perhaps this may help someone else struggling to escape the confines of TPS
via ODBC......)

Tx!
Steve

[NewsArchive]

Steve,

Cool. Glad it's working fine now!!! :-)

Friedrich

[NewsArchive]

I specifically turned that 'off' because it threw an error otherwise... I'm
getting a bad feeling <g>

Steve

[NewsArchive]

Couldn't find anything that specific in the manual - so I copied them from
the Registry of a machine where the ODBC that was working...

Steve