Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Link table from Access to oracle by odbc fails

Link table from Access to oracle by odbc fails

From: Ido <idob_at_yaelsoft.com>
Date: 30 Mar 2003 03:42:35 -0800
Message-ID: <8a6c2f3e.0303300342.aef84c4@posting.google.com>


I try to link table from access to oracle by "odbc for oracle". When I open the access and link the table - i see it well (which means that the ODBC is defined properly).
THE PROBLEM is, when I close and re-open the Access, I get error message trying to open the link-table.

The message is ora-12154 TNS: could not resolve service.

It seems to me that Access fails saving some information about the link during closing due to permissions, but I have no idea what and where!

Thank you. Received on Sun Mar 30 2003 - 05:42:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US