Forum Discussion
rraghvani
2 years agoChampion 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_singh2 years agoContributor
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_singh2 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
- 3 years ago
- 2 years ago
Recent Discussions
- 5 hours ago