I am having a problem authenticating against an msaccess database. The DSN is correct and I don't get a connection error. Which db type should I be using? 'access' or 'ado-access'. I have checked accessing the db using excel and it works fine. When I run the query in msaccess it returns the correct result.
I generated the query by echoing the code in the auth_user_login method and then cutting and pasting it into the query editor in msaccess. When I checked the number of records returned by using the $rs->RecordCount() function I recieved a big fat 0. Could adodb be the cause of my problem?
Scott
Indeed it turned out that there is a problem with the msaccess portion of external authentication. I have a quick hack that I added to the /auth/db/lib.php file although I think that further hunting will find the real culprit. I also suspect that I will have to modify the auth_get_userinfo method in order to complete the retrieval of all user information on first login.
My hack is in the attached file.
My hack is in the attached file.