Setting up Oracle ODBC driver (1.11.0002) ?

From: Pedro Pimentel <ppf_at_uninova.pt>
Date: 1995/04/17
Message-ID: <3mtuh0$crl_at_asterix.uninova.pt>#1/1

  I'm trying to use the ODBC driver that came with PO7 to connect to a Unix based Oracle 7 server.

  The ODBC driver is version 1.11.0002 (Oracle71).

  The configuration files are like this:

  ODBCINST.INI:

---

[ODBC Drivers]

SQL Server=Installed
Access 2.0 for MS Office (*.mdb)=Installed Oracle7=Installed
Oracle71=Installed
....
[Oracle7]

Driver=C:\WINDOWS\SYSTEM\sqora7.dll
Setup=C:\WINDOWS\SYSTEM\sqorast7.dll

[Oracle71]

Driver=C:\WINDOWS\SYSTEM\sqora71.dll
Setup=C:\WINDOWS\SYSTEM\sqoras71.dll

[MS Code Page Translator]

Translator=C:\WINDOWS\SYSTEM\mscpxlt.dll Setup=C:\WINDOWS\SYSTEM\mscpxlt.dll

[ODBC Translators]

MS Code Page Translator=Installed

  ODBC.INI:

---

[ODBC Data Sources]

MS Access 2.0 Databases=Access 2.0 for MS Office (*.mdb) IPPAR=Oracle7
IPPAR2=Oracle71
...
[IPPAR]

Driver=C:\WINDOWS\SYSTEM\sqora7.dll
Server=T:(IP ADDRESS)/1525:base
userID=IPPAR

[IPPAR2]

Driver=C:\WINDOWS\SYSTEM\sqora71.dll
Server=T:(IP ADDRESS)/1525:base
userID=IPPAR2

  When I try to connect to the IPPAR2 data source I get the following error message:

SQLSTATE:IM003
Native Error Code:0
Driver Message: [Microsoft][ODBC DLL] Driver specified by data source could not be loaded

--
Pedro Pimentel
Faculdade de Ciencias e Tecnologia / Universidade Nova de Lisboa - Portugal
           e-mail: ppf_at_uninova.pt
              www: http://terra.uninova.pt/pedro/pedro1.html
Benfica Home Page: http://terra.uninova.pt/pedro/slb/slbindex.html

Received on Mon Apr 17 1995 - 00:00:00 CEST