Firebird Database connectivity with ASP
Posted on 2004-09-17
I have a Firebird Application. I am trying to create a web interface to the Database. I am using the IBPhoenix ODBC Drivers on a Windows 2000 Server.
I have written other web applications using MS SQL Server with no problems but at the moment I cannot get the Database to even connect.
Here is my Connection Script
Set RecordSet1 = Server.CreateObject("ADODB.RecordSet")
connect = "data source=wsiyard;user id=SYSDBA;password=masterkey;dbase=c:\warehouse\warehouse.gdb"
query = "select * from export_checkin"
adOpenKeyset = 1
recordset1.Open query, connect, adOpenKeyset <---- Error Occurs here.
I get an error. "unavailable database"
I have confirmed all the settings in the ODBC Configuration are Correct. The Database does exist. It just will not Connect.
Please any ideas, comments and solutions would be much appreciated.