Connecting to MS SQL 6.x+ via Openlink/PHP/ODBC mini-HOWTO: Introduction

1. Introduction

This document describes how to connect to MS SQL 6.x+ database server via ODBC functions of PHP3(3.0.1x or above) compiled with Openlink drivers under Linux.

In the Unix world, people may hate to be invoked with any M$ related software. However, in the real world, the boss may require you to store data in a MS SQL database on NT and run web application on Linux. What to do? Quit the job or sit down to read this document? If you choose latter, I will give you a detailed installation guide so that you can keep the job for a while. It is a How-to guide, not a Why-so guide. So don't ask me why abc instead of cba. I don't know either.

PHP is becoming more and more popular in web programmers, mainly because it can be configured to connect to various databases like Oracle, MySQL, Solid and so on. But for a MS SQL server, the problem is different. Though you can use PHP's Sybase-ct support features to directly connect to MSSQL, many people (at least me) prefer to connect via ODBC.

Utilizing Openlink ODBC middleware, you can use those ODBC_xxxx functions to connect to all the database Openlink has a driver for. You have to install Openlink Linux client and Server middleware and re-compile PHP to support ODBC functions. In the end, I made a script sample for reference.

1.1 Copyright

Please freely copy and distribute (sell or give away) this document in any format. It's requested that corrections and/or comments be forwarded to the document maintainer. You may create a derivative work and distribute it provided that you:

Send your derivative work (in the most suitable format such as sgml) to the LDP (Linux Documentation Project) or the like for posting on the Internet. If not the LDP, then let the LDP know where it is available.
License the derivative work with this same license or use GPL. Include a copyright notice and at least a pointer to the license used.
Give due credit to previous authors and major contributors.

If you're considering making a derived work other than a translation, it's requested that you discuss your plans with the current maintainer.

1.2 Disclaimer

The following document is offered in good faith as comprising only safe configuration and procedures. No responsibility is accepted by the author for any loss or damage caused in any way to any person or equipment, as a direct or indirect consequence of following these instructions.

This document was derived from the plain text entry found on http://www.silen.net/openlink-php-odbc.txt.

Next Previous Contents