RE: [PHP-DB] PHP -> MSSQL connects, but can't query
| From: | Jason Morrill | Date: | Mon, 15 Mar 2004 14:23:42 +0000 |
| Subject: | RE: [PHP-DB] PHP -> MSSQL connects, but can't query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-33453@lists.php.net to get a copy of this message | ||
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:morrilljr@cfapress.org]
Sent: Friday, March 12, 2004 8:36 AM
To: php-db@lists.php.net
Subject: [PHP-DB] PHP -> MSSQL connects, but can't query
I've got a very simple PHP script for testing my MS SQL Server
connection. I've installed FreeTDS and I can connect and query the
database with TSQL.
With PHP I can connect and disconnect properly but I can't query or
attach to different databases. Here is my sample PHP followed by what
the web server throws back at me:
sql-test.php
------------
<html>
<body bgcolor=white>
<?php
$dbproc = mssql_connect("roger","sa","admin");
#$dbproc = sybase_connect("roger","sa","admin");
if (! $dbproc) {
print "Can't connect to server";
return;
}
print "Connected to server.";
$dbconnect = mssql_select_db("Northwind");
if (! $dbconnect) {
print "Can't connect to Northwind";
return;
}
print "Connected to database";
#$res = sybase_query("select * from test",$dbproc);
#if (! $res) {
# return;
#}
#while ($arr = sybase_fetch_array($res)) {
# print $arr["i"] . " " . $arr["v"] . "<br>\n";
#}
if (! mssql_close($dbproc)) {
print "Can't close server connection";
return;
}
print "Connection closed.";
?>
</body>
</html>
================================================
Output in browser when referencing the sql-test.php file:
---------------------------------------------------------
Connected to server.
Warning: Sybase: Server message: Line 1: Incorrect syntax near 'e'.
(severity 15, procedure N/A) in /home/www/sql-test.php on line 12 Can't
connect to Northwind
================================================
Can anyone help me figure this one out?!
Thanks!
Jason Morrill
IT Manager
Child & Family Agency SE Connecticut
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php