79 lines
3.3 KiB
HTML
79 lines
3.3 KiB
HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
|
|
<HTML>
|
|
<HEAD>
|
|
<META NAME="GENERATOR" CONTENT="SGML-Tools 1.0.9">
|
|
<TITLE>Connecting to MS SQL 6.x+ via Openlink/PHP/ODBC mini-HOWTO: Introduction</TITLE>
|
|
<LINK HREF="MSSQL6-Openlink-PHP-ODBC-2.html" REL=next>
|
|
|
|
<LINK HREF="MSSQL6-Openlink-PHP-ODBC.html#toc1" REL=contents>
|
|
</HEAD>
|
|
<BODY>
|
|
<A HREF="MSSQL6-Openlink-PHP-ODBC-2.html">Next</A>
|
|
Previous
|
|
<A HREF="MSSQL6-Openlink-PHP-ODBC.html#toc1">Contents</A>
|
|
<HR>
|
|
<H2><A NAME="s1">1. Introduction</A></H2>
|
|
|
|
<P>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.
|
|
<P>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.
|
|
<P>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.
|
|
<P>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.
|
|
<P>
|
|
<H2><A NAME="ss1.1">1.1 Copyright</A>
|
|
</H2>
|
|
|
|
<P>Copyright (c) 1999 by Zili Zhang
|
|
<P>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:
|
|
<P>
|
|
<UL>
|
|
<LI>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.</LI>
|
|
<LI>License the derivative work with this same license or use GPL.
|
|
Include a copyright notice and at least a pointer to the license used.</LI>
|
|
<LI>Give due credit to previous authors and major contributors.</LI>
|
|
</UL>
|
|
<P>
|
|
<P>If you're considering making a derived work other than a translation,
|
|
it's requested that you discuss your plans with the current maintainer.
|
|
<P>
|
|
<H2><A NAME="ss1.2">1.2 Disclaimer</A>
|
|
</H2>
|
|
|
|
<P>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.
|
|
<P>This document was derived from the plain text entry found on
|
|
<A HREF="http://www.silen.net/openlink-php-odbc.txt">http://www.silen.net/openlink-php-odbc.txt</A>.
|
|
<P>
|
|
<HR>
|
|
<A HREF="MSSQL6-Openlink-PHP-ODBC-2.html">Next</A>
|
|
Previous
|
|
<A HREF="MSSQL6-Openlink-PHP-ODBC.html#toc1">Contents</A>
|
|
</BODY>
|
|
</HTML>
|