I have read the other posts on this topic but they do not provide an answer. There were some threads but no resolution.
I am trying to connect to a MSSQL 2000 DB. I am using apache 3.12 (works fine), PHP4.1.1 on Windows NT. I have the PHP.ini set up with the mssql.dll and suspect I would get other errors if that were wrong. I currently am using Cold Fusion for my web pages and we are looking for alternatives to CF.
No matter what I try, I always get an error indicating either PHP can not connect to the DB or the user is not trusted.
The current error (after about 20 seconds), when trying a 'mssql_connect' to a DB in the ODBC list under the System DSN tab is:
Error 0x7f in GetProcAddress for FreeADsMem.
<b>Warning</b> MS SQL: Unable to connect to server: dbname in <b>C:\path to php\the file.php</b> on line 4
Error Connecting to SQL Server
When setting the mssql_connect servername parameter, I always immediately get:
<b>Warning</b>: MSSQL message: Login failed for user 'thisuser'. Reason: Not associated with a trusted SQL Server connection. (severity 14) in <b>C:\path to php\the file.php</b> on line 4
Error Connecting to SQL Server
Any help would be greatly appreciated.
Gary
