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?
Is the Firebird Server installed and running? Is the connection string correct? And the credentials correct?
Yes;
1.FireBird service is running
2.Credentials are correct
3.Connection string is correct
Dont have the clue now
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.
Can you please share me sample connection string that may be running at your end with firebird database?
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/
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?
I suggest you use Poweshell, https://stackoverflow.com/questions/18704610/powershell-connect-to-firebird, to test your connection to see if it's ok.
Is it possible to use 64 bit odbc driver for database connection in test complete?
Yes, it's possible.
Have you tried another program, such as PowerShell, to test your connection?
I tried with .UDL file , connection is working
My environment is having 64 bit firebird database so I am using Odbc 64 bit
But it is not working in Test complete
I'm assuming you are using 64-bit version of TestComplete?
No , I am working with 32 bit version of Test complete
And database connection was working fine till now from long time
And one more info , the application that is under test is 32 -bit but database is 64 bit
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.
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.
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";
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.
have you made any change in conf file
Also password you set it or it is already there?
The password was set during installation. Everything else was left untouched. I just followed the getting started document.
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
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.
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
With full database path provided , database is getting connected via Firebird ISQL tool.
But with ODBC defined name , it is showing error
SQLSTATE : 08001
