Subject Re: [firebird-support] Firebird Connection problem (ASP/IIS/ODBC v1.2.0)
Author Martijn Tonies
Hello,

> 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

Change this to include the host-name of your server.

> 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?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com