Subject | Firebird Connection problem (ASP/IIS/ODBC v1.2.0) |
---|---|
Author | n30npill |
Post date | 2005-01-20T10:56:12Z |
Hi!
I hope this is the right group I'm posting to here, if not, please
advise.
I recently heard about, then promptly installed Firebird 1.5.2. It
works like a charm by itself on my Windows XP PC. Now to actually
make use of it, I'm trying it out on my development ASP system through
ODBC. I got the ODBC drivers from IBPhoenix, installed, and
configured an ODBC connection to a test database. Settings are as
follows (ODBC):
DSN: dev3f
DRIVER: IscDbc
DATABASE: C:\DEV3FIRE.GDB
CLIENT: <BLANK>
ACCOUNT: SYSDBA
PASSWORD: masterkey
ROLE: <BLANK>
CHARACTER SET: NONE
DIALECT: 3
QUOTED IDENTIFIER: OFF
Other options are off.
When I try to establish an ODBC connection, I get this error:
"Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
unavailable database
/Include/System.inc, line 150"
The IIS/ASP side is sound (it works perfectly with other databases: I
have succesfully connected to MS SQL Server; MySQL and PostgreSQL),
and the database itself works fine through isql. Additionally,
testing the connection using the "Test Connection" button works!
I have seen various posts all over the net regarding this or a similar
issue, but there seems to be a lack of answers.
What could the problem be?
I hope this is the right group I'm posting to here, if not, please
advise.
I recently heard about, then promptly installed Firebird 1.5.2. It
works like a charm by itself on my Windows XP PC. Now to actually
make use of it, I'm trying it out on my development ASP system through
ODBC. I got the ODBC drivers from IBPhoenix, installed, and
configured an ODBC connection to a test database. Settings are as
follows (ODBC):
DSN: dev3f
DRIVER: IscDbc
DATABASE: C:\DEV3FIRE.GDB
CLIENT: <BLANK>
ACCOUNT: SYSDBA
PASSWORD: masterkey
ROLE: <BLANK>
CHARACTER SET: NONE
DIALECT: 3
QUOTED IDENTIFIER: OFF
Other options are off.
When I try to establish an ODBC connection, I get this error:
"Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
unavailable database
/Include/System.inc, line 150"
The IIS/ASP side is sound (it works perfectly with other databases: I
have succesfully connected to MS SQL Server; MySQL and PostgreSQL),
and the database itself works fine through isql. Additionally,
testing the connection using the "Test Connection" button works!
I have seen various posts all over the net regarding this or a similar
issue, but there seems to be a lack of answers.
What could the problem be?