I looked thru the list of groups, and this seemed to be the most
appropriate one to ask this question:

We are evaluating alternatives for Firebird access from an ASP
application. To that end, I downloaded and installed the lastest Firebird
odbc driver from the IBPhoenix web site. Once installation was completed,
I used the ODBC Admin function of Win2k server to setup a System DSN
pointing to a Firebird 1.5 rc6 database on the same server, using the
tcp/ip connection type (<server name>:<alias>).

I then changed the dsn that my ASP application uses (currently using the
Easysoft driver), to the newly created dsn from above.

The very first query that I run (select fiscal_month, fiscal_week,
fiscal_year from calendar where cal_date = 'today') results in an exception
with this content:

'An exception occurred'

That is all. No other hint as to what may be the problem.

I'm hoping this is a configuration issue. When setting up the dsn, I used
the following settings:

Driver = IscDbc (default)
Database = <server>:<alias> (also tried <server>:<file> just to be sure
aliases were working)
Client = <none> (also tried fbclient.dll)
Account = sysdba
Password = masterkey
Role = none
Char. Set = none

Initializing transaction = nothing checked (also tried all checked / one
checked)
Dialect = 1

Quoted identifiers = not checked

Test Connection reports success.


Using these exact same settings works on the ODBC driver. They also work
if I install this driver on my workstation and use something like Excel to
test it.

The asp code is this:

vDBConnection=Server.CreateObject("ADODB.Connection");
vDBConnection.Open("test");
vDataSet = vDBConnection.Execute(ASQL); <--blows up here


Any advice greatly appreciated,

Bob M..