ODBC Drivers - Where do they go once you've installed them?

[da.Guvna]

Hi guys,

Question is in the title really.

I'm trying to extract some data from HP OpenView NNM running on a server via MS Access on my local machine.
The server has the correct ODBC driver installed, but I don't have enough Office licenses to be able to install MS Access on the server itself, so I need to somehow get that driver installed on my own machine so I can connect across the network.
I was hoping I might be able to just find the driver on the server HDD, copy it to my local machine, and then install it.

I've done some digging, and it seems that I need to get hold of the ODBC driver for IBM/SolidTech's SolidDB, but I can't find it for download ANYWHERE....very frustrating.

Bit of a shot in the dark here, but just hoping that someone browsing these forums might have some experience with OpenView?

Cheers!

[directhex]

the odbc control panel is disabled by default - unhide it with tweakui, and you can access the odbc area properly

[da.Guvna]

Haha, that wasn't really what I was asking.

You can access the ODBC panel from Admin Tools anyway, so I don't really know what use TweakUI is for that.

What I wanted to know is....when you install an ODBC driver for the first time (and I'm not talking about setting up DSNs here), where does the physical file get put?

[TheAnimus]

ah ODBC, what happens when software is developed with the best of design patterns badly, very very badley.....

Basically their almost always in %SystemRoot%\System32, however.

Nowadays you should check the registry key for the respective driver

HKEY_CURRENT_USER\Software\ODBC\ODBC.INI

For the user level settings.... not the .ini of the key name, thats a clue to the horrible legacy crap (which i belive was 3.11 erea, i was only 9 at the time so let me off if i'm wrong on that).

You should always install using the APIs thou.

What is it your trying to do, manually copy these files across? (is that legal, licenses and all?)
If so its goign to be some trail and error with the registry i'm affriad. It should be as simple as copying that registry key, but you need to make sure you get all teh dependancies (dependancywalker can help with that) but any extra config, thats been placed in a stupid place, won't help any.

[da.Guvna]

Thanks Animus, that's what I was after.

Turns out, after all that messing around (posting here was my absolute last ditch effort) I found a much better way of achieving the result I needed.

Basically, I needed to extract the tables, views, and data from the OpenView DB running on my Dev server into an Access DB on my local PC so that I could have a play around with it (trying to get our software to perform some queries on the OpenView structure.)

Turns out, I found a way of extracting everything into our SQL server using the standard SQL ODBC driver, which is where I would have wanted to go with the Access thing eventually anyway, so hoorah!

[TheAnimus]

Horrah! moving away from access is often a very good sign

[da.Guvna]

Haha, yeah

It was only supposed to be used as a quick 'n dirty 10 minute mess about.....*sigh*

[directhex]

Horrah! moving away from access is often a very good sign

even a move from access to mysql?

[Agent]

even a move from access to mysql?

[TheAnimus]

even a move from access to mysql?

Often a good sign... Not always.

Now where did i put that tuna net.