PHP + MSSQL problems...
Moderator: General Moderators
PHP + MSSQL problems...
Okay.
Im using Windows2k3 Web Edition for hosting IIS6.0
Im using Windows2k3 Server for hosting a SQL2000 Database
Both work great except the fact that i can not get PHP to connect to the SQL Database.
I can get into the database using Access and a program called MSDE i think. It worked fine on the webserver.
PHP was working previously very well with SQL2000, but I restarted the servers, and it just stopped working.
Does anyone have any suggestions?
I have the dll's located properly, the extension is in the extensions directory. Im using SQL Authetication... Im really lost here..
Thanks!
Im using Windows2k3 Web Edition for hosting IIS6.0
Im using Windows2k3 Server for hosting a SQL2000 Database
Both work great except the fact that i can not get PHP to connect to the SQL Database.
I can get into the database using Access and a program called MSDE i think. It worked fine on the webserver.
PHP was working previously very well with SQL2000, but I restarted the servers, and it just stopped working.
Does anyone have any suggestions?
I have the dll's located properly, the extension is in the extensions directory. Im using SQL Authetication... Im really lost here..
Thanks!
-
magicrobotmonkey
- Forum Regular
- Posts: 888
- Joined: Sun Mar 21, 2004 1:09 pm
- Location: Cambridge, MA
Time to confuse things up a bit more....
Ok, to install MSSQL drivers for PHP you have to get the ntwdblib.dll from the PHP Install, and move it to the c:\windows\system32... Or atleast thats what i had read. I try that, and i get a cannot connect error. BUT if i use the ntwdblib.dll from the SQL install, i get:
Warning: mssql_connect(): message: Login failed for user 'su'. (severity 14) in E:\wwwroot\flmanage.com\db.php on line 5
Ok, to install MSSQL drivers for PHP you have to get the ntwdblib.dll from the PHP Install, and move it to the c:\windows\system32... Or atleast thats what i had read. I try that, and i get a cannot connect error. BUT if i use the ntwdblib.dll from the SQL install, i get:
Warning: mssql_connect(): message: Login failed for user 'su'. (severity 14) in E:\wwwroot\flmanage.com\db.php on line 5
-
magicrobotmonkey
- Forum Regular
- Posts: 888
- Joined: Sun Mar 21, 2004 1:09 pm
- Location: Cambridge, MA
Ok, i have figured out the problem
It was based on two different things.
A. Do not use the php ntwdblib.dll
B. Use the SQL version of ntwdblib.dll
C. Use the proper "sa" not "su"
I had done soo many variations of dll's and logins, i accidentally
typed su. easily overlooked after spending 6 hours doing this
Thanks alot
It was based on two different things.
A. Do not use the php ntwdblib.dll
B. Use the SQL version of ntwdblib.dll
C. Use the proper "sa" not "su"
I had done soo many variations of dll's and logins, i accidentally
typed su. easily overlooked after spending 6 hours doing this
Thanks alot