Linux Tech Support: FEDORA

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: justify;">
<b><span style="font-size: large;"> How to connect mssql with php using FEDORA</span></b></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;">Connecting to MSSQL  datbase </span><span style="font-size: 85%;">with php </span><span style="font-size: 85%;">from Fedora or any other Linux  flovour is a pretty much easy.</span></span></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;">In Linux Freetds Package provide libraries to connect to the MSSQL database, which can be installed with a yum command:</span></span></div>
<div style="color: #3333ff; text-align: justify;">
<br /></div>
<div style="color: #3333ff; text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;"><code># yum install php-mssql</code></span></span></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;">the above command asks to install <b>MSSQL </b>extension for PHP, but yum will take care of all the dependencies including Freetds.</span></span></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;">Once installed you can use a low level tool like tsql which comes with Freetds to check you setup, but before that edit the Freetds config file (/etc/freetds.conf):</span></span></div>
<div style="color: #3333ff; text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;"><code>[root@amit]# vim /etc/freetds.conf</code></span></span></div>
<div style="color: #3333ff; text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;"><code>[MSSQL]<br />host = 192.168.1.1<br />port = 1433<br />tds version = 8.0</code></span></span></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;">above is a simple configuration that I use to connect to SQL2005/2000 databases. The braces contain a name (any name you like) to refer to the connection from Linux, and host is the IP of the MSSQL Server, port is the port MSSQL is listening on and the tds version is the TDS Protocol Version to use when connecting with database. Now regarding the port, MAKE SURE that you are connecting to the correct MSSQL port. OK, Lets check with tsql now:</span></span></div>
<div style="color: #000099; text-align: justify;">
<br /></div>
<div style="color: #000099; text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;"><code># tsql -S MSSQL -U user -P pass</code></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;">that should give u a prompt like “1>”</span></span></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;">Now check whether PHP can connect:</span></span></div>
<div style="color: #000099; text-align: justify;">
<br /></div>
<div style="color: #000099; text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;"><code># php -r 'echo mssql_connect("MSSQL","user","pass");'</code></span></span></div>
<div style="color: #000099; text-align: justify;">
<br /></div>
<div style="color: #000099; text-align: justify;">
<br /></div>
<div style="color: #000099; text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;">From the desk of <a href="http://www.amitmaheshwari.in/" target="_blank"><span style="color: #006600; font-style: italic;">Amit Maheshwari</span></a></span><br /><span style="font-size: 85%;"><code></code></span></span></div>
<div style="color: #000099; text-align: justify;">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: 85%;"><code><br /></code></span></span></div>
<div style="text-align: justify;">
<span style="font-size: 85%;"><br /></span></div>
</div>

How to connect mssql with php using FEDORA

How to connect mssql with php using FEDORA Connecting to MSSQL datbase with php from Fedora or any other Linux flovour is a pretty ...

<div dir="ltr" style="text-align: left;" trbidi="on">
<b><span style="font-size: large;">How to install Jre in Fedora Linux</span></b><br />
<br />
First check latest version of  JAVA RUN TIME ENVIRONMENT  at http://www.java.com/en/download/linux_manual.jsp<br />
<br />
<br />
Then download Linux  (Self-Extracting File) it looks like this<br />
jre-6u14-linux-i586.bin   (version may be change)<br />
<br />
<br />
now login as a root<br />
<br />
<span style="color: #3333ff;">[root@amit]#  mkdir /usr/java  </span>   ### Create java directory under /usr<br />
<br />
then mv jre-6u14-linux-i586.bin  file to /usr/java/ by following command<br />
<br />
<span style="color: #3333ff;">[root@amit]#  mv jre-6u14-linux-i586.bin  /usr/java</span><br />
<br />
<br />
Now make it executable by using following command<br />
<br />
<span style="color: #3333ff;">[root@amit /usr/java]# chmod u+x  jre-6u14-linux-i586.bin</span><br />
<br />
now simply execute it :<br />
<br />
<span style="color: #3333ff;">[root@amit /usr/java]#  ./jre-6u14-linux-i586.bin</span><br />
<br />
<br />
NOTE : it require some packages to be pre-installed like <span style="color: blue;"><br />compat-libstdc++</span> , <span style="color: #3333ff;">gcc, </span> <span style="color: blue;">compat-libstdc++</span><br />
<br />
<br />
After successfully installation make it compatible with FIREFOX by using :<br />
<br />
<br />
<span style="color: #3333ff;">[root@amit /usr/java]#  ln -s   /usr/java/jre1.6.0_14/plugin/i386/ns7/libjavaplugin_oji.so /root/.mozilla/plugins/ </span><br />
<br />
Now restart your Firefox web Browser and Enjoy.....<br />
<br />
By <a href="http://www.amitmaheshwari.in/" target="_blank"><span style="color: #006600; font-style: italic;">Amit Maheshwari</span></a></div>

How to install Jre in Fedora Linux

How to install Jre in Fedora Linux First check latest version of JAVA RUN TIME ENVIRONMENT at http://www.java.com/en/download/linux_man...