ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> ODBC General Issues >> Re: ODBC all of a sudden wants a UserN and PW?
http://www.istechforum.com/YaBB.pl?num=1323213524

Message started by AndyOB on 12/06/11 at 16:28:30

Title: Re: ODBC all of a sudden wants a UserN and PW?
Post by AndyOB on 12/06/11 at 16:28:30

Had the admin try his login, didn't work. Does it need to be a local account?

Title: Re: ODBC all of a sudden wants a UserN and PW?
Post by GasGiant on 12/07/11 at 05:59:08

Default is blank for both, and I believe that is the recommended setup unless you have some special need for security.

Title: Re: ODBC all of a sudden wants a UserN and PW?
Post by AndyOB on 12/07/11 at 09:53:47

Tried that, didn't work.

The only place I put a password is was in the pervasive control center. In order to access the User tab it said you had to enable security by bringing up the properties of the database, click security tab, and enter a password.

I tired that password, but I have no idea what username to use as pervasive never asked for a username when enabling security.

I tired the usual, administrator, admin, root, etc. nothing.

Title: Re: ODBC all of a sudden wants a UserN and PW?
Post by AndyOB on 12/07/11 at 11:44:16

That pervasive security option is what caused the problem. Disabled the security and the prompt went away.