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

I have no experience with the IBPhoenix driver. I use the Gemini driver
extensively with no problems. I do not use DSN's, I use DSN less connection
strings e.g.
Sub Application_OnStart
Application("MainConn_ConnectionString") = "DRIVER={Gemini InterBase ODBC
Driver
2.0};PROTOCOL=2;SERVER=myserver/3051;DATABASE=c:\path\filename.gdb;VERSION=6
;DIALECT=3;OPTIONS=256;UID=fbusername;PWD=fbpassword;"
Application("MainConn_ConnectionTimeout") = 15
Application("MainConn_CommandTimeout") = 30
Application("MainConn_CursorLocation") = 3
End Sub

So I cannot comment on what can be returned in terms of errors messages from
your driver. But I usually get something sensible.

today is a keyword like CURRENT_TIMESTAMP or NOW ? then have you checked
using alternative means of quoting it? or changing the 'identifiers'
setting?

finally..

> vDBConnection.Open("test");

what is "test"
it should be a connection string not a DSN ???
e.g. in my code

> vDBConnection.Open(Application('MainConn_ConnectionString'));

would work
a DSN example would be
Session("SesConn_ConnectionString") = "DSN=Test;User
Id=sysdba;PASSWORD=masterkey;"

> vDBConnection.Open(Session('SesConn_ConnectionString'));

hope this helps

Alan
(no spreadsheets here)