Re: MS_Access ODBC Oracle7???
From: Adam Ahringer <sessec01.AAHRINGE_at_eds.com>
Date: 1995/11/01
Message-ID: <478fmd$pn2_at_maverick.tad.eds.com>#1/1
)
(CONNECT_DATA =
)
)
Date: 1995/11/01
Message-ID: <478fmd$pn2_at_maverick.tad.eds.com>#1/1
If you are using sql*net on the client machine then you do not need to use odbc. Make sure there is an entry in the \orawin\network\admin\tnsnames.ora file for your database. Here is an example:
mydb.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = mymachine) #note - you can put ip address here instead
(Port = 1526)
)
)
(CONNECT_DATA =
(SID = dbname) (GLOBAL_NAME = mydb.world)
)
)
In this case, try using connect string '_at_mydb.world'. The 'T' that you have in your connect string looks like what they used to use in sql*net v1. Hope this helps.