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

 

Any input?

  • rraghvani's avatar
    rraghvani
    Champion Level 3

    If you try a different application that uses ODBC to connect to your Firebird DB, I'm very certain you will get the same error.

    • lalit_singh's avatar
      lalit_singh
      Contributor

      Hello

      Thankyou for the reply, I am able to resolve the issue with new connection string using oledb

    • lalit_singh's avatar
      lalit_singh
      Contributor

      I went through it but till now did not have exact reason for failure

      Seems like issue with system configuration

  • rraghvani's avatar
    rraghvani
    Champion Level 3

    What's the new connection string that you are using, which works?

    • lalit_singh's avatar
      lalit_singh
      Contributor

      rraghvani 

      Provider=MSDASQL.1;Password=*****;Persist Security Info=True;User ID=SYSDBA;Data Source=Test

  • rraghvani's avatar
    rraghvani
    Champion Level 3

    So you are now using Microsoft OLE DB provider for ODBC, and not Firebird ODBC? And it seems your database is now running as a service? Are you still using Firebird database?