Forum Discussion

lalit_singh's avatar
lalit_singh
Contributor
2 years ago

OLE error 80040E4D with Firebird database connection

I have my test complete script running for last 2 years   Now with the same code base , it is showing the error with database connection (using firebird database) and using ADO to access database ...
rraghvani's avatar
rraghvani
Champion Level 3
2 years ago

It's not easy, but I've installed Firebird-4.0.2.2816-0-x64 and Firebird_ODBC_2.0.5.156_x64, and performing a simple query which displays the records in employee table.

I managed to get TestComplete to also connect, and also display the employee records.

 

TC 64-bit can interact with 32-bit applications. If your app is 32-bit, then your ODBC driver also needs to be 32-bit.

  • lalit_singh's avatar
    lalit_singh
    Contributor
    2 years ago

    What is the connection string you have used

    I am using connection string as 
    Qry.ConnectionString ="DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=******;DBNAME=C:\\FireBird\\400-Environment\\400-Environment\\2.34\\DbFirebird\\Test.fdb;READONLY=YES";