Database checkpoint issue
I checked out database values succesfully with following code:
function checkout()
{
var Conn
Conn= ADO.CreateConnection()
Conn.ConnectionString="Provider=MSDAXXX.1;Persist Security Info=False;User ID=XXXXXX;Password=XXXXXX;Data Source=source_source";
Conn.Open();
Cmd = ADO.CreateCommand();
Cmd.ActiveConnection = Conn;
Cmd.CommandType = adCmdText;
Cmd.CommandText = "select * from table_info where contact_email ='specific.email@specific.com'";
RecSet = Cmd.Execute();
RecSet.MoveFirst();
while (! RecSet.EOF )
{
Log.Message(RecSet.Fields("Value1").Value, RecSet.Fields("Value2").Value);
RecSet.MoveNext();
}
Conn.Close();
}
Then I considered doing database checkpoint and I failed and don't have a clue why :). I used connection string as copy-paste from working code and chose checkbox Custom Query option after which I copy paste the query but I tend to get error "Data provider or other service returned E-fail statement".
Any hints how to solve that?