RE: [PHP-DB] RE: ODBC Connection To ORACLE

Actually, ODBC does not need SQL*Net. This is one of those myths I keep my eyes open for :) True, there are some ODBC drivers that piggyback on SQL*Net or other native layers, but by design that is not how ODBC functions. ODBC should speak directly to the CLI of the database, bypassing SQL*Net, and avoiding both the performance hit of an additional layer and the need to configure a client connectivity layer specific to database. Hope this helps. Best regards, Andrew ---------------------------------------------------- Andrew Hill Professional Services Consultant OpenLink Software http://www.openlinksw.com XML & E-Business Infrastructure Technology Provider > -----Original Message----- > From: Nold, Mark [mailto:Mark.Nold@normandy.com.au] > Sent: Tuesday, September 12, 2000 8:58 PM > To: 'Ron Woods'; php-db@lists.php.net > Subject: [PHP-DB] RE: ODBC Connection To ORACLE > > > ------------------------------------------------------------------ > ---------- > ----------------- > Disclaimer: The information contained in this email is intended > only for the > use of the person(s) to whom it is addressed and may be confidential or > contain legally privileged information. If you are not the intended > recipient you are hereby notified that any perusal, use, distribution, > copying or disclosure is strictly prohibited. If you have received this > email in error please immediately advise us by return email at > postmaster@normandy.com.au and delete the email document without making a > copy. > ------------------------------------------------------------------ > ---------- > ----------------- > Ron, > > There's no point using ODBC connections on Windows because you > have to have > Oracle configured just as you would for a straigt SQL*net / OCI connection > (because ODBC uses SQL*Net). > > Can you access the Oracle DB from outside of PHP, say from MS Query? Or > SQL*Plus? > > If not you havent set up your tnsnames.ora file. > > If you can then try using the PHP binaries at www.php4win.de > > I have with previous versions (i havent verified this with their latest > release) you need to use a Oracle 8.1.* client. I assume because they > compiled against a 8.1 version. This may have changed. You can get it all > working (yes connection to a remote 7.3.x) with OCI if you download the > php4win distro and a 8.1.6 server package from technet.oracle.com You cant > download the Oracle 8.1.6 client individually unless you have the Oracle > Installer... you dont get the Oracle Installer unless you have a existing > version of 8.1.x > > But you never know php4win may now work with older versions of SQL*Net and > OCI. > > Good luck > > mn > > -----Original Message----- > From: Ron Woods [mailto:ron.woods@gai-inc.com] > Sent: Tuesday, September 12, 2000 4:24 AM > To: php-db@lists.php.net > Subject: ODBC Connection To ORACLE > > > I'm running PHP on a WinNT and Netscape Server using the CGI > version of php. > So far I'm unable to make an ODBC connection to our Oracle DB using the > Oracle ODBC 73 or 73.2.5 drivers or the MS Oracle driver. > > Using the MS driver I receive the error "Warning: SQL error: > [Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could > not resolve > service name, SQL state 08001 in SQLConnect" > > Using the Oracle 73.2.5 driver I receive the error "Warning: SQL error: > [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-12154: TNS:could not resolve > service name., SQL state S1000 in SQLConnect". > > Using the Oracle 73 driver I receive the error "Warning: SQL error: > [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-12154: TNS:could not resolve > service name., SQL state S1000 in SQLConnect". > > I am setting (putenv()) the ORACLE_HOME, ORACLE_SID, and > TNS_ADMIN variables > before issuing the connection. Can anyone point me in the right direction? > > Thanks, > > Ron Woods > rwoodsathome@yahoo.com > > >