103 lines
3.4 KiB
HTML
103 lines
3.4 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: Openlink</TITLE>
|
|
<LINK HREF="MSSQL6-Openlink-PHP-ODBC-3.html" REL=next>
|
|
<LINK HREF="MSSQL6-Openlink-PHP-ODBC-1.html" REL=previous>
|
|
<LINK HREF="MSSQL6-Openlink-PHP-ODBC.html#toc2" REL=contents>
|
|
</HEAD>
|
|
<BODY>
|
|
<A HREF="MSSQL6-Openlink-PHP-ODBC-3.html">Next</A>
|
|
<A HREF="MSSQL6-Openlink-PHP-ODBC-1.html">Previous</A>
|
|
<A HREF="MSSQL6-Openlink-PHP-ODBC.html#toc2">Contents</A>
|
|
<HR>
|
|
<H2><A NAME="s2">2. Openlink</A></H2>
|
|
|
|
<P>This step is a little bit complicated. You have to done works on both
|
|
sides of your Linux client machine and NT server.
|
|
<P>
|
|
<H2><A NAME="ss2.1">2.1 On the Client</A>
|
|
</H2>
|
|
|
|
<P>
|
|
<UL>
|
|
<LI>From
|
|
<A HREF="ftp://www.openlinksw.com/">ftp://www.openlinksw.com/</A>,
|
|
download <CODE>install.sh</CODE> and <CODE>likoxglc.taz</CODE>
|
|
(for a libc6 system) or <CODE>likoxxxx.taz</CODE> (for a libc5 system).</LI>
|
|
<LI><CODE>mkdir /usr/local/openlink</CODE></LI>
|
|
<LI>copy <CODE>install.sh</CODE> and <CODE>likoxglc.taz</CODE>
|
|
into <CODE>/usr/local/openlink</CODE></LI>
|
|
<LI><CODE>cd /usr/local/openlink</CODE></LI>
|
|
<LI><CODE>sh install.sh</CODE>, the install script will ask you the owner and group of
|
|
the program. It will extract things to
|
|
<CODE>odbcsdk</CODE> directory under <CODE>/usr/local/openlink</CODE>
|
|
and copy a <CODE>.odbc.ini</CODE> into the owner's home directory.</LI>
|
|
</UL>
|
|
<P>
|
|
<H2><A NAME="ss2.2">2.2 On the Server</A>
|
|
</H2>
|
|
|
|
<P>
|
|
<UL>
|
|
<LI>From
|
|
<A HREF="ftp://www.openlinksw.com/">ftp://www.openlinksw.com/</A>,
|
|
download <CODE>ntadm65x.zip</CODE> onto your NT server.</LI>
|
|
<LI><CODE>unzip ntadm65x.zip</CODE></LI>
|
|
<LI><CODE>cd disk1</CODE> - directory of where you unzip the package.</LI>
|
|
<LI>execute <CODE>setup</CODE> and follow the instructions to install the Openlink
|
|
middleware.</LI>
|
|
<LI>remember to start Openlink request broker from start menu or service
|
|
control panel.</LI>
|
|
</UL>
|
|
<P>
|
|
<H2><A NAME="ss2.3">2.3 Configuration Before Test</A>
|
|
</H2>
|
|
|
|
<P>
|
|
<UL>
|
|
<LI>keep the <CODE>.odbc.ini</CODE> file in your home directory.</LI>
|
|
<LI>copy the <CODE>udbc.ini</CODE> from the bin directory of Openlink middleware
|
|
install directory to the <CODE>/etc</CODE> directory of client.</LI>
|
|
<LI>customize <CODE>/etc/udbc.ini</CODE>. In [dsn_sql6] section, change the
|
|
host, database, username and password entries to fit your server settings.
|
|
Here is part of my <CODE>/etc/udbc.ini</CODE>:
|
|
<BLOCKQUOTE><CODE>
|
|
<PRE>
|
|
[dsn_sql6]
|
|
Host = 10.0.0.1
|
|
ServerType = sql6
|
|
;ServerOptions =
|
|
Database = pubs
|
|
;FetchBufferSize = 30
|
|
UserName = sa
|
|
Password = xxxxxxx
|
|
</PRE>
|
|
</CODE></BLOCKQUOTE>
|
|
</LI>
|
|
<LI>add to your environment <CODE>LD_LIBRARY_PATH='/usr/local/openlink/odbcsdk/lib'</CODE>
|
|
and export it. In csh shell, type:
|
|
<CODE>setenv LD_LIBRARY_PATH /usr/local/openlink/odbcsdk/lib</CODE></LI>
|
|
</UL>
|
|
<P>
|
|
<H2><A NAME="ss2.4">2.4 Text with <CODE>odbctest</CODE></A>
|
|
</H2>
|
|
|
|
<P>
|
|
<UL>
|
|
<LI><CODE>cd /usr/local/openlink/odbcsdk/examples</CODE></LI>
|
|
<LI><CODE>./odbctest</CODE></LI>
|
|
<LI>type: <CODE>dsn=dsn_sql6</CODE></LI>
|
|
<LI>when 'sql>' appears, you can execute your sql clauses to test the
|
|
connection.</LI>
|
|
</UL>
|
|
<P>
|
|
<P>
|
|
<HR>
|
|
<A HREF="MSSQL6-Openlink-PHP-ODBC-3.html">Next</A>
|
|
<A HREF="MSSQL6-Openlink-PHP-ODBC-1.html">Previous</A>
|
|
<A HREF="MSSQL6-Openlink-PHP-ODBC.html#toc2">Contents</A>
|
|
</BODY>
|
|
</HTML>
|