Forum Discussion

Kostja's avatar
Kostja
Contributor
10 years ago
Solved

Sql query results in Errcode: 22

Hey Everybody,

 

i got a new problem and the search in support/board and google didn't help that much.

 

I got following code snippet based on this example --> http://support.smartbear.com/viewarticle/58247/

 

var Qry = ADO.CreateADOQuery();

    Qry.ConnectionString = "Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=test;Uid=uid;Pwd=pwd;";

    Qry.SQL = "LOAD DATA LOCAL INFILE '" 
    
    + ExportFileName + "' INTO TABLE `testlogs` FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\r\n'";

    Qry.Open();

    Qry.Close();

But when the code is executed an error occurs:

 

[MySQL][ODBC 5.1 Driver][mysqld-5.1.41]File 'C:Users egtestDocumentsTest for Logs' not found (Errcode: 22)

 
Otherwise if i type the same sql query in phpmyadmin everything works fine. So, my questions are? What's wrong? Does TestComplete not have the right to access the data?