|
Subject:
|
Connection String
|
|
Posted By:
|
jmss66
|
Post Date:
|
1/12/2006 3:22:49 PM
|
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
|
|
Reply By:
|
nalla
|
Reply Date:
|
2/20/2006 11:54:32 PM
|
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
|
|
Reply By:
|
aclausen
|
Reply Date:
|
4/16/2006 10:28:19 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
|
|
Reply By:
|
information officer
|
Reply Date:
|
6/19/2006 8:54:31 AM
|
i found a grt web site for connection string
www.connstr.com
Regards
Humair
www.connstr.com
|
|
Reply By:
|
sachin.tathod
|
Reply Date:
|
8/8/2006 3:19:13 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
|
