hehehe, you recoded PHP to reconnect to MSSQL, but you forgot to redo your connection stuff. "Sybase error:" means that you're connecting to Sybase and not MSSQL. *wink*
'Luck -Szii ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 25, 2002 10:18 AM Subject: [PHP-DB] Mssql/Sybase errors > Hello. > > I have recently installed the freetds package and reconfigured PHP to > connect to MSSQL. I am running a simple join query on two tables and I get > the following error. > <b>Warning</b>: Sybase error: 'REQ' is not a recognized OPTIMIZER LOCK > HINTS option. (severity 15) in myFile.php on line <b>29</b><br> > > REQ is one of the tables in the database. here is the query, which works > fine in MS Query Analyzer. Anyone run up against this problem? > > mssql_query("select REQ.DESCR, BUSINESS_AREA.DESCR, REQ_NUM from REQ INNER > JOIN BUSINESS_AREA". > "ON (REQ.BUSINESS_AREA = BUSINESS_AREA.BUSINESS_AREA) WHERE > REQ.BUSINESS_AREA = '$area'"); > > I can run basic select queries, but came into this when i started using > JOIN. > > Many thanks, > Jeff > > my set up is PHP4.1.2/Apache/Unix/Freetds 0.53 > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php