error connecting to excel

This topic is locked

error connecting to excel	11/18/2019 6:43:07 AM
PHPRunner General questions
G Grdimitris author When i connect to excel file i can see the content in query but after build i have the above error \ "Fatal error: Source: ADODB.Connection Description: Provider cannot be found. It may not be properly installed. in E:\PHPRUNNER\Project1\output\connections\Connection.php on line 611" Any idea how to solve it? I use office 2016 and the 64 bit odcb driver downloaded from microsoft In Phprunner i choose in Database type page from other the excel icon


	Sergey Kornilov admin 11/18/2019
	I would highly recommend switching to another database type. Using Excel as a datasource will bring you nothing but pain. The error message itself means that connection string references a database driver or provider that doesn't exist on your machine. To see the connection string proceed to the "Output directory" screen and click New under "Server Database Connections". It will show you the current connection string.