Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: No DSN in ODBC Data Source Admin

13 Oct 2011   #1

Windows 7 Pro
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!!!

My System SpecsSystem Spec
15 Oct 2011   #2

Windows 7 Home Premium 64bit

Hello tandrews, welcome to the forum.

First, let me say that the subject of your query is not actually in my knowledge base, However, in an effort to assist I did a search and thought I would offer the following:
ODBC: frequently asked questions

Step-by-step guide on how to set up DSN in ODBC Data Source Administrator on Windows.

and here:
MySQL :: MySQL 5.0 Reference Manual :: Configuring a Connector/ODBC DSN on Windows

Hopefully something in there might help. :)
My System SpecsSystem Spec
28 Sep 2012   #3
Anurag Upadhayy

window 7 basic 64 bit
JdbcOdbc Dsn connection for Window 7 64 bit machine

follow the following step;
right click on data source (odbc) under administrative tool
go to the properties.and change the following things
target :%SystemRoot%\SysWOW64\odbccad32.exe
start in :%SystemRoot%\SysWOW64
press ander and as admin
anurag Upadhyay(india)
My System SpecsSystem Spec


 No DSN in ODBC Data Source Admin

Thread Tools

Similar help and support threads
Thread Forum
email merging using Excel as a data source
I have WIN 7 Home Premium (service pack 1) 64-bit. I have several email addresses including gmail & hotmail and I use Windows Live Mail version 2012. I do not have Outlook. I have been asked to do some email merging for a club I belong to. The data source is an Excel spread sheet with names and...
Microsoft Office
Number data in 10 columns and 25 rows pasted from other source is text
..... and I want to convert the lot to 2 decimal place numbers. Excel has several methods, but none seem to work for conversion in bulk. Working on futher cells from a suitably formatted one does not work. Is the only way to solve my problem to manually enter the numbers elsewhere, clear the...
Microsoft Office
ODBC Data Source Administrator - Create Shortcut
How to Create a "ODBC Data Source Administrator" Shortcut This will show you how to download or create a ODBC Data Source Administrator shortcut in Windows 7. For more detailed information about ODBC Data Source Administrator, see: Using the ODBC Data Source Administrator ODBC Data...
Where are Data source Names (DSN's) stored?
DSN's were here (HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\) in XP. Where did they go in Win7? Thanks.
General Discussion
Why is my Backup data bigger than it's source
Hi, I wondering if anyone can help answer a problem I am experiencing with using Windows 7 own backup tool. I have two 500GB hard drives in my system. Drive 0 is partitioned with 390 GB as the C: drive containing Windows 7 and user data, the remaining space is unallocated ready for me to...
Backup and Restore

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 16:48.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App