View Single Post
  #1 (permalink)  
Old January 12th, 2006, 04:22 PM
jmss66 jmss66 is offline
Friend of Wrox
Points: 1,035, Level: 12
Points: 1,035, Level: 12 Points: 1,035, Level: 12 Points: 1,035, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: , , USA.
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to jmss66
Default Connection String

I am working on an ACCESS database using the TransferDatabase feature in their MACRO setting and trying to import a table from ORACLE using ODBC connection. I can't seem to get past the "can't find installable ISAM" error message. Can someone please tell me what connection string I can use or to correct this problem? Below is the connection string I am using.

DSN=<DSN_NAME> ;SERVER=<SERVER_NAME>;PWD=<password>;UID=<USERID>; TABLE=<TABLE_NAME>


Thanks