Re: [PHP-DB] Mssql/Sybase errors
No thats not it. I connected above this line. All of my errors come as Sybase errors because of the install of freeteds used with the --with-sybase=/path/to/freetds flag when i configure. It actually ended up being a spacing problem where i had concatenated the query string. there were two words that got pushed together causing the query to die. Thanks for the info though. szii@sziisoft .comTo: [EMAIL PROTECTED] cc: 04/25/2002 Subject: Re: [PHP-DB] Mssql/Sybase errors 07:26 PM 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. bWarning/b: Sybase error: 'REQ' is not a recognized OPTIMIZER LOCK HINTS option. (severity 15) in myFile.php on line b29/bbr 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
[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. bWarning/b: Sybase error: 'REQ' is not a recognized OPTIMIZER LOCK HINTS option. (severity 15) in myFile.php on line b29/bbr 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
Re: [PHP-DB] Mssql/Sybase errors
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. bWarning/b: Sybase error: 'REQ' is not a recognized OPTIMIZER LOCK HINTS option. (severity 15) in myFile.php on line b29/bbr 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