.. MS Access 97 .. ODBC inst. probs.

.

.. hello helpful people ...


.. I am trying to install MS Access 97 on to my machine at work .. and it won't install because of an ODBC problem. There is a problem at the end of the installation .. -- The config. of the ODBC Microsoft Access Driver (*.mdb) driver failed.

.. I've tried to configure the ODBC settings myself and can't even create new ones .. it says,

-=-=-=-
-- The setup routines for Microsoft Access Driver (*.mdb) ODBC driver could not be loaded due to system error code 1157.
-=-=-=-

.. after clicking the above warning .. it says,

-=-=-=-
-- could not load the setup or translator library
-=-=-=-


.. I've tried so much already ... installing most recent MDAC files from Microsoft .. I've used several different copies of MS Access.

.. installed MDAC (v.2.6) ... and tried installing MS Access 97 again .. same error :

-- configuration of ODBC driver failed.

.--.--.--.--.--.--.--.

.. my settings for Microsoft Access Driver (*.mdb) seem to be correct (files that are stated are in correct location).

.. but I have another folder in ODBCINST.INI .. and it is the only one that has files in a different location.

-- Client Access ODBC Driver (32-bit):

DRIVER = "C:\sqllib\bin\db2cli.dll"
SETUP = "C:\sqllib\bin\db2odbc.dll"

* neither of these files exist on my machine .. neither do the folders for that matter ... thinking I should create such files and folders .. or change the path of.



(feeling hopeless on this one)


* any help would be GREATLY appreciated.


> running windows 98 on some crap system.


.. thanks.

 

A search for that error message came up with a few answers on on Google, though (predictably) zero on MS. At least you can know that you are not alone.

You might go and make sure you have the "right" version of MDAC. (There are many to choose from, god bless 'em.)

Several of the other sites mention using 2.5SP1 to resolve the problem, for what it's worth. I'd just keep trying MDAC versions until something clicks.

Or wait for someone who's seen this baby before to come around.