Re: Personal Oracle and ODBC

jfruetel_at_ainet.com (John Fruetel) wrote:

>I've been trying to set up Personal Oracle on my WFW machine for a
>while and although I can get the database up and running just fine, I
>can't connect to it via ODBC.
 

>I'm not sure what to put in the Connect String portion of the ODBC
>setup for Oracle. For SQL*Net 1 connections, its something like
>t:host:sid and for SQL*Net V2 its something like tns:sid, but what's
>the connect string for a local database running on the same PC?
 

>Any help would be greatly appreciated.
 

>John Fruetel
>jfruetel_at_ainet.com

If you look under Aliases in the Database Manager, you will find something like:
oracle7=2:
(where oracle7 is the shipped database)

In the Data Source setup for the ODBC driver you are using, type in just 2: for the SQL Net connect string and you should be ok i.e
SQL*Net ConnectString = 2:

Hope this helps

//************************************************************************//
// Raghu Valluri                                                          //   
// Synon Inc.,                                                            //   
// 1100, Larkspur Landing Circle                                          //
// Larkspur, CA 94939                                                     //
// (415) 461-5000                                                         // 
// email: rnv_at_synon.com                                                   //
//************************************************************************//