PHP Unable to connect to MS SQL server

Question

I have used default MS SQL driver to connect to a SQL server in a php application. I'm using XAMPP 1.6.8. my php version is 5.2.6.

Application was connected successfully to the SQL server and the application was running successfully for a long time. Now suddenly the application is showing an error on mssql_connect() function with same MS SQL access information. the error is "Unable to connect to server: xxx.xxx.xxx.xxx"

I also checked the SQL server access info with a SQL client. SQL client can connect successfully, therefore i think the access info is correct.

Can any one help me resolved this issue?

Thx

(1) Please proofread your post before clicking "submit". There are rules in English language about sentences. (2) Post your code. — Aleks G
– Aleks G, Commented Jul 8, 2013 at 11:17
@Jon error is "Unable to connect to server: xxx.xxx.xxx.xxx." — Arif Hossain
– Arif Hossain, Commented Jul 8, 2013 at 11:29
I just found my solution here. jimmyli.net/2009/03/php-unable-to-connect-to-mssql tha problem was that the file ntwdblib.dll packaged with PHP5 was an old version. then i just replace with updated one from here jimmyli.net/wp/wp-content/uploads/2009/03/ntwdblib.zip — Arif Hossain
– Arif Hossain, Commented Jul 8, 2013 at 11:56

Arif Hossain · Accepted Answer · 2013-07-09 05:27:32Z

1

I just found my solution here. http://jimmyli.net/2009/03/php-unable-to-connect-to-mssql/ .problem was that the file ntwdblib.dll packaged with PHP5 was an old version. then i just replace with updated one from here http://jimmyli.net/wp/wp-content/uploads/2009/03/ntwdblib.zip

Thx

answered Jul 9, 2013 at 5:27

Arif Hossain

3111 gold badge5 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP Unable to connect to MS SQL server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related