Re: Why "microsoft odbc for oracle" not work?

"jingwen" <liufy1065@xxxxxxxx> wrote in message
news:el5q1i$nkc$1@xxxxxxxxxxxxxxxx
When I connect Oracle using "Microsoft ODBC for Oracle" Driver
in VFP9, it
always popup a message "Connectivity error: [Microsoft][ODBC
Driver Manager]
Driver's SQLSetConnectAttr failed.".

I don't know, but the MS driver for Oracle is ancient; Oracle 7
at best.


When I use "ORACLE ODBC Driver" which provided by Oracle
instead, it works
well.

As it should. Use the Oracle ODBC driver. The client driver is
free.

- Arnie


Why? It's annoying me so much!!

THX A LOT!

-Jingwen





.

Relevant Pages

  • RE: ORACLE DRIVER
    ... DBI - is the perl module to handle all the request of the database, connecting, disconnecting, routing the database request to proper driver. ... DBD::Oracle - is the Oracle driver that DBI can use to handle oracle request. ...
    (perl.dbi.users)
  • RE: ORACLE DRIVER
    ... Subject: ORACLE DRIVER ... DBI - is the perl module to handle all the request of the database, ... So is there any free Oracle ODBC driver for Linux? ...
    (perl.dbi.users)
  • Re: Microfocus Netexpress question : COBSQL vs openESQL
    ... >couldnt connect with the oracle database specified in the program. ... It may be missing an ODBC driver and/or data source. ... You also need an entry for the data source in tnsnames.ora. ... precompiler directives to the precompiler and compiler directives to ...
    (comp.lang.cobol)
  • Re: DTS for Oracle through ODBC: Error Calling GetNextRows in Prev
    ... I found out the Oracle driver they had installed on my system was for Oracle ... installer app in order to install their ODBC's.. ... I decided to use the Oracle ODBC provided in their client install. ...
    (microsoft.public.sqlserver.dts)
  • Re: Import from Oracle - ODBC basics
    ... equivalent create a Local Net Service Name Configuration to the Oracle ... add a System DSN using the "Oracle ODBC Driver" (MUST be this ... A FULL installation of Oracle was required on the computer in order for ... the "Oracle ODBC Driver" to be available. ...
    (comp.databases.filemaker)