[Xitami] Fwd: Xitami, PHP and mySQL

[Gunnar Swan]

Solved my own problem.
mysql on NT defaults to named pipes .... <<--- el stupido !!!

( Todo: set mysql to use tcpip on NT)  

Went with new ODBC driver for MySQL, and avoided internal libraries.
Temporarily set ODBC to use named pipes.  (NT !!!!)

Installed adodb for PHP  at http://php.weblogs.com/ADOdb
Problem solved.

------- Start of forwarded message -------
From: Gunnar Swan <GunnarSwan@PracticeToPass.com>
To: Xitami List <xitami@lists.xitami.org>
Subject: Xitami, PHP and mySQL
Date: 2/20/02 11:46:27 AM


A bit off topic ...  I need to iron out connectivity and permissions.

PHP appear to work. I submit a form and I get a response back.
Until I try to connect to mySQL.  

<?
  mySQL_Connect("localhost","root","somePassword")
?>

produces the error ...

Warning: MySQL Connection Failed: Can't create TCP/IP socket (10106).
I've searched everywhere for an answer, but all docs blow past how to handle connection problems.
I'm using VB for CGI with success, but I really want to have PHP functionality too.

I've tried using "localhost:3306", my IP, my Domain.  I've tried all users.
I can open the database with MYSQL.EXE with all  User accounts.
Even Access - ODBC - MYSQL will see the data. 
Just not PHP.

Any help is appreciated. 

-------- End of forwarded message --------