problem-in-connecting-to-sql-server-2008-by-php

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
ahad_yekta2004
Forum Newbie
Posts: 6
Joined: Fri Jul 23, 2010 2:00 am

problem-in-connecting-to-sql-server-2008-by-php

Post by ahad_yekta2004 »

I have a problem in connecting the wampp localhost to sql server , There is a lan network that it`s server is windows server 2008 with sql server 2008 , I want to connect to this sql by php in a client with windows 7 , but when I run mssql_connect function It shows that coudlent connect to this IP , It shows Reply when I ping server IP .
Do I have to change anything in wampp or php application in localhost ?
It is php 5.3 the latestversion of wampp .
Other programmers can connect to this sql by C sharp and Delphi , Only me cant access that by php
I use VmWare also , and install windows server 2008 and sql server 2008 , and create network between win7 and windows server by NAT , even in this way I cant access to sql by php , but there is reply in pinging servers IP .
,
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: problem-in-connecting-to-sql-server-2008-by-php

Post by requinix »

Use the sqlsrv extension, not the old and deprecated mssql extension.
ahad_yekta2004
Forum Newbie
Posts: 6
Joined: Fri Jul 23, 2010 2:00 am

Re: problem-in-connecting-to-sql-server-2008-by-php

Post by ahad_yekta2004 »

requinix wrote:Use the sqlsrv extension, not the old and deprecated mssql extension.
Doyou mean that?
http://www.microsoft.com/en-us/download ... x?id=20098

or somthing else?
if not could you please show me a link of that?
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: problem-in-connecting-to-sql-server-2008-by-php

Post by requinix »

Yes, that's it.
ahad_yekta2004
Forum Newbie
Posts: 6
Joined: Fri Jul 23, 2010 2:00 am

Re: problem-in-connecting-to-sql-server-2008-by-php

Post by ahad_yekta2004 »

requinix wrote:Yes, that's it.
I copy that files in php extension folder and add these lines in php.ini and restart services :

but it shows these errors :

Code: Select all

Warning: mssql_connect() [<a href='function.mssql-connect'>function.mssql-connect</a>]: message: The USE database statement failed because the database collation Persian_100_CI_AI is not recognized by older client drivers. Try upgrading the client operating system or applying a service update to the database client software, or use a different collation. See SQL Server Books Online for more information on changing collations. (severity 16) in C:\wamp\www\sql\index.php on line 4
Call Stack
#	Time	Memory	Function	Location
1	0.0002	671808	{main}( )	..\index.php:0
2	0.0003	672096	mssql_connect ( )	..\index.php:4

( ! ) Warning: mssql_connect() [<a href='function.mssql-connect'>function.mssql-connect</a>]: General SQL Server error: Check messages from the SQL Server (severity 16) in C:\wamp\www\sql\index.php on line 4
Call Stack
#	Time	Memory	Function	Location
1	0.0002	671808	{main}( )	..\index.php:0
2	0.0003	672096	mssql_connect ( )	..\index.php:4

( ! ) Warning: mssql_connect() [<a href='function.mssql-connect'>function.mssql-connect</a>]: message: Login failed for user 'sisi'. (severity 14) in C:\wamp\www\sql\index.php on line 4
Call Stack
#	Time	Memory	Function	Location
1	0.0002	671808	{main}( )	..\index.php:0
2	0.0003	672096	mssql_connect ( )	..\index.php:4

( ! ) Warning: mssql_connect() [<a href='function.mssql-connect'>function.mssql-connect</a>]: General SQL Server error: Check messages from the SQL Server (severity 14) in C:\wamp\www\sql\index.php on line 4
Call Stack
#	Time	Memory	Function	Location
1	0.0002	671808	{main}( )	..\index.php:0
2	0.0003	672096	mssql_connect ( )	..\index.php:4

( ! ) Warning: mssql_connect() [<a href='function.mssql-connect'>function.mssql-connect</a>]: Unable to connect to server: 192.168.170.139 in C:\wamp\www\sql\index.php on line 4
Call Stack
#	Time	Memory	Function	Location
1	0.0002	671808	{main}( )	..\index.php:0
2	0.0003	672096	mssql_connect ( )	..\index.php:4
Could not connect
( ! ) Fatal error: Call to undefined function mssql_error() in C:\wamp\www\sql\index.php on line 7
Call Stack
#	Time	Memory	Function	Location
1	0.0002	671808	{main}( )	..\index.php:0

What should I do . I`m not expert in sql server
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: problem-in-connecting-to-sql-server-2008-by-php

Post by requinix »

You're still using the mssql extension. I can tell because all the functions are called mssql_*. If you were using the sqlsrv extension then you would be using functions called sqlsrv_*. See the pattern?

Read the documentation: it's not like the extension is very different from mssql or even mysql(i).
ahad_yekta2004
Forum Newbie
Posts: 6
Joined: Fri Jul 23, 2010 2:00 am

Re: problem-in-connecting-to-sql-server-2008-by-php

Post by ahad_yekta2004 »

I use sqlsrv_connect but shows me an error that :
Fatal error: Call to undefined function sqlsrv_connect() in C:\wamp\www\sql\index.php on line 27

in php.ini I added thease lines:

extension=php_sqlsrv_53_ts.dll
extension=php_pdo_sqlsrv_53_ts.dll
extension=php_pdo.dll


I dont know wamp is threaded php or not threaded , It said that for not threaded use these lines .

When I was searching for sqlsrv I found out that it doesnt work for windows 7 64 bit , Do you test it in windows 64bit ?
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: problem-in-connecting-to-sql-server-2008-by-php

Post by requinix »

If the function is undefined then the extension isn't installed. Did you restart WAMP?

Regarding thread-safe versus non-thread-safe it actually depends on your Apache installation. IIRC on Windows you should probably use the thread-safe versions, but if that doesn't work then use the other.

I don't see anything that says you can't use it on Win7 x64 - only something which tells you which drivers will be installed (you get an x86 and an x64 rather than two x64s).
perhanna
Forum Newbie
Posts: 1
Joined: Sat Jan 26, 2013 1:40 am

Re: problem-in-connecting-to-sql-server-2008-by-php

Post by perhanna »

Just what i have been looking for! Thank you very much vistad.
Post Reply