-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Daniel
Brown
Sent: Tuesday, December 09, 2008 3:49 PM
To: David Stoltz
Cc: Bastien Koert; Dan Shirah; php-general@lists.php.net
Subject: Re: [PHP] MSSQL_CONNECT problem
On Tue, Dec 9, 2008 at 3:41 PM, David
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
From: Dan Shirah [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 10, 2008 8:10 AM
To: David Stoltz
Cc: Daniel Brown; Bastien Koert; php-general@lists.php.net
Subject: Re: [PHP] MSSQL_CONNECT problem
Sorry for top posting, that's how my email client sets up the
reply
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');
-Original Message-
From: Dan Shirah [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 10, 2008 8:46 AM
To: David Stoltz
Cc: Daniel Brown; Bastien Koert; php-general@lists.php.net
Subject: Re: [PHP] MSSQL_CONNECT problem
Try something like this:
$dbhost=SERVER
Is INTRA_SQL your instance name or database name? If it is the instance
name, is that instance setup to use 1433 as the port? I know 1433 is
the
default port for MSSQL, but the majority of people change that.
Correct - intra_sql is the instance, yes, it's using default port 1433
(which
From: Dan Shirah [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 10, 2008 9:42 AM
To: David Stoltz
Cc: Daniel Brown; Bastien Koert; php-general@lists.php.net
Subject: Re: [PHP] MSSQL_CONNECT problem
Is INTRA_SQL your instance name or database name? If it is the
instance
It's fixed WOO HOO - I'm going to get teary-eyedDan - special
thanks to you for helping me so much...
What fixed this? I put the DLL for SQL 2005 PHP Driver in the PHP/EXT
directory, and added the extension to the php.ini.
Restarted IIS, and BAM! Everything works
The only thing I
any other thoughts?
Thanks!
From: Bastien Koert [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2008 10:02 AM
To: Dan Shirah
Cc: David Stoltz; php-general@lists.php.net
Subject: Re: [PHP] MSSQL_CONNECT problem
On Mon, Dec 8, 2008 at 9:45 AM, Dan Shirah [EMAIL PROTECTED] wrote:
Can't seem
On Tue, Dec 9, 2008 at 3:41 PM, David Stoltz [EMAIL PROTECTED] wrote:
Do you have any other thoughts?
When posting to the list, please don't top-post.
Dave, are you seeing that error from both the CLI and the web?
Have you properly configured your DSN? What's the output from the
On Tue, Dec 9, 2008 at 3:41 PM, David Stoltz [EMAIL PROTECTED] wrote:
Yes, I'm using a valid SQL account. I've tried putting both versions of
ntwdblib.dll in the php directory, and the system32 directory (not at once
of course), and I get the same error.
I've pretty much tried everything
Folks,
Can't seem to connect with MSSQL_CONNECT. The function IS available. I'm
in a Windows environment, connecting to a SQL 2000 instance. My code:
mssql_connect('INTRA_SQL,1433', 'uname', 'password');
mssql_select_db('database');
I've tried leaving the port out, tried using server IP
Can't seem to connect with MSSQL_CONNECT. The function IS available. I'm
in a Windows environment, connecting to a SQL 2000 instance. My code:
mssql_connect('INTRA_SQL,1433', 'uname', 'password');
mssql_select_db('database');
I've tried leaving the port out, tried using server IP address,
.
Still stuck..
From: Dan Shirah [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2008 9:46 AM
To: David Stoltz
Cc: php-general@lists.php.net
Subject: Re: [PHP] MSSQL_CONNECT problem
Can't seem to connect with MSSQL_CONNECT. The function IS available. I'm
in a Windows environment, connecting
On Mon, Dec 8, 2008 at 9:45 AM, Dan Shirah [EMAIL PROTECTED] wrote:
Can't seem to connect with MSSQL_CONNECT. The function IS available. I'm
in a Windows environment, connecting to a SQL 2000 instance. My code:
mssql_connect('INTRA_SQL,1433', 'uname', 'password');
Hello.
I have a sql server named CLUSTER01 (on win 2k servers, iis, etc), i try to
connect to it :
$db_conn = mssql_connect(CLUSTER01, $db_usuario, $db_password);
and it gives me this message:
Warning: 0 is not a MS SQL link index in x
The user name and password are correctly created in the
16 matches
Mail list logo
