Forum Discussion
rraghvani
Champion 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_singh
2 years agoContributor
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
- 4 years ago
- 10 years ago
Recent Discussions
- 4 days ago
- 4 days ago
- 8 days ago