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

I'm not much familiar with TransferDatabase feature and MACRO settings but I remember some time back I got the same error and it was something wrong with Access. So I think you got this error because something wrong with your access not oracle. Unfortunately I can't remember the how I solved it.


nalaka hewage

If you want to import tables from an oracle database the it is much easier to use access to pull down the table.

Go to tables
new
import table
select ODBC as table type and log on to the oracle database

Highlight the tables you want.
That's all.

Alfred

i found a grt web site for connection string

www.connstr.com

Regards
Humair
www.connstr.com

Put following entires in tnsnames.ora and u can access using txn by PL SQL Developer

txn =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.34.170)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = txn)
    )
  )



Thanks and Regards,
SACHIN S.TATHOD
Patni Computer System Ltd.
Magarpatta City, Cyber City,
Tower 3,Level I & II,
Hadapsar,Pune - 411028
Mobile No:- +91-9881239401
Email ID:- sachin.tathod@patni.com