[AccessD] Error Message while Connecting Access to Oracle

Rocky Smolin rockysmolin at bchacc.com
Thu Apr 23 15:56:32 CDT 2009


Thanks Liz.  I'm going to recommend that they export from my app to a csv
file and import into their Oracle app that way.  Much easier.

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of lizd1 at charter.net
Sent: Thursday, April 23, 2009 1:47 PM
To: accessd at databaseadvisors.com
Cc: accessd-request at databaseadvisors.com
Subject: Re: [AccessD] Error Message while Connecting Access to Oracle

I connect an Access front end via ODBC to Oracle painfully and infrequently
to validate a few tables.  I can only get connected if the dsn is physically
located in the same folder as tnsnames.ora.  And I must recreate it each
time.  

I learned this much by dreary trial and error; I wish I knew more!

Thanks,

Liz
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list