Re: ODBC setup

Turkbear wrote:
> "Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote:
>
> >
> >Turkbear wrote:
> >> "Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote:
> >>
> >> >
> >> >tunity5_at_yahoo.com wrote:
> >> >> Does ODBC have its own protocol to connect to an (Oracle)
> >database?
> >> >Or
> >> >> does it use Oracle's own protocols (such as SQL*Net) to
establish
> >a
> >> >> connection to the database? Database is 9i hosted on an HP
> >server,
> >> >and
> >> >> ODBC is to be from a Windows XP PC.
> >> >>
> >> >>
> >> >> Thanks!
> >> >
> >> >Both MS and Oracle ODBC drivers need Oracle middleware
> >> >(SQL*Net/Net8/Net9 etc). Not sure about any other vendors but I
will
> >be
> >> >surprised if they don't need it. Oracle middleware is installed
by
> >> >default with both client and server install.
> >> >
> >> >Regards
> >> >/Rauf
> >>
> >> There are some ODBC drivers that are direct connect ( called wire
> >protocol) that do not need the Oracle client ( SqlNet)
> >> installed-- they connect directly through the Listener ( like a
Java
> >Thin connection ) by specifying the host:port:instance
> >> in the config file.
> >>
> >> One company's versions are here:
> >>
> >> http://www.datadirect.com/products/odbc/index.ssp
> >>
> >> ( Not meant as an endorsement and there may be others)
> >
> >Have you used this product?
> >I just downloaded the eval copy of Data direct and installed just
the
> >Oracle wire protocol driver. To test a clientless connection, I
> >temporarily renamed my Oracle home. When testing the connection
during
> >the DSN setup, it worked Ok with "Connection successfull" message so
I
> >was impressed. BUT when trying to link a test table from Access, it
> >kept throwing (-7748) error. No issues when I recreated the DSN
using
> >Oracle ODBC driver.
> >
> >Unless I am doing something wrong... I am back to being unimpressed
> >:->)
> >
> >Regards
> >/Rauf
> We use these drivers in our RedHat system ( no Oracle client) for
most of our ETL jobs..No problems.
>
> When in a Windows environment, I have found that only MS's Oracle
ODBC is totally reliable when connecting through a MS
> product like Access..I've had odd failures even with Oracle's ODBC
driver and Access.

But have you used the DD wire protocol driver successfully on Win*?

Regards
/Rauf Received on Thu Feb 10 2005 - 04:02:43 CST