ODBC (32 bit) and win95 problem

From: username <username_at_qualcomm.com>
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.

	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 Tue Jun 11 1996 - 00:00:00 CEST

Original text of this message