Forum Discussion

AngBet1's avatar
AngBet1
New Contributor
9 years ago

DDT.ADO Driver issue

Im trying to execute the below lines of code  and Im ending up with "Provider  cannot be found.It may not be properly installed" error. I've installed Microsoft DataBase Access Engine 2007. Not sure what the problem is.Can someone please help with this??

 

Constr=//Connection string is defined
var SQLStatement ="select * from tablename";
var res = DDT.ADODriver(Constr, SQLStatement);

 

 

1 Reply

  • TanyaYatskovska's avatar
    TanyaYatskovska
    SmartBear Alumni (Retired)

    Hi Angbet1,

     

     

    You need to use the Microsoft DataBase Access Engine 2007 provider to work with Excel files. As you are trying to get access to SQL, Microsoft OLE DB Provider should be installed.