For a while I was stuck trying to get a visual basic 6 app working in Windows 7. The last remaining snag was that it just couldn't find the DSN when starting up. On a hunch, I deleted the system DSN and created it exactly the same way, but in Users. Suddenly everything worked great. I couldn't beleive it so I tried to move it back to system thinking I may have had something wrong, but sure enough it was broken again.
I can't seem to find anyone else running into this in my google searches, but does any one have any ideas as to why this might happen?
I'de really like to go back to using the system DSN as that's easier to manage.
Thanks!
What happens if you start your VB6 application by right-clicking the icon and choosing "Run as administrator"? I suspect you would then see the System DSNs (which are presumably only visible to admin-level accounts).
Update: I think this will work - set up your system DSN by running this:
C:\Windows\SysWOW64\odbcad32.exeI think the problem is that the default Win7 interface for configuring DSNs makes them 64-bit, but you need a 32-bit DSN to work with VB6.
</PUREGUESSWORK>