Connecting Tech Pros Worldwide Help | Site Map

Linking to Oracle data using ODBC

  #1  
Old July 25th, 2008, 04:00 PM
Newbie
 
Join Date: Jul 2008
Posts: 1
Using ODBC datasource administrator tool in WIndows XP SP2, I create Oracle Data Source and tested the Connection. The connection was successful. However, When I tried to link to the oracle database from Access, I keep getting an error message that says "Driver's SQLNetConectAttr failed". Help
  #2  
Old July 29th, 2008, 02:13 AM
Zwoker's Avatar
Member
 
Join Date: Jul 2007
Location: Melbourne, Australia
Posts: 66

re: Linking to Oracle data using ODBC


Hi,

A quick question on this:

Which version of Oracle are you using, and do you have the latest ODBC drivers for it?

I found something similar happened to me a while ago, and upgrading to the latest ODBC drivers from Oracle for my version fixed it.

Regards,
Zwoker.
Reply


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking MS Access to Oracle MeeMee answers 0 September 1st, 2008 07:23 AM
Linking to tables in Firebird or other db Jennifer Carr answers 10 December 25th, 2005 05:25 AM
#Deleted displaying for ODBC linked tables Joe answers 7 November 13th, 2005 06:14 AM
Linking Oracle tables to Access 2K Phil S answers 2 November 12th, 2005 04:30 PM