hello,
getting an error "DB Error: not found" after simply trying to connect to a database. i've got PHP 4.3.4 installed on my PC running Windows 2000 Pro now w/ a MySQL database.
where i'm confused is how you use PEAR DB to create a datasource on Windows. when i was simply using MYSQL functions before deciding PEAR DB is a good idea, i had a MYSQL driver installed that allowed me to go into Control Panel/Administrative Tools/Data Sources and create a MySQL datasource the Windows way. that datasource still exists and connects with no problem.
Now that I have PEAR DB, I am trying to connect using the manual datasource code:
$datasource = $db_engine.'://'.$db_user.':'.$db_pass.'@'.$db_host.'/'.$db_name;
this doesn't seem to work. i get that error and i'm assuming it's because my datasource isn't set up right. the user is set up, the info is correct so it should be working fine.
is this how you're SUPPOSED to set up a datasource on Windows w/ PEAR DB? this manual string thing above doesn't seem to pull it off. maybe there is a DB driver for ODBC Windows land.
ok, i just read some more on the web and found this:
$datasource = $db_engine.'://'.$db_user.':'.$db_pass.'@'.$db_dsn;
this subs in the Windows datasource name that i have set up already. unfortunately, this didn't work either.
any help is super appreciated
