> I am trying to use an ODBC connection to set up a simple asp page.
>
> I get 'cannot attach to password database' as a returned error
> message. (the error return works really well!)
>
> I installed Firebird Superserver 1.5 using the exe under windows 2000
> I installed the ODBC downloaded from IBPhoenix for windows (that's
> Firebird_ODBC_1.2.0.69-Win32.exe)
>
> Once I put the full path name (including the server name) in for the
> database, I got a 'connection successful' message from the test.
>
> I am running a simple asp program on the local server, checking my
> sql in ISQL first to make sure I do not have syntax errors. The
> connection string is:
> Application.Contents("FBCONNECT") = "Provider=MSDASQL;Persist
> Security Info=False;Data Source=" & Application.contents("FBDSN")
> & ";UID=SYSDBA;PWD=masterkey"
>
> where the FBDSN is the name I assigned to the ODBC System DSN.
>
> I set up a readonly user, which I intend to use instead of SYSDBA in
> the app, once I get it to work.
>
> can anybody tell me what I did wrong now?
>
> Ann Cecil

and in the DSN - did you prefix the path/filename with
"localhost:" ?
Alan