Re: From Oracle to ODBC

The tnsnames.ora file will not be usable for an ODBC connection...they are 2 entirely different creatures....tnsnames.ora is for Oracle SqlNet connection info only...

you can use an ODBC datasource from Oracle ( in forms, reports, etc ) by using the @ODBC:'odbcdrivername' format -
for instance I have an ODBC connection to a SqlServer data warehouse identified in my ODBC setup as IA_Warehouse, so I can connect to it in Oracle by using

myname/mypass_at_ODBC:IA_Warehouse

Tapan Trivedi <tapan.trivedi_at_abbnm.com> wrote:

>Hey Gurus,
> I am reposting this as I got no responses earlier. What do I put in the
> tnsnames.ora to tell Oracle that it needs to connect to an ODBC data
>source. For example I have an ODBC data source pulling data from
> a Sybase or Access database. I do not really care about the specific
>database . What I need is the way to tell Oracle how to
> recognize any ODBC connection ?
>
>
> Thanks in advance.
> Tapan H Trivedi

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Tue Aug 03 1999 - 08:59:20 CDT