Re: ODBC (32 bit) and win95 problem

Mix and match doesn't work. 16 bit for 16 bit. 32 bit for 32 bit. You're trying to use Access 2.0, which is 16 bit, with 32 bit drivers. Upgrade to Access 7.0 or reinstall sql*net and odbc drivers for 16 bit.

username wrote:
>
> I am not new to Oracle but novice to ODBC. Currently this is what I have
> 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
>
> Registry shows:
>
> default value not set
> driver c:\orawin95\odbc\sqo32_72.dll
> orahelp c:\orawin95\mshelp\drvora32.hlp
> setup c:\orawin95\sqo32s72.dll
>
> 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.
>
> 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:
>
> 1. 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 Sun Jun 16 1996 - 00:00:00 CEST