[Resolved] mssql_connect unknown

mflanagan

I'm trying to connect to MS SQL Server 2000 (developer edition) under Win 2k, using IIS 5. I get told "Fatal error: Call to undefined function: mssql_connect() in D:\Inetpub\wwwroot\QLinks\EARN\test.php on line 28."

I assumed (uh-oh!) that the names were resolved in the 'standard' Windows binaries for php 4.3.3, and the executable was resolved via the php_mssql.dll file. Is the error message telling me I have to recompile php in order to use the mssql_* functions?

Thanks.

Michael

stolzyboy

if you run a phpinfo(); page, is PHP configured to use MSSQL, if not, then you have to configure PHP with MSSQL

mflanagan

I don't see that the output from php_info() shows anything about mssql. I thought I configured it in php.ini. Of course, now that you ask, I see that I had commented it out for other reasons. Thanks!!

Now I'm to this point (or should I post this as a new thread?): I get the following:
Warning: mssql_connect(): message: Login failed for user 'T450\IUSR_T450'. (severity 14) in D:\Inetpub\wwwroot...\test.php on line 28

line 28 says:
$s = mssql_connect('EARN')

where EARN is an alias in the SQL Server client utility. I get the same thing if I try to connect to 'localhost' (which is where the SQL Server is).

Thanks.

Michael