General discussion
-
Topic
-
INVISIBLE SYSTEM DSN’S
LockedI am losing my DSN connections, when I try to create a new SYSTEM DSN everything is fine but when I actually try to use it I always get this error:
Microsoft OLE DB Provider for ODBC Drivers error ‘80004005’
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Its not in my code or in the spelling of the DSN names or anything like that because even working ones that have been in place stopped working after I pulled them up in the ODBC config program in control panel. They were working fine till I did that. and now any that I have looked at the configuration of do not work and I can create new onces but every time I try to use it I get the error above. I’ve installed the latest MDAC, re-installed my SP. Articles in MSKB only refernce spelling errors in code. This is not the case because working ones that have been in place for over a year no longer work.