Forum Discussion

teemu_selkala's avatar
teemu_selkala
Occasional Contributor
13 years ago

Database checkpoint issue

Hi,



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?


1 Reply


  • Hi Teemu,


     


    As far as I understand, the above code works fine, but creating a Database checkpoint fails with the "Data provider or other service returned E-fail statement" error, right? In this case, could you please contact our Support team and provide them with the structure of table_info.