Forum Discussion
32 Replies
- rraghvaniChampion Level 3
Is the Firebird Server installed and running? Is the connection string correct? And the credentials correct?
- lalit_singhContributor
Yes;
1.FireBird service is running
2.Credentials are correct
3.Connection string is correct
Dont have the clue now
- rraghvaniChampion Level 3
If you haven't changed anything on your side, then most likely something has changed on the database side.
If you do an internet search for "OLE 80040E4D", there's plenty of results to indicate the possible issue/solution.
- lalit_singhContributor
Can you please share me sample connection string that may be running at your end with firebird database?
- rraghvaniChampion Level 3
I don't use Firebird. The code you have provided is a standard error code for OLE.
Again, if you do an internet search for "firebird database connection string", the top result will be https://www.connectionstrings.com/firebird/
- lalit_singhContributor
Yup;
Error is for the OLE only , but somehow it is not working because everything seems to be correct
Is there any associated dll for ADO present in Test complete installation directory that may be point of concern?
- rraghvaniChampion Level 3
I suggest you use Poweshell, https://stackoverflow.com/questions/18704610/powershell-connect-to-firebird, to test your connection to see if it's ok.
- lalit_singhContributor
Is it possible to use 64 bit odbc driver for database connection in test complete?
- rraghvaniChampion Level 3
Yes, it's possible.
Have you tried another program, such as PowerShell, to test your connection?
- lalit_singhContributor
I tried with .UDL file , connection is working
My environment is having 64 bit firebird database so I am using Odbc 64 bitBut it is not working in Test complete
- rraghvaniChampion Level 3
I'm assuming you are using 64-bit version of TestComplete?
- lalit_singhContributor
No , I am working with 32 bit version of Test complete
And database connection was working fine till now from long timeAnd one more info , the application that is under test is 32 -bit but database is 64 bit
- AlexKarasChampion Level 3
Hi,
> My environment is having 64 bit firebird database so I am using Odbc 64 bit
> I am working with 32 bit version of Test complete
That's the root of the problem.
If 64-bit ODBC is required to connect to your Firebird server, then 64-bit TestComplete is required.
In general: 32-bit TestComplete can use 32-bit ADO only and 32-bit ADO can access 32-bit ODBC only.
Likewise, 64-bit TestComplete can use 64-bit ADO only and 64-bit ADO can access 64-bit ODBC only.
Whether or not 64-bit ODBC can access 32-bit server and vise versa is another irrelevant question.
The key point is that bitness for TestComplete-ADO-ODBC chain must match.
- rraghvaniChampion Level 3
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_singhContributor
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";
- rraghvaniChampion Level 3
I am using,
"DRIVER=Firebird/InterBase(r) driver; User ID=sysdba; Password=letmein; DBNAME=employee;";
which was one of the examples shown in ODBC Help.
- lalit_singhContributor
have you made any change in conf file
Also password you set it or it is already there?
- rraghvaniChampion Level 3
The password was set during installation. Everything else was left untouched. I just followed the getting started document.
- lalit_singhContributor
At my end it is still not working
1.Test complete is getting run in 32 bit
2.Because database is 64 bit , so odbc connection has been setup using 64 bit
But on running , database is not getting connected
- rraghvaniChampion Level 3
Using TC (new project) and ODBC 64-bit, use the following script with the appropriate values to query your database and test the connection
function FireBirdDB() { var AConnection = ADO.CreateConnection(); AConnection.ConnectionString = "DRIVER=Firebird/InterBase(r) driver; User ID=sysdba; Password=letmein; DBNAME=employee;"; AConnection.Open(); var rec = AConnection.Execute("SELECT * FROM employee;"); while (!rec.EOF) { Log.Message(rec.Fields.Item("FIRST_NAME").Value); rec.MoveNext(); } AConnection.Close(); }
Check that the file exists, C:\FireBird\400-Environment\400-Environment\2.34\DbFirebird\Test.fdb and that you can connect via Firebird ISQL tool. Check the port number is not being blocked.
- lalit_singhContributor
Database file do exist
With full path provided for database , it is getting connected via FireBird ISQL tool
But with the ODBC defined name , showing SQLState 08001 error
- lalit_singhContributor
With full database path provided , database is getting connected via Firebird ISQL tool.
But with ODBC defined name , it is showing error
SQLSTATE : 08001
Related Content
- 3 years ago
- 2 years ago
- 11 months ago
Recent Discussions
- 2 days ago