ODBC (32 bit) and win95 problem
Date: 1996/06/11
Message-ID: <4pktfg$mfg_at_qualcomm.com>#1/1
I am not new to Oracle but novice to ODBC. Currently this is what I have
on my PC.
Registry shows:
My aim is to access oracle data in Access. Right now I am able to access
a host of Oracle databases using the SQL*NET and hence there is nothing
wrong with that. Acutally the whole story started like this:
First I installed ODBC driver which came with windows 3.1 ( 16 bit).
After creating datasource etc., somehow I was not able to access any
database including the database on my pc.
win95
Oracle 7.2.2.3.1
SQL*NET Add-on 2.2.2.1.0
SQL*NET Client 2.2.2.1.0
ODBC driver 1.13.5.0.0.A
MS Access 2.0
default value not set
driver c:\orawin95\odbc\sqo32_72.dll
orahelp c:\orawin95\mshelp\drvora32.hlp
setup c:\orawin95\sqo32s72.dll
So I thought that 16 bit ODBC driver will not work under win95 and hence downloaded 32bit one from Oracle and installed. I have removed the installed 16bit driver in MS Access. I created datasource through control panel->odbc (32bit). But I cannot see the datasource in MS Access.So what my problem is
how to see the datasource in MS Access what is the step by step procedure to setup ODBC and other settings to access the oracle tables in MS Access.
thanks in advance
I have included some of related ODBC files below:
- ODBCE.INI
[ODBC Data Sources]
MS Access 2.0 Databases=Access 2.0 for MS Office (*.mdb)
Student Registration=Access Data (*.mdb)
[Student Registration]
Driver=C:\WINDOWS\SYSTEM\simba.dll
FileType=RedISAM
DataDirectory=D:\MSVC\MFC\SAMPLES\ENROLL\STDREG.MDB
SingleUser=False
UseSystemDB=False
[ODBC]
TraceAutoStop=1
Trace=0
TraceFile=\SQL.LOG
[ODBC 32 bit Data Sources]
TEST=Oracle72 (32 bit)
[TEST]
Driver32=C:\ORAWIN95\ODBC\sqo32_72.dll
2. ODBCINST.INI
[ODBC Drivers]
Access 2.0 for MS Office (*.mdb)=Installed
Access Data (*.mdb)=Installed
dBase Files (*.dbf)=Installed
FoxPro Files (*.dbf)=Installed
[Access 2.0 for MS Office (*.mdb)]
Driver=C:\WINDOWS\SYSTEM\ODBCJT16.DLL
Setup=C:\WINDOWS\SYSTEM\ODBCJT16.DLL
[Access Data (*.mdb)]
Driver=C:\WINDOWS\SYSTEM\simba.dll
Setup=C:\WINDOWS\SYSTEM\simadmin.dll
FileUsage=2
FileExtns=*.mdb
DirectConnect=0
[dBase Files (*.dbf)]
Driver=C:\WINDOWS\SYSTEM\simba.dll
Setup=C:\WINDOWS\SYSTEM\simadmin.dll
FileUsage=1
FileExtns=*.dbf
DirectConnect=0
[FoxPro Files (*.dbf)]
Driver=C:\WINDOWS\SYSTEM\simba.dll
Setup=C:\WINDOWS\SYSTEM\simadmin.dll
FileUsage=1
FileExtns=*.dbf
DirectConnect=0
[Microsoft Access Driver (*.mdb) (32 bit)]
Driver=C:\WINDOWS\SYSTEM\odbcjt32.dll
Setup=C:\WINDOWS\SYSTEM\odbcjt32.dll
32Bit=1
[ODBC 32 bit Drivers]
Microsoft Access Driver (*.mdb) (32 bit)=Installed
Microsoft Excel Driver (*.xls) (32 bit)=Installed
[Microsoft Excel Driver (*.xls) (32 bit)]
Driver=C:\WINDOWS\SYSTEM\odbcjt32.dll
Setup=C:\WINDOWS\SYSTEM\odexl32.dll
32Bit=1
3. ODBCEISAM.INI
[Installable ISAMS]
RedISAM=red110.dll
Received on Tue Jun 11 1996 - 00:00:00 CEST