Personal Oracle and VB4 
Author Message
 Personal Oracle and VB4

Is there a way to use Personal Oracle with VB4.
I have Personal Oracle 7.2. I tried to add a datasource with the
Oracle ODBC Driver that comes with VB. But each time I try, get a
dialog that tell me that Oracle client and networking component are
not installed. In fact I did a complete installation. I looked at this
SQL*Net thing, and it is just a configuration utility. I'm downloading
the 8 Meg ODBC driver from oracle we will see if that works. I have
the impression that it is not possible to use Personal Oracle v7.2 to
do development.

This is my first experience with an Oracle product, I usually use MS
SQL Server and Sybase to do development. I am really not impressed. If
I can't even connect to it how am I supposed to use the damn thing. I
don't understand, Oracle is supposed to be THE biggest database
corporation. Everyone and their grandmother is ODBC compliant but not
oracle?

If you have any information on this, please let me know.

Regards,
Stephen Remillard

Montreal, Quebec, Canada



Tue, 16 Feb 1999 03:00:00 GMT  
 Personal Oracle and VB4

I am new to Oracle as well but I was able to connect to a Local Personal oracle
DB via ODBC. I downloaded the 8 meg driver and set up the source. Instead of
useing a  connection string say "t:someIp:DBname" I used 2: and it worked (no
idea why). If you need more information email me directly and I'll look deeeper
into my configureation.
Doug Erwin
Brio technology



Tue, 16 Feb 1999 03:00:00 GMT  
 Personal Oracle and VB4

Quote:

>Is there a way to use Personal Oracle with VB4.
>I have Personal Oracle 7.2. I tried to add a datasource with the
>Oracle ODBC Driver that comes with VB. But each time I try, get a
>dialog that tell me that Oracle client and networking component are
>not installed. In fact I did a complete installation. I looked at this
>SQL*Net thing, and it is just a configuration utility. I'm downloading
>the 8 Meg ODBC driver from oracle we will see if that works. I have
>the impression that it is not possible to use Personal Oracle v7.2 to
>do development.

The Oracle 32-bit driver works fine with PO7, except that it does not
support remote data objects.  The Intersolv driver also works with PO7
and does support remote data objects.  You do not need SQL*Net with
Personal Oracle.  Just make sure your connect string is "2:" when you
set up your data source.


Thu, 18 Feb 1999 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. VB4 and ODBC for Personal Oracle 7.2 Win95

2. VB4 and ODBC for Personal Oracle 7.2 Win95

3. VB4 ODBC to Personal Oracle?

4. How to get ADO to connect to Personal Oracle 8

5. Visual C++ 6.0 / Personal Oracle (Windows)

6. Personal Oracle 8 and Visual Studio 6 problem

7. How to connect Personal Oracle with RDC

8. ADO with Personal Oracle

9. VB/Personal Oracle connection

10. Personal Oracle

11. Personal Oracle 7

12. VB3 with Oracle Personal Enterprise Edition 7

 

 
Powered by phpBB® Forum Software