Re: ODBC for Personal Oracle 7

Gilles,
You may want to go to Oracle's Home Page. There you can download for free the
32 bit ODBC drivers. Also, check out the installation file provided to ensure you set up
the drivers correctly. By the way, use "2:" for your connect string. Actually, your sample
code may look like (this is for Visual Basic --I think it's the same syntax as ACCESS)

           Private Sub Form_Load()
               Dim db as Database
               Dim ds as Recordset
               Dim conn as String

              conn$ = "ODBC;DSN=PO7;Database=2:;UID=SCOTT;PWD=TIGER"
             
             Set db = OopenDatabase("PO7",False,False,conn$)
             Set ds = db.openrecordset("select * from emp")
        End Sub

However, I don't think that will solve your current problem with the "ORA-03121" error.
Depending on which version of Personal Oracle you are using, you may need to run
a additional setup script to be able to use 16 bit software with the 32 bit database. I
don't really remember where this script is. I think for the Windows95 installation, it was
in a windows subdirectory under the Windows95 install directory. In any case look at
some of the readme files and they should point you in the right direction.

Hope this info is of use to you. Good Luck.

Gilles TRAN <tran_at_inapg.inra.fr> wrote in article <329DEC44.3A49_at_inapg.inra.fr>...
> Hello
> I just bought Personal Oracle 7 for Windows NT3.51 Workstation and tried
> to setup the OBDC driver to use Access or Excel as front-ends (on the
> same computer). I first discovered that the OBDC driver was only for
> 16-bit software (not usable with Access 7 for intance) but I still can't
> access the Oracle database from the 16-bit Access 2 or other 16-bit
> software. All I got is the following message (when trying to attach a
> table for instance) :
>
> "ORA-03121 no interface driver connected - function not performed".
>
> The TNSlistener service is started and Oracle is working fine.
> The connect string for the ODBC driver is "2:" (even tried "TNS:2").
>
> There's probably some piece missing but I can't figure it out, even
> after reading the Oracle tips and hints about OBDC drivers.
> Anyone has an idea ? It must be pretty obvious since my configuration is
> (I think) basic.
>
> Thanks in advance
>
> Oracle version 7.2.2.4.0
> SQL*NET Client 2.2.2.10A
> SQL*NET Server 2.2.2.10A
> Oracle OBDC Driver 1.11.0.5.0 and 1.11.1.5.0
>
> Gilles Tran
> Association Francaise de Zootechnie
> French Feed Database
>
  Received on Mon Dec 02 1996 - 00:00:00 CET