Linked tables via Oracle ODBC on 64 bit machine
Hoffmann@discussions.microsoft.com S Hoffmann
platform. I can setup the 32 bit drivers from syswow64 and connection is
successful but when I try to link the tables I get a ORA-12154 TNS error. I
have other apps that connect to oracle no problems and TNSPING is ok so I'm
fairly sure it's not a TNS issue.
Access 2003
Oracle 10g
Oracle ODBC driver
Can anyone assist before I go back to 32bit!
Alex Dybenko
I don’t have experience with Oracle, but make sure you creating DSN in
32-bit control panel ODBC, Access 2003 can use only that one
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
"S Hoffmann" <S Hoff...@discussions.microsoft.com> wrote in message
news:9AC02A23-6E22-4615...@microsoft.com...
Stefan Hoffmann
nice name, isn't it?
On 27.04.2010 03:10, S Hoffmann wrote:
> I am having trouble linking Access to Oracle tables since moving to a 64 bit
> platform. I can setup the 32 bit drivers from syswow64 and connection is
> successful but when I try to link the tables I get a ORA-12154 TNS error. I
> have other apps that connect to oracle no problems and TNSPING is ok so I'm
> fairly sure it's not a TNS issue.
It is an Oracle TNS resolving error:
http://www.dbmotive.com/oracle_error_codes.php?errcode=12154
Check whether you can run TNSPing as 32-bit executable. I suspect that
you have only setup a working 64-bit connection.
See here for some possible solutions:
mfG
--> stefan <--