PHP to SQL Server connection

Question

I want to connect to a SQL Server 2000 from PHP installed in a unix platform (CentOs) and to be able to run queries (SELECT and UPDATE). The solution must support UTF-8 data.

As search through the web, I find out that there exists many different approaches (freeTDS, unixODBC, ODBTP, Easysoft ODBC, Easysoft ODBC-ODBC Bridge, PDO).

Could someone point me to the best solution for the specific connection?

Wrikken · Accepted Answer · 2010-09-30 11:00:56Z

1

PDO is the preferred library a.t.m, with PDO_DBLIB (at least, for Linux), see here. if you need it portable between Linux & Windows, use PDO_ODBC.

answered Sep 30, 2010 at 11:00

Wrikken

70.8k8 gold badges99 silver badges136 bronze badges

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

2 Comments

Duniyadnd Over a year ago

Sorry for the downvote, but noticed your comment was from 2010 and with MSSQL - PDO is experimental for MSSQL at the moment in 2012.

Wrikken Over a year ago

@Duniyadnd: afaik, it is still the preferred method. If you know a better / more preferred one please post the details to that as an answer.

vagavan · Accepted Answer · 2012-11-15 18:13:12Z

0

The fact that PDO_DBLIB was (and still is) experimental discourage me from using it. I decided to start testing a solution using freeTDS, that seemed to be the simpliest method. It turned out to function excellent, for that specific connection's case and I implemented the final application using it.

answered Nov 15, 2012 at 18:13

vagavan

6255 silver badges8 bronze badges

Collectives™ on Stack Overflow

PHP to SQL Server connection

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related