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

here:
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 :: 19.1.4.3 Configuring a Connector/ODBC DSN on Windows


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

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
regards
anurag Upadhyay(india)
My System SpecsSystem Spec
.


Reply

 No DSN in ODBC Data Source Admin




Thread Tools



Similar help and support threads for2: No DSN in ODBC Data Source Admin
Thread Forum
Solved Number data in 10 columns and 25 rows pasted from other source is text Microsoft Office
Data Source Not Found on Windows using MyODBC connector Software
ODBC Configuration General Discussion
ODBC Data Source Administrator - Create Shortcut Tutorials
Where are Data source Names (DSN's) stored? General Discussion
odbc Software
Why is my Backup data bigger than it's source 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 02:59 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33