Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Developer 2000 & ODBC
Oliver Dungey (ODungey_at_axe.rcuk.cca.rockwell.com) wrote:
> Vijay Raghavacharian <vraghavach_at_worldnet.att.net> wrote in article
> <333A6C7C.7B15_at_worldnet.att.net>...
> > I have a copy of Developer 2000 running under WIndows 95. I want to use
> > ODBC to connect to the Persosal Oracle 7 database which resides on the
> > same PC. I have installed the ODBC adminsitrator for Oracle 7.1. I have
> > used the ODBC adminsitrator before to connect to Watcom and SYbase 10
> > running on my PC. But when I try to use the ODBC to create the data
> > source for Po7, how do I tell ODBC what the database is ? Neither do I
> > understand the SQL*Net Connect String value that needs to be entered.
> The 'Data Source Name' in ODBC administration refers to the DB alias that
> you have set up through the 'SQL Net Easy Configuration. The important bit
> is that you must use a connect string of '2:' to connect to personal Oracle
> 7 - a strange idea but it works, I've just done the same.
> Regards, Oly (Oliver Dungey)
> Telephone Home: (+44)(0)118-9320651 Office: (+44)(0)118-9359151
> MailTo:ODungey_at_axe.rcuk.cca.rockwell.com
> http://www.rockwell.com
As for the SQL*Net Connect string -- In order to connect to an ODBC
data source using Developer/2000 you need to install the Oracle Open
Client Adapter (It will be on your Dev2k CD). Once installed, just
give the following logon string:
<username>/<password>@odbc:<ODBC Data Source Name>
For example, where the username is "scott", the password is (you guessed it) "tiger) and your specified "po7" as the Data Source Name in the ODBC Administrator, just connect using:
scott/tiger_at_odbc:po7
The Oracle libraries assume a odbc:something connect string goes through the Open Client Adapter. If you get an error about "interface file missing" or something like that, make sure the file ub73w32.dll (or ub73win.dll under Windows 3.1) exists in your %ORACLE_HOME%\BIN directory.