p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Oracle (http://p2p.wrox.com/forumdisplay.php?f=105)
-   -   Connection String (http://p2p.wrox.com/showthread.php?t=37140)

jmss66 January 12th, 2006 04:22 PM

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



nalla February 21st, 2006 12:54 AM


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

aclausen April 16th, 2006 10:28 PM

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

information officer June 19th, 2006 08:54 AM

i found a grt web site for connection string

www.connstr.com

Regards
Humair
www.connstr.com


sachin.tathod August 8th, 2006 03:19 AM

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


All times are GMT -4. The time now is 07:56 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.