odbc_connect works with Nusphere PhpEd, but not without it.

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
deep3
Forum Newbie
Posts: 1
Joined: Wed Jun 25, 2008 8:26 am

odbc_connect works with Nusphere PhpEd, but not without it.

Post by deep3 »

I installed Apache webserver, php5 and created a system DSN on my local Windows XP machine to connect to a remote MSSQL database server. I successfully tested the system DSN connectivity from within ODBC Data source administrator. 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? I need to know this so that I can configure php or apache on the production server correctly to work with Remote database server.

Thanks,
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

Re: odbc_connect works with Nusphere PhpEd, but not without it.

Post by onion2k »

There's no need to post a topic in different forums. Once is enough. If I have to delete a duplicate of this thread again I'll be quite annoyed.
Post Reply