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

----- Original Message -----
From: "Alan McDonald" <alan@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, February 14, 2005 4:44 PM
Subject: RE: [firebird-support] password database problem


>
> > 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 is the DSN a SYSTEM DSN?
> Alan
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>