Prev   Next

Back to the top of the FAQ

Q. I am using the ODBC interface, and when I hit the Test button, it says there are 243 record, which is right. The directory I have protected prompts for a login and Internal Database users can get in, but users in my ODBC database cannot! What is going on - why doesn't it work like it says it should?

A. Likely the database field are set up as fixed width chars. The database will pad them with spaces at the end. So what looks like "User1" is in fact "User1         ". Of course, this won't match the name supplied by the user in the dialog prompt. Make sure your username and password fields are variable chars. Then they won't be padded with spaces.

Alternatively, set the Trim spaces option in the Options/ODBC-options dialog.

Back to the top of the FAQ

Prev   Next