faqts : Computers : Programming : Languages : PHP : Database Backed Sites : ODBC

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

43 of 56 people (77%) answered Yes
Recently 2 of 10 people (20%) answered Yes

Entry

How can I connect to MS-SQL from a Linux box?
How can I connect to ODBC datasources on a Win NT machine from a Linux box?

Jan 12th, 2000 17:50
Nathan Wallace, John Kos, John Kos


I'm currently connecting to an ms-sql7 machine from a linux box. I'm
using the openlink multitier odbc drivers, which work well. Their
webpage is @ http://www.openlinksw.com/. You can then compile php3 with
openlink support, and create an odbc.ini file in the openlink directory
which references your database server. Works well & seems to be solid
under load. There's a good howto on this exact topic at:

    http://www.silen.net/openlink-php-odbc.txt

Another alternative is an odbc-odbc bridge by easysoft:

    http://www.easysoft.com

It's pretty straightforward, and actually faster in my tests than the
openlink solution. It provides PHP access from Linux and unix servers to
any remote ODBC data source, including MS SQL and MS Access. The
complete product can be downloaded from http://www.easysoft.com, which
also includes PHP sample code, demonstrations and technical support
documentation for PHP developers.  Support and advice also available
from support@easysoft.com.