Re: 10g Client and Server and ODBC



In article <1130290667.016751.148520@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
Wotan <wotan_79@xxxxxxxxxxx> wrote:
>We have a VB6 application that connects using ODBC to Oracle database.
>Currently we are using Oracle 8.1.7, with ODBC driver 8.1.7.1.
>
>How backwardly compatible is the ODBC driver supplied with 10g than
>that for 8i? I've looked on the web for the release notes, currently
>out of the office so don't have the disks to hand, so if someone could
>post a link of where to download them from it would be useful.

I have been unable to get Access XP/2003 to connect to an Oracle 10gR1
server using the full client; the 10.1.0.3 Instant Client works fine,
but that's been removed from OTN/Technet and the 10.1.0.4 Instant Client
doesn't have an ODBC component. I haven't tried the 10.2 Instant Client
(company policy is to not use a client of a later release than the server,
which is running 10.1.0.4).

The 9i client worked fine with 9i and 10gR1 servers, except for triggering
a bug in the unpatched 10g server which caused massive database corruption.

Mike Squires
mikes at siralan.org
--

Mike Squires (mikes at cs.indiana.edu) 317 233 9456 (w) 812 333 6564 (h)
mikes at siralan.org 546 N Park Ridge Rd., Bloomington, IN 47408
.



Relevant Pages

  • RE: SQLFetch() very slow with Oracle
    ... Based on my understanding, the problem is when calling the SQLFetchto ... fetch the data from Oracle database, you found Microsoft's ODBC driver is ... so much slower than the Oracle driver to complete the above operation. ... ODBC driver and Oracle driver just as you mentioned. ...
    (microsoft.public.vc.database)
  • Re: Error Message when using ODBC: " Record had too few data field
    ... Whose ODBC driver are you using? ... Did you already have an ODBC DSN defined for Oracle? ... >I am trying to connect to an Oracle database thru Word. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Error ORA-01031
    ... space oracle just provide the instant client dll's. ... I used the native driver "Oracle in InstantClient10_1" and the test ... To leave out sql*plus because of space reasons is just plain stupid. ... The ODBC driver is just an extra redundant layer which slows ...
    (comp.databases.oracle.server)
  • Acess & Oracle Unicode Problem
    ... The solution is to use ODBC driver ... from Oracle and not the microsoft driver for oracle. ... >I am accessing an Oracle database via Acess using an ODBC ... >My query includes other Memo fields but they are ...
    (microsoft.public.access.externaldata)
  • Re: DBD::Oracle 1.19 fails to find Oracle version, problem and solution
    ... I don't understand your response since the problem I am seeing is that sqlplus will NOT run if ORACLE_HOME is defined and it does not seem related to combining libraries into one. ... Just attempted to install DBD::Oracle 1.19 on an Ubuntu Server 7.04 Feisty machine running Perl v5.8.8 (and instant client 10.2.0.3-20061115) and hit a problem with the Makefile.PL not being able to determine my Oracle version. ... WARNING: The tests will probably fail unless you set ORACLE_HOME yourself! ... You may need to set ORACLE_HOME to your Oracle software directory ...
    (perl.dbi.users)