Issue creating a pdo connection to iis server

Asked Jul 31 '17 at 19:22

Active Jul 31 '17 at 19:22

Viewed 193 times

I am working on a project using an iis server and database. I need to make a connection to the database using php and through my research so far I think that a non-thread safe PDO is the best driver to use.

I am able to get php working on the server, I can get the phpInfo() to print out on the server. Using PDO::getAvailableDriver() I can see that I have MySQL and odbc. So will I be using the MySQL PDO driver to make the connection? When I try to make the connection I get a 500 error. I'm not sure if I need different drivers, they aren't installed correctly, or I'm making the call incorrectly. Any help is appreciated.

Here is my connection statement that is in a try/catch block. $conn = new PDO("mysql:host=$servername;dbname=$dbName", $username, $password);

asked Jul 31 '17 at 19:22

php_help

Do you see a PDO block in the phpinfo ? – Eric Jul 31 '17 at 19:25
Check the server error logs for more information the 500 error. – aynber Jul 31 '17 at 19:33
@Eric I can see the PDO block. I have MySQL and odbc blocks in that. – php_help Aug 01 '17 at 19:48
@aynber I managed to find this error in the driver log now "could not find driverConnected successfully". Any thoughts to that? – php_help Aug 01 '17 at 19:49
https://stackoverflow.com/questions/2852748/pdoexception-could-not-find-driver – aynber Aug 01 '17 at 19:54

Issue creating a pdo connection to iis server

0 Answers0