Subject RE: [firebird-support] Connection string for ASP web site
Author Alan McDonald
> 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