RE: SQLFetch() very slow with Oracle



Hi,

Based on my understanding, the problem is when calling the SQLFetch() to
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.
Please let me know if I have misunderstood it.

Before digging into the problem, I think we had better collect some related
information about this problem first, such as the version of the Oracle
database, which VC product you developed with, what's the code snippet you
used, and some detail statistics of the performance difference between our
ODBC driver and Oracle driver just as you mentioned.

With those detailed info, we could request our corresponding product team
to perform further research on this issue.

If you have any more concerns on it, please feel free to post here.


Thanks for your understanding!

Best regards,

Gary Chang
Microsoft Community Support
--------------------
Get Secure! ¡§C www.microsoft.com/security
Register to Access MSDN Managed Newsgroups!
http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp
&SD=msdn

This posting is provided "AS IS" with no warranties, and confers no rights.

.



Relevant Pages

  • Re: Need help with Access 97 and Oracle 9i
    ... I'm trying to make the connection on the my local machine. ... discussed using ODBC driver to connect to Oracle. ... I found that the Microsoft ODBC Driver doesn't ... I'm looking for anything I can get; suggestions, recommendations, ...
    (microsoft.public.access.externaldata)
  • 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: ORACLE DRIVER
    ... The thing is that I'm using in a Linux machine. ... So is there any free Oracle ODBC driver for Linux? ... UnixODBC is a freeware but couldn't find any free Oracle Drivers. ...
    (perl.dbi.users)
  • Re: 10g Client and Server and ODBC
    ... >We have a VB6 application that connects using ODBC to Oracle database. ... >How backwardly compatible is the ODBC driver supplied with 10g than ... but that's been removed from OTN/Technet and the 10.1.0.4 Instant Client ...
    (comp.databases.oracle.misc)
  • Oracle 10.2 ODBC driver: SQLDescribeCol returns too small a precision for numeric expressions
    ... I hope this is the correct newsgroup to ask about the Oracle ODBC driver ... I allocate a buffer of size Scale+Prec+2 bytes and call SQLBindCol ... the computed expression has up to 16 digits ...
    (comp.databases.oracle.server)