database error

2 Topics

ADO Connection is not working
Hi, While trying to connect to Ingress Database through Test Complete, Connection is not happening. set Conn =ADO.CreateADOConnection() set Rec = ADO.CreateRecordset Conn.ConnectionString = "Provider=MSDASQL;DRIVER=Ingres II Read Only;Data Source=LMK2 AUTO;SERVERTYPE=INGRES;Database=itvtestauto;User ID=itvsql;Pwd=W1llows" Conn.LoginPrompt = False Conn.Open() log.message Conn.Connected set Rec = Conn.Execute_("select * from sare") log.Message Rec.rowCount Conn.Close Conn.Connected returns False and whatever query we run using this connection is not executed. Could you please help us in this scenario.
Solved
Subbulakshmi
8 years ago Place TestComplete Questions
3KViews
0likes
8Comments
Getting EDatabase Error randomly while executing VBScript code
Hi, In our execution we need to fetch some data from database and enter the value in Grid view(Delphi application). While doing this, I am getting the below error randomly. VBScript runtime error. An exception occurred: 0x0EEDFADE; class: EDatabaseError; description: 'There was a serious system error.YN 26/03/2018 14:21:43 User: ITVPLC deepsubb Server: YWAST057 Database ID: 1 Database Name: itvtestauto Last Upgrade Token: 2.31 02/03/2018 15:00:52 Version: 2.31.015.006 Function Name: Exception: EDatabaseError Invalid value for field 'Sales Area' System Error Code: Not known Stack trace: Physical Logical Unit (######) Routine 00479E0D 00078E0D DB.DB.DatabaseError 00479E82 00078E82 DB.DB.DatabaseErrorFmt 0047DF11 0007CF11 DB.DB.TField.SetAsVariant 00A5392F 0065292F cxDB.cxDB.SetFieldValue 0075A9C8 003599C8 cxCustomData.cxCustomData.TcxCustomDataController.SetEditValue 009FB061 005FA061 cxGridCustomTableView.cxGridCustomTableView.TcxCustomGridTableItem.SetEditValue' Error location: Unit: "ITV_TestAutomation_Framework\DealTestSuite\Script\TestDummy" Line: 554 Column: 3. VBScript runtime error. An exception occurred: 0x0EEDFADE; class: EDatabaseError; description: '<ErrorInfo><Error number="11043"><EMessage>There was a serious system error.</EMessage><ELog>Y</ELog><EServer>N</EServer><ELoggedMessage> 26/03/2018 14:21:43 User: ITVPLC deepsubb Server: YWAST057 Database ID: 1 Database Name: itvtestauto Last Upgrade Token: 2.31 02/03/2018 15:00:52 Version: 2.31.015.006 Function Name: Exception: EDatabaseError Invalid value for field 'Sales Area' System Error Code: Not known Stack trace: Physical Logical Unit (######) Routine 00479E0D 00078E0D DB.DB.DatabaseError 00479E82 00078E82 DB.DB.DatabaseErrorFmt 0047DF11 0007CF11 DB.DB.TField.SetAsVariant 00A5392F 0065292F cxDB.cxDB.SetFieldValue 0075A9C8 003599C8 cxCustomData.cxCustomData.TcxCustomDataController.SetEditValue 009FB061 005FA061 cxGridCustomTableView.cxGridCustomTableView.TcxCustomGridTableItem.SetEditValue</ELoggedMessage><EFormName></EFormName></Error></ErrorInfo>' Error location: Unit: "FileName\DealTestSuite\Script\TestDummy" Line: 554 Column: 3. I have closed DB Connection properly.
Subbulakshmi
8 years ago Place TestComplete Questions
1.1KViews
0likes
3Comments