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 did
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
>
> 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
>
-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:
>
>
>
>
>
> 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
> s
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 se
>
> 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"
-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
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 every
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
fo
ql_bind" so I can do
parameterized queries
Do you have 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,
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');
> > mssql_s
on problem.
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
>
> 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 ad
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 address,
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 log
16 matches
Mail list logo
