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: how to establish a ODBC connection in Windows 7 64 bit ?

04 Aug 2012   #1
Babis49

windows 7 Ultimate x32
 
 
how to establish a ODBC connection in Windows 7 64 bit ?

Hello,
I have created a ODBC connection between MS Acceess 2003 and Excel 2003 in Windows 7 32bit enviroment . The Macro ( code ) is as follows :
ActiveSheet.QueryTables.Add(Connection:=Array(Array( _
"ODBC;DSN=MS Access Database;DBQ=D:\Acces7dat\STOCKS.mdb;DefaultDir=D:\Acces7dat;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTim" _
), Array("eout=5;")), Destination:=Range("A1")) ... etc , transferring data from MS Access file stocks.mdb to an Excel spreadsheet for proccessing etc . All this works fine for the last three years until I have installed Windows 7 64 bit . Googling the problem found that I have to run the Windows/SysWOW64/obdcad32.exe file . Doing this appears the ODBC Data Source Admiinstrator with the tabs :
User DSN , System DSN , File DSN , Drivers , Tracing , Connection Pooling and About , and I can't configure all this in order to create a ODBC connection . First , is this the correct way to solve the problem and second how to setup the ODBC Data Source Admiinstrator under all these tabs ? Any help ? thanks in advance.
PS : I have reinstall Ms office 2003 in order to add missing items etc but no luck .


My System SpecsSystem Spec
.
05 Aug 2012   #2
Babis49

windows 7 Ultimate x32
 
 

the problem was solved by ODBC Data Source Admiinstrator , pressing the button " Add " and afterwards writing " MS Access 2003 " just right the DSN ( = Data Source Name ) label and OK , no matter should understand all of this .

thanks anyway
My System SpecsSystem Spec
Reply

 how to establish a ODBC connection in Windows 7 64 bit ?




Thread Tools




Similar help and support threads
Thread Forum
Windows Media Center cannot establish a connection xbox???
Hi there I like to use windows media center on xbox but for some reason I cannot get it to work. I tried pretty much everything and I got it to work for one day and then it stopped working again. I have tried deleting old media center profile data, certificates, media center ehome folder,...
Media Center
ODBC connection problem
I'm running 2005 SQL server on Windows 2008 server. I have both Windows 7 and XP ODBC connections to the server. Everything was working fine but the server was running slow so I tried a windows update. The update made my ODBC connection go flakey, but only on Windows 7. Testing the connection would...
Network & Sharing
Unable to establish Remote Desktop Connection Windows 7
Hi, Long time linux user, but first day of working remotely from home today so went out and bought a copy of Windows 7 Home Premium this morning. I am trying to access my work PC remotely after doing a fresh install of windows and receiving the below: "Remote desktop can't connect to...
Network & Sharing
Cannot establish remote desktop connection
I cannot establish a remote desktop connection between two computers in my home LAN running Windows 7. I have two computers in my home network, VAIO and SCALEO. On VAIO I installed Windows 7. On SCALEO I installed both Windows XP and Windows 7 as dual boot configuration. The Windows 7 version I...
Network & Sharing
Crash When Trying to Establish USB Modem Connection
Hi, I have a problem with a 3G USB "dongle" type modem (a Huawei E173) - Windows tries to establish a connection but then computer black screens and reboots and on startup says it has recovered from a BlueScreen. I have tried setting up a manual dial up networking connection to bypass the supplied...
BSOD Help and Support
Can't establish VPN connection
I am getting this error when I try to connect with VPN. It worked in ealier builds than 7057. Anyone seen this?
Network & Sharing


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 15:31.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App