RE: [PHP] MSSQL_CONNECT problem
- From: Dstoltz@xxxxxxx ("David Stoltz")
- Date: Wed, 10 Dec 2008 08:33:54 -0500
From: Dan Shirah [mailto:mrsquash2@xxxxxxxxx]
Sent: Wednesday, December 10, 2008 8:10 AM
To: David Stoltz
Cc: Daniel Brown; Bastien Koert; php-general@xxxxxxxxxxxxx
Subject: Re: [PHP] MSSQL_CONNECT problem
Sorry for "top posting", that's how my email client sets up the
reply...
Anyway, I don't know what CLI is....? I see the error on the
web. As for
a DSN, I didn't think I need one connecting this way. That is
why the
uname, password, database is supplied, no? This should be a
"dsn-less"
connection....
Either way - I tried adding a DNS on the web server, that points
to the
SQL database, and that connection works...but the code I'm using
from
the web page still does not....
If I use the code you gave me, this is what I get:
Warning: mssql_connect() [function.mssql-connect]: Unable to
connect to
server: INTRA_SQL,1433 in D:\Inetpub\wwwroot\cratos\test.php on
line 2
Fatal error: Call to undefined function mssql_error() in
D:\Inetpub\wwwroot\cratos\test.php on line 2
Please advise...
Try something like this:
$dbhost=\\\\SERVER\\INSTANCE_NAME,PORT;
$dbuser="USERNAME";
$dbpass="PASSWORD";
$db_connect=mssql_connect($dbhost,$dbuser,$dbpass) or die ('Server
connection failed');
$mssql_database = mssql_select_db("DATABASE", $db_connect) or die ('DB
selection failed');
Same thing:
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to
server: \\10.10.103.222\INTRA_SQL,1433 in
D:\Inetpub\wwwroot\cratos\test.php on line 5
Server connection failed
- Follow-Ups:
- Re: [PHP] MSSQL_CONNECT problem
- From: "Dan Shirah"
- Re: [PHP] MSSQL_CONNECT problem
- References:
- MSSQL_CONNECT problem
- From: "David Stoltz"
- Re: [PHP] MSSQL_CONNECT problem
- From: "Dan Shirah"
- Re: [PHP] MSSQL_CONNECT problem
- From: "Bastien Koert"
- RE: [PHP] MSSQL_CONNECT problem
- From: "David Stoltz"
- Re: [PHP] MSSQL_CONNECT problem
- From: "Daniel Brown"
- RE: [PHP] MSSQL_CONNECT problem
- From: "David Stoltz"
- Re: [PHP] MSSQL_CONNECT problem
- From: "Dan Shirah"
- MSSQL_CONNECT problem
- Prev by Date: Re: [PHP] MSSQL_CONNECT problem
- Next by Date: Re: [PHP] MSSQL_CONNECT problem
- Previous by thread: Re: [PHP] MSSQL_CONNECT problem
- Next by thread: Re: [PHP] MSSQL_CONNECT problem
- Index(es):
Relevant Pages
|
