Subject RE: [firebird-support] password database problem
Author Alan McDonald
> yes it is a system dsn. I meant to include that fact.
>
> in the ODBC setup, I named the DSN 'Delta'; the path name is in the
> databases setup.
>
> are you saying that rather than coding: Application.Contents("FBDSN") =
> "Delta"
> in the asp, I should be coding Application.Contents("FBDSN") =
> "localhost/Delta" ?
>
> then if I eventually get this work, when I move to a real client
> box, I have
> to put the servername in as part of the DSN?
>
> this is not the way any other ODBC protocol I've used works.
>
> Ann Cecil

no - I mean the DSN in the ODBC setup must also be prefixed by the
servername and not just the path. Personally I prefer DSN-less connection
strings
e.g.
Sub Application_OnStart
Application("MainConn_ConnectionString") = "DRIVER={Gemini InterBase ODBC
Driver
2.0};PROTOCOL=2;SERVER=servername/port;DATABASE=c:\fbdata\fbfilename.fdb;VER
SION=6;DIALECT=3;OPTIONS=256;UID=SYSDBA;PWD=masterkey;"
Application("MainConn_ConnectionTimeout") = 15
Application("MainConn_CommandTimeout") = 30
Application("MainConn_CursorLocation") = 3
End Sub

Alan