Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2005
    Posts
    1

    Exclamation Unanswered: SQL with parameters on Oracle using MS ODBC driver

    I, and it would appear many others on other newsgroups, have found that parameterised sql statements do not work when using Microsofts ODBC drivers but does work when usings Oracles ODBC driver.

    I am using Delphi 5 and BDE 5.2, Oracle 9.1i, MDAC 2.8

    My client insists on keeping to MS. Has anyone seen any authorative statement listing this as a problem, or other good reason to use Oracles driver?

    Many Thanks

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    Weve also had various issues in terms of reliability and performance with the MS drivers so we moved to the Oracle ones. I dont think MS really pay much attention to their Oracle drivers, after all if they ran really well people might start moving from Sqlserver to Oracle.

    Alan

  3. #3
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    If Microsoft's driver does not allow for the use of bind variables, then definitely use Oracle's driver. Bind variables are very very very important : if you don't use bind variables and the values of your parameters change often, Oracle will hard-parse almost every query, which is a performance killer. For more details on the need for bind variables, you can check Tom Kyte's site here and search for "bind variables" (keep the double-quotes).

    Regards,

    RBARAER

  4. #4
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    I have had no problems using either Delphi and VB with Microsoft's Drivers, maybe there is something else we should look at ?

    .. What I will agree with you is that in the rare case of Delphi ( VB no problems ), I have seen statements which binds too many inputs, and you end up having 1 * X statements cached, instead of one, depending on the type of input.

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Knowing Microsoft’s mindset, I wouldn't be surprised if Microsoft’s oracle ODBC drivers are deliberately slow and limited. After all, they don't want you to use oracle, they want you to use sql-server. I never use Microsoft’s ODBC drivers, I always download Oracles. They have always been more solid, fast and reliable.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •