ODBC/DSN help needed - TechRepublic
Question
May 24, 2012 at 05:40 AM
dave.dawsn

ODBC/DSN help needed

by dave.dawsn . Updated 14 years, 1 month ago

I need help badly here…the publisher of FormDocs has made it clear that I’m on my own despite repeated appeals for help.

Anyway, here is the situation:

I administer a mixed XP/7 environment. The user in question was recently upgraded from XP SP3 to Win 7 SP1 (x64). Since the upgrade, she has been unable to use a particular form using the FormDocs Filler software. The problem is, every time she tries to work with the form, she gets an ODBC error that says the DSN file is not available. (I don’t have the exact text of the error right now because I’m no longer at the office, but I can provide it if needed.)

Here’s the weird part: the DSN files are on user’s machine – they are copied from the server to the correct directory upon login, so it isn’t an issue of missing or invalid/corrupt DSN files.

Also, when I log in to her machine as myself, the form works perfectly for me. Likewise, when I use that form on my own PC, it works fine, but if I log in as this particular user, it does not work either. At first, I thought this was a permissions issue, but I’ve pretty much ruled that out. Plus, other users in my organization have Win 7 PCs and can still work with this form.

Finally, I tested the form using this user’s login on an XP machine and everything worked properly.

The fact that her username is having issues on multiple Win 7 PCs suggests it’s a Win 7-related problem, but I have no idea what that might be. The application runs off a server, so the .exe isn’t even on the local machine.

Any help would be super appreciated.

Thanks

———————

UPDATE:

I created a test user account in AD and assigned it the same permissions/groups/etc as the user having the problem, and it isn’t working with that user account either. Same behavior: it runs the FormDocs Filler software without incident, but when the particular form is being used, the dropdown menu that uses an ODBC-based lookup doesn’t work.

This discussion is locked

All Comments