[phplib] ODBC connection parameters From: Nicolaus Meins (eigelb <email protected>)
Date: 11/04/00

Hi,

after successfully running phplib with MySQL I'm trying to set it up with
Oracle 8i under W2K. Because I have to port it to MS-SQL later I'm
using the Oracle ODBC driver, but I can't find the right connection
parameters for db_odbc.inc.
The following connect string works fine with PHP:
$connect =odbc_connect("dns", "user", "pass") and the queries are
running too.

I have tried any combination of parameters I can think of in db_odbc.inc,
but I always get the same error (some of it is in german)

Warning: SQL error: [Microsoft][ODBC Driver Manager] Der Datenquellenname
wurde nicht gefunden, und es wurde kein Standardtreiber angegeben., SQL
state IM002 in SQLConnect in db_odbc.inc on line 35
Database error: Link-ID == false, odbc_pconnect failed
ODBC Error: 0 ()
Session halted.

So my question is, how do I change db_odbc.inc to get a connection to the db
? The following doesn't work.

class DB_Sql {
  var $Host = "localhost";
  var $Database = "BREWER"; // (should be right, eq "Service Name" in the
ODBC setup)
  var $User = "user";
  var $Password = "pass";
  var $UseODBCCursor = 0;
...

any help appreciated

nicolaus

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>