I have IIS on windows xp pro with php installed. I also installed myodbc.
I have a linux server running a fresh install of mysql
How can I have my windows box connect to my linux box to use the mysql database?
This is for a intranet so security isnt that high.
useing this is a php script on the IIS server gives me an error:
$connect = mysql_connect('172.16.2.173', 'root', 'mypassword') or die ("Couldnt connect");
mysql_select_db('rcfc', $connect) or die ("Couldnt open Database");
$sql = "SELECT * FROM test";
$result = mysql_query($sql) or die ("Couldnt get results");
error:
Warning: Can't create TCP/IP socket (10106) in c:\inetpub\wwwroot\index.php on line 3
Warning: MySQL Connection Failed: Can't create TCP/IP socket (10106) in c:\inetpub\wwwroot\index.php on line 3
Couldnt connect
