Re: ODBC (32 bit) and win95 problem

On 11 Jun 1996 22:54:40 GMT, username_at_qualcomm.com (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:

I'm trying to do much the same using Excel to connect to Oracle, but I have not been able to D/L the ODBCW95.EXE Self extracting Executable. Is this what you have?? If it is then I would be very greatful if you could post it to this ng. My E-Mail will not accept such a large file.
I will be connecting to an Oracle 7.0.13 Database on our server. Are you running Personal Oracle7 for Windows '95??

I believe that the MS Office Professional for Win95 will not work with the 16bit drivers, 'cos I'm having the same problem. Hence the need for the win95 ODBC. If you let me have the programs, I will try to get it to work here and let you know the results.

regards,

David Lester
dave.j.lester_at_wg.waii.com Received on Wed Jun 12 1996 - 00:00:00 CEST