php mysql connection "unidentified error"

[dizmarkie]

windows xp pro SP2, IIS 5, MySQL 4.1, PHP 5, DWMX 04, I am new to Mysql and
php, i've used asp in the past. I am trying to setup an application all
locally. I setup the server andhave it running. I am able to view php pages and
have the php running fine. I created a test DB using EMS MYSQL manager under
'localhost' plus there are 'test' and 'mysql' DB's that come with the install
of mysql under localhost aswell. I then defined a site in my inetpub called
'phpblog' just to test things out. I go to create the connection and I 1.name
the conncertion 'connPHPBlog 2.MySQL Server 'localhost' 3.Username 'root'
4.password 'root' < which i setup and confirmed works 5.I click 'select' button
and thats when i get the error 'an unidentified error has occured' What causes
this? I have the server running and see lots of confliting resolutions for this
out there and none seem to answer my problem. I went the route of the phakt
extension to make a connection via adob but it seems that only for remote
connections. I would like to develop everything locally then migrate DB and app
to a host at a later date. Any help would be appreciated

[genieyuan]

With PHP5.0 MySQL connection is not built in by default.

Suggestions:
go [url]www.php.net[/url] and follow the manual installaion to setup the MySQL connection.

[dizmarkie]

a little bit closer now.. i was using the 'installer' for php 5 which i found
out is missing some extensions required. I downloaded the distribution zip
folder, renamed the 'php -dist' file to php.ini like advised. i can see the
service running in my task manager for php, i also setup the extensions
properly in my virtual directory through my iis settings. i also added the
proper security settings unser 'IUSR' for that folder. Now when I click
'select' in the conneciton dialog it attempts to and doest that for a a while
then finally times out. I now have a message syaing 'A server timeout has
occured. Here are the possible reasons. 1.Please make sure the web server is up
and runnin <--which it is (IIS and the database server (mysql) ) 2.Please
verify that the odbc dsn exists on the testing server. <- It does cause i've
used many odbc connections before with asp and i downloaded odbc connector for
mysql. I know so many people that use mysql and php as their #1 choice.. does
everyone have to go through all this tie setup? or is it just me and my
noobism.? any suggestions are welcomed and thank you

[genieyuan]

[url]http://nz2.php.net/manual/en/faq.databases.php#faq.databases.access[/url] to see the
FAQ in PHP.net about your problem.

If you can have IIS, PHP, and MySQL running properly (Seperately), then i
guess it will be the problem about the PHP extension. I hope the link above can
help you.

I had the same problem with you when I first installed PHP5 by using
installer. But I get this fixed after i re-install PHP5 manually.

Good luck

[dizmarkie]

ok... thank you for the reply... i can almost say with certainty that my php is
causing the problem. I have tried my best to setup manually and follow the
instructions but to no avail. I setup enviornment variable. i setup a DSN and
connected properly through the ODBC under control panel. So IIS and MYSQL are
fine.. just cant get PHP and mysql to talk. Is there anyway I could just get a
copy of a working php.ini file and overwrite the one i have to work? or is
there anywhere with step by step instructions that work? The connection
builder in dreamweaver seems to work but just timesout when my sql connection
tried to connect. So i've just been searching for ways to configure and finding
conflicting ways all the time... i followed the php.net way but its brief at
best and still no success HELLLLP!

[genieyuan]

What will be the best way for you? I can send you a e-mail or place it online.

[dizmarkie]

an email would be much appreciated, thank you very much for your support and
patience. I wish more were like you out there,lol. [email]kevindoherty40@hotmail.com[/email]
<-email thanks again.. lets pray this works.. should i just overwrite the
ini. or uninstall the PHP altogether and re-install the distribution into the
C: ?

[David Powers]

dizmarkie wrote:

> should i just overwrite the
> ini. or uninstall the PHP altogether and re-install the distribution into the
> C: ?

I doubt very much if changing php.ini is going to solve your problems. I
have a set of very comprehensive instructions for installing PHP, Apache
and MySQL online at [url]http://computerbookshelf.com/phpdw/install1.php[/url].
They are revised instructions that I'm creating for readers of one of my
books. They don't yet contain the details of how to get PHP to work with
IIS, but that part will probably be up later today.

Your problems undoubtedly stem from using the PHP Windows installer, and
incorrect settings for IIS.

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]

[dizmarkie]

i would very much appreciate the detailed instructions for the IIS setup. I did
try and overwrite the php.ini from a fellow user with no success.I did not use
the installer. When I did i had no progress at all. so i know that much not to
use it. I will try and clean up and uninstall all the php cpmponeents and await
your posting and start from scratch and hopefully configure properly so
mysql,iis and php all play nace inside of dreamweaver. thanks for the
reply.... on to troublshooting... again