PHP with MS SQL

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Yes We are using Windows based hosting. Actually we are using our own server.

Its Windows Server 2008
Installed IIS
using PHP on IIS
SQL Express 2008 available
We are using Moodle.

any specific to any of these?

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

We are using FreeTDS version 8.0 and added its extension.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

No, I am unable to connect with server. always connection failed message is appearing :(, something is missing.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

I created a small testing app. in vb.net,

when I use

Server=WEBSRV01\SQLEXPRESS;Database=Devdb;User ID=Test;Password=Hello123;Trusted_Connection=False;

connect worked fine with vb.net application.

and when I tried to use

Server=WEBSRV01\SQLEXPRESS,1433;Network Library=DBMSSOCN;Initial Catalog=devdb;User ID=Test;Password=Hello123;

get a error, Login failed for user "Test"

SOLUTION

p_nuts

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

p_nuts

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Thanks Ray_Paseur,

I was thinking about such error information. Let me try it today, will let you know if I need something else. :)

BTW I am using connection string as

mssql_connect('server','user',password') in Test.php

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

How can I know either I am using thread Safe or non-thread safe php version?

ASKER

I got false while connect, so its mean there is some error while connecting. but problem is I am not getting error information, like what type of error occurred :(

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

yes, password, username, servername everything has been checked several times..

failed code is similar to

mssql_connect('server','user',password')

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.