Hi thanks am using windows xp for the application and windows server 2003 for the database but I can still use the database in my locval xp machine<br><br>this is the code am using and I am getting the following error<br><br>
<span style="color: rgb(51, 51, 153);">&lt;?php</span><br style="color: rgb(51, 51, 153);"><span style="color: rgb(51, 51, 153);">///////////////////////////////////////////////////</span><br style="color: rgb(51, 51, 153);">
<span style="color: rgb(51, 51, 153);">//</span><br style="color: rgb(51, 51, 153);"><span style="color: rgb(51, 51, 153);">// Connection test to external MSSQL Database</span><br style="color: rgb(51, 51, 153);"><span style="color: rgb(51, 51, 153);">//</span><br style="color: rgb(51, 51, 153);">
<span style="color: rgb(51, 51, 153);">///////////// Configure this /////////////////////</span><br style="color: rgb(51, 51, 153);"><br style="color: rgb(51, 51, 153);"><span style="color: rgb(51, 51, 153);">// Host\Instance Name</span><br style="color: rgb(51, 51, 153);">
<span style="color: rgb(51, 51, 153);">$host_inst     = &#39;ICT-COMARI\SQLEXPRESS&#39;;</span><br style="color: rgb(51, 51, 153);"><span style="color: rgb(51, 51, 153);">$username     = &#39;sa&#39;;</span><br style="color: rgb(51, 51, 153);">
<span style="color: rgb(51, 51, 153);">$password     = &#39;kemmie1*&#39;;</span><br style="color: rgb(51, 51, 153);"><br style="color: rgb(51, 51, 153);"><br style="color: rgb(51, 51, 153);"><span style="color: rgb(51, 51, 153);">///////////// End Configure /////////////////////</span><br style="color: rgb(51, 51, 153);">
<br style="color: rgb(51, 51, 153);"><br style="color: rgb(51, 51, 153);"><span style="color: rgb(51, 51, 153);">// Try connecting to the database</span><br style="color: rgb(51, 51, 153);"><br style="color: rgb(51, 51, 153);">
<span style="color: rgb(51, 51, 153);">$dbconnect = mssql_connect($host_inst, $username, $password); </span><br style="color: rgb(51, 51, 153);"><span style="color: rgb(51, 51, 153);">        </span><br style="color: rgb(51, 51, 153);">
<span style="color: rgb(51, 51, 153);">if ( $dbconnect ) {</span><br style="color: rgb(51, 51, 153);"><span style="color: rgb(51, 51, 153);">    echo &#39;&lt;b&gt;&lt;font color=&quot;green&quot;&gt;OK!&lt;/font&gt;&lt;/b&gt;&#39;;</span><br style="color: rgb(51, 51, 153);">
<span style="color: rgb(51, 51, 153);">} else {</span><br style="color: rgb(51, 51, 153);"><span style="color: rgb(51, 51, 153);">    echo &#39;&lt;b&gt;&lt;font color=&quot;red&quot;&gt;FAILED&lt;/font&gt;&lt;/b&gt;&#39;;</span><br style="color: rgb(51, 51, 153);">
<span style="color: rgb(51, 51, 153);">}</span><br style="color: rgb(51, 51, 153);"><br style="color: rgb(51, 51, 153);"><span style="color: rgb(51, 51, 153);">?&gt; </span><br><br>Error that I am getting is as follows<br>
<b>Fatal error</b>:  Call to undefined function mssql_connect() in <b>C:\wamp\www\iBusiness\dbcon.php</b>
 on line <b>19<br><br>I am using wamp server<br><br>Regards<br></b><div class="gmail_quote">On Tue, Jun 8, 2010 at 1:08 PM, Dan Muiru <span dir="ltr">&lt;<a href="mailto:danmuiru@gmail.com">danmuiru@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div link="blue" vlink="purple" lang="EN-US"><div><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Calvine,</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Which webserver platform are you workin on? IIS, Xampp, Wampp…….? Also the operating system of where PHP is?</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Dan</span></p><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;"> <a href="mailto:skunkworks-bounces@lists.my.co.ke" target="_blank">skunkworks-bounces@lists.my.co.ke</a> [mailto:<a href="mailto:skunkworks-bounces@lists.my.co.ke" target="_blank">skunkworks-bounces@lists.my.co.ke</a>] <b>On Behalf Of </b>Calvin Omari<br>
<b>Sent:</b> Tuesday, June 08, 2010 12:18 PM<br><b>To:</b> Skunkworks Forum<br><b>Subject:</b> [Skunkworks] Php mssql2005 remote sever connection</span></p><div><div></div><div class="h5"><p class="MsoNormal"> </p><p class="MsoNormal">
Hi,<br>I am building an application from my machine machine name (ICT-COMARI) and I want to connect to a database in another network computer called APPSERVER01, any idea how I can do that <br><br>Regards<br clear="all"><br>
-- <br>Our greatest fear is not that we are inadequate,<br>but that we are powerful beyond measure.<br>It is our light, not our darkness, that frightens us.<br><br>Calvin Omari Systems Developer/Designer<br><a href="http://www.facebook.com/barongo" target="_blank">http://www.facebook.com/barongo</a> </p>
</div></div></div></div><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Server donations spreadsheet<br>
<a href="http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en" target="_blank">http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en</a><br>

------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br><br clear="all"><br>-- <br>Our greatest fear is not that we are inadequate,<br>but that we are powerful beyond measure.<br>
It is our light, not our darkness, that frightens us.<br><br>Calvin Omari Systems Developer/Designer<br><a href="http://www.facebook.com/barongo">http://www.facebook.com/barongo</a> <br>