Interesting.... Been using ODBC with no problems for months from both Access
and Excel. Went to create a new query the other day and ran into this same
problem. I was using Excel at the time. I found if I went in and did an edit
of an existing query that works and saved it as a new name I could then use
it and get prompted for user/passwd as expected.

Haven't spent much time looking into it at this point.

Curt Magura
Lockheed Martin
Enterprise Information Systems
Gaithersburg Md.
301-240-6305


                -----Original Message-----
                From:   Loon, E.J. van - SPLXM [mailto:Eric-van.Loon AT KLM DOT 
NL]
                Sent:   Thursday, May 06, 1999 10:43 AM
                To:     ADSM-L AT VM.MARIST DOT EDU
                Subject:        Re: ODBC ont prompting for userid/password

                Hi Dirk!
                I did exactly the same as you described: I am not prompted
for a
                userid/password. I receive the ADSM ODBC Setup screen again.
Here, there is
                no userid/password field and thus I receive an error again.
I see through an
                ADSM console window that a session is established with the
server. Because
                no admin account is used it refuses this connection.
                Kindest regards,
                Eric van Loon