RE: [PHP-DB] PHP -> MSSQL connects, but can't query
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 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 PROTECTED]
> Sent: Friday, March 12, 2004 8:36 AM
> To: [EMAIL PROTECTED]
> 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
>
>
>
>
> $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"] . "\n";
> #}
>
> if (! mssql_close($dbproc)) {
> print "Can't close server connection";
> return;
> }
> print "Connection closed.";
> ?>
>
>
>
>
>
> 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
--
Adam Voigt
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] PHP -> MSSQL connects, but can't query
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 PROTECTED]
Sent: Friday, March 12, 2004 8:36 AM
To: [EMAIL PROTECTED]
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
\n";
#}
if (! mssql_close($dbproc)) {
print "Can't close server connection";
return;
}
print "Connection closed.";
?>
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP -> MSSQL connects, but can't query
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
> 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
>
>
>
>
> $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"] . "\n";
> #}
>
> if (! mssql_close($dbproc)) {
> print "Can't close server connection";
> return;
> }
> print "Connection closed.";
> ?>
>
>
>
>
>
> 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
--
Adam Voigt
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[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
\n";
#}
if (! mssql_close($dbproc)) {
print "Can't close server connection";
return;
}
print "Connection closed.";
?>
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
