Thanks Alan. I have downloaded a trial of that and that will allow me to get
on with the development of the ASP web site. However, the cost of the
licence is $200 for a Web/application server licence. Are there not
free/cheaper options? Can I not just create an ODBC connection (although I
tried this and it didn't work - it should be possible though right)?

What about using the config alias thing - can that be done with an ASP web
app?

I downloaded a free driver from here:
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_60_odbc
but did not manage to get it working with the ASP pages.

I also found another driver here:
http://www.xtgsystems.com/linux/ofbodbc/about.php

What would you recommend?

I am using ASP code in this format:
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_cnLibrary2_STRING
MM_cnLibrary2_STRING = "DRIVER={Gemini InterBase ODBC Driver
2.0};PROTOCOL=2;SERVER=localhost;DATABASE=C:\Documents and
Settings\data\mydatabase.fdb;VERSION=6;DIALECT=3;OPTIONS=256;UID=sysdba;PWD=masterkey;"
%>


Thanks,
Stephen

----- Original Message -----
From: "Alan McDonald" <alan@...>
To: <firebird-support@yahoogroups.com>
Sent: Wednesday, November 02, 2005 8:23 PM
Subject: RE: [firebird-support] Connection string for ASP web site


>> I am working on an ASP web site with a Firebird database.
>>
>> I would like to make a DSN-less connection string to connect to
>> the Firebird
>> database like I do with Access databases. Can anyone tell me what the
>> connection string should be like, and do I need to download a specific
>> driver from somewhere?
>>
>> Should I be using the config alias that I use for my Delphi apps?
>>
>> Thanks,
>> Stephen
>>
>
> you need an ODBC driver which supports DSN-less connection strings
> GEMINI is one (I use it) there may be others - not sure about the
> IBPhoenix
> one.
> This is an example of the GEMINI dsn-less connection
>
> <SCRIPT LANGUAGE=VBScript RUNAT=Server>
> Sub Application_OnStart
> Application("MainConn_ConnectionString") = "DRIVER={Gemini InterBase ODBC
> Driver
> 2.0};PROTOCOL=2;SERVER=server/3051;DATABASE=c:\data\mydata.fdb;VERSION=6;DIA
> LECT=3;OPTIONS=256;UID=myuser;PWD=mypword;"
> Application("MainConn_ConnectionTimeout") = 15
> Application("MainConn_CommandTimeout") = 30
> Application("MainConn_CursorLocation") = 3
> End Sub
> </SCRIPT>
>
> Alan