AcuXDBC prompts for username and password but the database doesn't use them

0 Likes

Problem:

With AcuXDBC created the system catalog without security, e.g. did not use the -pa option.

When accessing the tables from Microsoft Access a prompt with the User/Password dialog is always dispalyed.  If they are left blank and enter is pressed it proceeds, so it does not need a username or password.  

How can that popup be avoided?

Resolution:

The AcuXDBC driver is prompting because there is no username or password specified in the DSN.

Even though the AcuXDBC system catalog doesn't use security the driver can't know that before it connects.  Since the username and password are empty it prompts for them.  

The solution is to configure the DSN and add any value for Username and Password.

Old KB# 2855
Comment List
Related
Recommended