Skip to Content.
Sympa Menu

freetds - RE: [freetds] FreeTDS, PHP and multiple instances

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "wettengel, kay" <kay.wettengel AT stahl.de>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] FreeTDS, PHP and multiple instances
  • Date: Wed, 12 Mar 2003 16:29:53 +0100

OK, I'm done. I had to change table-name to database.tablename, that's it:

> $dbhost = "SERVER:PORT"; //where Port is the special
> port for that
> database-instance
> $dbuser = "USER";
> $dbpass = "PASSWORD";
> $dbbank = "DATABASE";
> $dbtable1 = "DATABASE.TABLE1";
> $dbtable2 = "DATABASE.REISEN"; //I have to leave this,
because of the
> error-message
> $dbms = mssql_connect($dbhost, $dbuser, $dbpass);
> mssql_select_db($dbbank);
> $sql = "select field1, field2, field3, field4, field5,
> field6, field7 from
> $dbtable2"; //this returns the next error
> $res = mssql_query($sql, $dbms)

Thankx
Kay




Archive powered by MHonArc 2.6.24.

Top of Page