PC Review


Reply
Thread Tools Rate Thread

On 64bit MS2003 server we cannot get MS-Office to conn with ODBC

 
 
Philip
Guest
Posts: n/a
 
      13th Feb 2009
We're running a win server std 2003 64bit.
Trying to connect Access 2007 via ODBC to oracle DB.

From "MS ODBC Administrator" we can test connect to the remote oracle DB
From Oracle SQL-net we can connect to the remote oracle DB

So Oracle tnsnames ... are functional and working.
But when we try to setup a ODBC link from MS-Access & Excel connection
fails with
"Drivers SQLsetconnectAttr failed"

On the net there's numerous people with the same problem but there's no
resolution or work around.

Closest:
The 32-bit version of the Odbcad32.exe file is located in the
%systemdrive%\Windows\SysWoW64 folder.
The 64-bit version of the Odbcad32.exe file is located in the
%systemdrive%\Windows\System32 folder.

But how do I get Office to use the 64-bit version of the Odbcad32.exe file
located in the %systemdrive%\Windows\System32 folder?

I need urgent help here please?
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conn.Close & Conn.Dispose Simon Harris Microsoft ASP .NET 6 1st Jun 2005 02:01 PM
Bulletts in MS2003 =?Utf-8?B?VmFs?= Microsoft Powerpoint 1 24th Mar 2005 12:06 AM
Conn.Close() and Login Error w/Subsequent Conn.Open() Christopher Walls Microsoft ADO .NET 0 4th May 2004 05:37 PM
Re: 64bit binaries could'nt run on 64bit AMD with Windows XP 64bit Edition Mike Brannigan [MSFT] Windows XP General 4 12th Mar 2004 05:27 PM
Re: 64bit binaries could'nt run on 64bit AMD with Windows XP 64bit Edition Alex Nichol Windows XP General 0 10th Mar 2004 01:11 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:56 PM.