Subject Error using Firebird driver to connect from ASP
Author Stevio
I have installed the IBPhoenix Open Source ODBC Driver from this page:
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_60_odbc

I am trying to get a connection string to work from an ASP web page. I have
tried both version 1.2 and version 1.2.1 and neither is working.

I am getting the following error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
unavailable database
/default.asp, line 9

I have tried various connection strings of the following formats:
MM_cnLibrary2_STRING = "DRIVER=Firebird/InterBase(r)
driver;UID=sysdba;PWD=masterkey;DBNAME=C:\data\LIBRARYV2.FDB"

Tried using aliases.conf alias:
MM_cnLibrary2_STRING = "DRIVER=Firebird/InterBase(r)
driver;UID=sysdba;PWD=masterkey;DBNAME=LIBDATA;"

Tried ODBC connection:
MM_cnLibrary_STRING = "dsn=testfb;"

All of these are giving the same error. I am using Windows XP Professional
and Firebird version 1.5.1.

Thanks,
Stephen