FreeTDS Development Group

["wettengel, kay" <kay.wettengel AT stahl.de>]

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