Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
pdo connection string to sqlserver
hi all,
does pdo supports sqlserver to connect to if so please send me the pdo statement that support it on php 5.2
please reply as soon as possible
best regards
mohr4000
does pdo supports sqlserver to connect to if so please send me the pdo statement that support it on php 5.2
please reply as soon as possible
best regards
mohr4000
Asked:
2
2
4 Solutions
If you are running php on Windows, DO NOT use the PDO_DBLIB driver. From the web page:
"On Windows, you should use the PDO_ODBC driver to connect to Microsoft SQL Server and Sybase databases, as the native Windows DB-LIB is ancient, thread un-safe and no longer supported by Microsoft. "
So, if you *are* running PHP on Windows, set up an ODBC connection to your SQL Server, and use the PDO_ODBC driver to connect.
Let me know if you need more info.
"On Windows, you should use the PDO_ODBC driver to connect to Microsoft SQL Server and Sybase databases, as the native Windows DB-LIB is ancient, thread un-safe and no longer supported by Microsoft. "
So, if you *are* running PHP on Windows, set up an ODBC connection to your SQL Server, and use the PDO_ODBC driver to connect.
Let me know if you need more info.
hi rob263,
thanks for reply,
but I'm using linux fedora core does dblib works fine on it to connect to MSSQLSERVER
if not do you have another way
best regards
hatem
thanks for reply,
but I'm using linux fedora core does dblib works fine on it to connect to MSSQLSERVER
if not do you have another way
best regards
hatem
Well, in addition to the warning about not using it on Windows, the page does say (in a big red box) that the extension is Experimental. I would still try it though, since it uses FreeTDS, which has been around for a while.
If it doesn't work, you can always fall back on ODBC, but even that may have problems (see http://www.php.net/manual/en/ref.pdo-odbc.php#81488)
If it doesn't work, you can always fall back on ODBC, but even that may have problems (see http://www.php.net/manual/en/ref.pdo-odbc.php#81488)
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
http://www.php.net/manual/en/pdo.drivers.php
Connection info:
http://www.php.net/manual/en/ref.pdo-dblib.php