Subject | password database problem |
---|---|
Author | cecil1_5 |
Post date | 2005-02-14T21:32:27Z |
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
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