And now, in a break from the previous trend of fluffy posts, we have a tutorial on how to (deep breath): connect PHP to a MSSQL Server 2008 instance over ODBC from Ubuntu Linux using the FreeTDS driver and unixODBC. Theoretically it would also work for SQL Server 2005.<\/p>\n
I don’t know whether half of the settings flags are necessary or even correct, but what follows Worked for Me™, YMMV, etc, etc.<\/p>\n
In the commands below, I\u2019ll use 192.168.0.1 as the server housing the SQL Server instance, with a SQL Server user name of devuser<\/em>, password devpass<\/em>. I\u2019m assuming SQL Server is set up to listen on its default port, 1433. Keep an eye out, because you\u2019ll need to change these things to your own settings.<\/p>\n First, install unixODBC: Use the tsql tool to test out the connection: This should prompt you for the password, after which you can hope against hope<\/em> to see this beautiful sign: If that worked, I recommend throwing a (coding) party. Next up is some configging. Open the FreeTDS config file. Add the following entry to the bottom of the file. We’re setting up a datasource name (DSN) called ‘MSSQL’. Now open the ODBC configuration file: And add the following MSSQL driver entry (FreeTDS) at the end: Then, finally, set up the DSN within ODBC in the odbc.ini file here Test out the connection using the isql tool: Now restart Apache and test it from PHP using ‘MSSQL’ as the DSN. If something doesn’t work, you might try installing any or all of these packages: Here are some other resources that were helpful to me through this disastrous journey.<\/p>\n And now, in a break from the previous trend of fluffy posts, we have a tutorial on how to (deep breath): connect PHP to a MSSQL Server 2008 instance over ODBC from Ubuntu Linux using the FreeTDS driver and unixODBC. … Continue reading
\nsudo apt-get install unixodbc unixodbc-dev<\/code>
\nI also installed the following (perhaps necessary) packages:
\nsudo apt-get install tdsodbc php5-odbc<\/code>
\nThen download, untar, compile, and install FreeTDS (warning, the URL may change):
\ncd \/usr\/local
\nwget http:\/\/ibiblio.org\/pub\/Linux\/ALPHA\/freetds\/stable\/freetds-stable.tgz
\ntar xvfz freetds-stable.tgz
\ncd freetds-0.82
\n.\/configure --enable-msdblib --with-tdsver=8.0 --with-unixodbc=\/usr
\nmake
\nmake install
\nmake clean
\n<\/code>
\nAttempt a connection over Telnet to your SQL Server instance:
\ntelnet 192.168.0.1 1433<\/code><\/p>\n
\ntsql -S 192.168.0.1 -U devuser<\/code><\/p>\n
\n1><\/code><\/p>\n
\n \/usr\/local\/etc\/freetds.conf<\/code><\/p>\n
\n[MSSQL]
\nhost = 192.168.0.1
\nport = 1433
\ntds version = 8.0<\/code><\/p>\n
\n \/usr\/local\/etc\/odbcinst.ini<\/code><\/p>\n
\n[FreeTDS]
\nDescription = FreeTDS driver
\nDriver = \/usr\/local\/lib\/libtdsodbc.so
\nSetup=\/usr\/lib\/odbc\/libtdsS.so
\nFileUsage = 1
\nUsageCount = 1 <\/code><\/p>\n
\n\/usr\/local\/etc\/odbc.ini<\/code>
\nBy adding this bit to the file:
\n[MSSQL]
\nDescription = MS SQL Server
\nDriver = \/usr\/local\/lib\/libtdsodbc.so
\nServer = 192.168.2.3
\nUID = devuser
\nPWD = devpass
\nReadOnly = No
\nPort = 1433<\/code><\/p>\n
\nisql -v MSSQL devuser 'devpass'<\/code>
\nIf you see “Connected!” you’re golden, congratulations! If not, I’m truly sorry; see below where there are some resources that might help.<\/p>\n
\nmdbtools libmdbodbc libmdbtools mdbtools-gmdb<\/code><\/p>\n\n