New
#1
No DSN in ODBC Data Source Admin
I have a new HP 6200 small form factor that came pre-installed with Windows 7 64bit. I installed our corporate copy of MS Office Pro 2003 and then installed UPS Worldship 2011, which requires an ODBC to connect to our Access database.
When I go into the ODBC to set up the connection under System DSN, it's completely blank. No Access DSN, no Excel DSN, completely blank. If I try to ADD a DSN the only options shown are SQL DSNs which I can not use.
Initially, I called UPS Worldship Support. They referred me to Microsoft. After nearly 2 hrs on the phone with MS, they told me to call HP since HP preinstalled the Windows 7 and they handle any software/warranty issues.
So, I called HP. Their support is the pits. Nobody I talked with even knew what a DSN is (they kept telling me it was DNS not DSN and they are 2 different things!!). Then, they suggested I call Microsoft and PAY to have them help me.
This is a brand new PC and it's a Windows 7 issue, not Worldship, not hardware, yet I can get any help.
I've tried some of the options on the various forum (running the 32 bit.exe, copying files, etc) and nothing has worked.
Anyone have any ideas HOW I can get the Access and Excel DSNs in the ODBC Manager? I need help asap as this is a critical PC to our shipping area. Without it, we are unable to ship via UPS and losing $$$.
Thanks for any suggestions because I'm fed up with Microsoft AND HP!!!