RE: [PHP-DB] PHP - MSSQL connects, but can't query

2004-03-15 Thread Jason Morrill
I changed the mssql_select_db line as suggested by another person here but it didn't change a thing. I still get the exact same error message. Is there anyone else here connecting to a MS SQL server using TDS v8.0 ?? Thanks! Jason -Original Message- From: Jason Morrill [mailto:[EMAIL

RE: [PHP-DB] PHP - MSSQL connects, but can't query

2004-03-15 Thread Adam Voigt
Yes, I'm connecting to a MSSQL server from FreeTDS, and it works fine. Try using the IP of the MSSQL server instead of the name, and see if that makes any difference. On Mon, 2004-03-15 at 09:23, Jason Morrill wrote: I changed the mssql_select_db line as suggested by another person here but it

Re: [PHP-DB] PHP - MSSQL connects, but can't query

2004-03-12 Thread Adam Voigt
Hmm, replace the line where you select the DB with: $dbconnect = mssql_select_db(Northwind) or die(mssql_get_last_message()); (All on one line incase the email wraps it.) On Fri, 2004-03-12 at 08:35, Jason Morrill wrote: I've got a very simple PHP script for testing my MS SQL Server