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: Win7 x64 / Office 2010 - ODBC connect error

25 Aug 2010   #1
GRoston

Windows 7 x64
 
 
Win7 x64 / Office 2010 - ODBC connect error

I have a MS Word application which uses a DSN-less connection to access a remote SQL database and which runs properly under a 32 bit OS. However, on my Windows 7 x64 systems with Office 2010 (32 bit) I get the following error when running the application:

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

I have done a bunch of searching, and have found a number of suggested solutions. The one which seems most likely to work is to install the Office System Driver Data Connectivity Components 2010.

Is this the best approach for solving the problem? If so, should I install the 32 or 64 bit version? If this is not the best approach, what would you suggest?

Thank you.


My System SpecsSystem Spec
.
25 Aug 2010   #2
ryo

 
 

i don't try yet Ms office 2010.
but i think the work is same with the other Ms.office
i'm also run the excel and connected to the dbase using ODBC.
did you already add the dbase source in it?
My System SpecsSystem Spec
26 Aug 2010   #3
GRoston

Windows 7 x64
 
 

I have learned more. Sadly, the problem does not seem to be limited to my Win7 x64 machine. I have tried this application on two different XP machine and have received the exact same error message. This is particularly baffling since the exact same application ran perfectly 12 months ago.

Here is the relevant VBA code:
Script:
Dim cn As ADODB.Connection 
Dim cmd 
As ADODB.Command 
Dim rs 
As ADODB.Recordset 
 
Set cn 
= New ADODB.Connection 
cn
.ConnectionString "Driver={SQL Native Client};Server=<ip_address>;Database=<db>;Uid=<uid>;Pwd=<pwd>" 
cn.CursorLocation adUseClient 
cn
.Open 
 
Set cmd 
= New ADODB.Command 
Set cmd
.ActiveConnection cn 
cmd
.CommandText "sp_name" 
cmd.CommandType adCmdStoredProc 
cmd
.Parameters.Append cmd.CreateParameter("@Param"adCharadParamInput25"Value"
Set rs cmd.Execute 
I have also determined that the problem occurs before any data is transmitted to the remote server.

Since the application did not change - the date stamp on the .doc file is last August - I do not know what to look for in order to resolve the problem. Can anyone please suggest an approach?
My System SpecsSystem Spec
.

27 Aug 2010   #4
ryo

 
 

why don't u try the office 2007 or use the office 2003??
My System SpecsSystem Spec
31 Aug 2010   #5
jimbo45

Linux CENTOS 7 / various Windows OS'es and servers
 
 

Hi there
I'm trying a similar thing but using Office 2007 -- works perfectly and I'm on W7 X64

My application is an EXCEL spreadsheet that retrieves data from a remote SQL DB and doesn't seem to have any probs.

I've got Office 2010 on a Virtual W7 32 bit machine so I'll try that later --but of course running a Virtual Machine could add another layer of complexity into the mix.

Incidentally on a VIRTUAL W2003 server machine with Office 2007 the EXCEL application runs just fine so I suspect the deal is probably with Office 2010.

Did you use the ODBC software that the remote DB requires -- for example can you just do a basic Connect to the remote DB. in command mode and run any SQL queries.

This should tell you if you've got a problem with OBDC or not.

Another but possibly silly question -- has the remote DB changed its authentication procedures or updated ITS own software. If it has you might also need to apply some fixes on your front end.

Cheers
jimbo
My System SpecsSystem Spec
31 Aug 2010   #6
ryo

 
 

i'm usually use Ms.office 2003 and 2007 too. and until now didn't have any issue.
My System SpecsSystem Spec
31 Aug 2010   #7
jimbo45

Linux CENTOS 7 / various Windows OS'es and servers
 
 

Hi there
just tried a Virtual machine (W7 X86) running Office 2010.

No problem --EXCEL application retrieves data perfectly.

I suspect that the DB software has changed so you need to update your front end accordingly.

There shouldn't be any problems with the OBDC -- perfectly standard protocol.bo

If you are running a JAVA or VB script relying on the .NET interface you could be in trouble as this has considerably changed in W7 even from VISTA.

Cheers
jimb
My System SpecsSystem Spec
03 Sep 2010   #8
SlayerZA

Windows 7 Professional x64
 
 

The default 64bit ODBC is not visible to 32bit applications on a x64 Windows.

For 32bit applications running on a 64bit Windows OS, use ODBC located at:
C:\Windows\SysWOW64\odbcad32.exe

You can add a shortcut to it to your Control Panel.

The 64bit & 32bit ODBC apps look exactly the same, but your DSN entries will not show in both, unless you enter them in both.
My System SpecsSystem Spec
03 Sep 2010   #9
jimbo45

Linux CENTOS 7 / various Windows OS'es and servers
 
 

Hi there
I forgot to mention that -- thanks for pointing it out.

Note that the MS office 2010 I've been using is the 32 bit version.

Cheers
jimbo
My System SpecsSystem Spec
Reply

 Win7 x64 / Office 2010 - ODBC connect error




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
not showing office updates thru windows update for office 2010 win7
i remember with windows xp and office, you could go to a different part of the microsoft windows update website in Internet Explorer, and it would prompt you with ActiveX to allow updates for Office, and after you did that then when you went to the normal windows (xp) update site there would be a...
Microsoft Office
ODBC cannot connect to localhost
On a Win7Pro-32 system running in XP mode, I'm trying to use ODBC (v5.1.9) to connect to a MySQL db on localhost. Interestingly, when using a username with remote host privileges I am able to connect to a remote db - this tells me ODBC is installed and working properly. Yet when I try to connect...
Virtualization
Office 2010(Win7, 64bit) won't open Office 2007(WinXPr3 32 bit) files
Just bought a new laptop with Windows7 64bit installed-my first exposure to Windows7. I had Office 2007 installed on my old Dell 32 bit machine. I had also recently pruchased Office 2010 and installed that on my new machine. Now, when I try to open those 32bit 2007 files with 64bt 2011, Iget...
Microsoft Office
Win7 with office 2010
is it possible to make an unattended windows 7 DVD with Office 2010 pro-plus and IE9 integrated??? doubt it cos not microsoft programs but google chrome and dreamweaver CS5 aswell thanks
Installation & Setup
Office 2010 Pro Plus Win7 x 64 Excel reconfigures Office 2010
It seems that there may be a problem in Office 2010. I just installed it to the standard MS default/recommended settings .........all looked good...used Word great..until I use Excel and each time I try to use excel it sets off an 'Office Configuration' screen which I can not stop..it take a few...
Microsoft Office
Office 2010 32bit/x64 like Win7 keys?
Are Office 2010 32bit/x64 like Win7 keys? i.e. Can install either type (32/64bit) with the same rego key?
Microsoft Office


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 22:17.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App