<!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>