I have installed Apache webserver, and php on my local machine. I was trying to connect to a remote MSSQL server using a system DSN in my php script on my local machine and getting this error:"odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'MSM\ADCC-LPTP$'., SQL state 28000 in SQLConnect in C:\Web\WebServer\htdocs\MSSqlConn.php on line 11"
But when I installed Nuspeher PHPed 5.2 and I run the same script from within Nusphere, it works without an error. It gets connected to the remote MSSQL server and shows the results of my query.
What is Nusphere doing different for the odbc_connect to go through?
Thanks,
Deep