PDA

View Full Version : ODBC Driver

Pedro Lopes
05-24-2005, 12:43 PM
Hi,
Which driver should I use for a C++ Aplication connecting to Oracle
database ? Microsoft ODBC from Oracle or Oracle ODBC driver ?

Any diferences in performance ?

thanks,
Pedro
DA Morgan
05-24-2005, 01:56 PM
Pedro Lopes wrote: Hi, Which driver should I use for a C++ Aplication connecting to Oracle database ? Microsoft ODBC from Oracle or Oracle ODBC driver ? Any diferences in performance ? thanks, Pedro

And the Oracle version is?
And the operating system is?
You write C++ and don't know these matter?

Always the Oracle drive unless it has a specific issue.
And then I'd head toward lots of other drivers before I'd
risk my application to Microsoft.

But why ODBC when you could have far better performance with
OCI?
--
Daniel A. Morgan
Relational theory is not something that is simply a nice-to-have.
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)
Pedro Lopes
05-25-2005, 12:08 AM
Sorry for the missing details...

DA Morgan wrote: Pedro Lopes wrote: Hi, Which driver should I use for a C++ Aplication connecting to Oracle database ? Microsoft ODBC from Oracle or Oracle ODBC driver ? Any diferences in performance ? thanks, Pedro And the Oracle version is?
9.2.0.1 And the operating system is?
windows2000 You write C++ and don't know these matter?
not my aplication Always the Oracle drive unless it has a specific issue. And then I'd head toward lots of other drivers before I'd risk my application to Microsoft. But why ODBC when you could have far better performance with OCI?
as far as I understand the application runs against other databases too,
OCI might not be a solution (I'll check it). But changing the driver to
OCI will make inevitable to change application code...

thanks,
Pedro
Pedro Lopes
06-02-2005, 01:58 PM
Just to let you know..
after changing the driver from MSFT for the Oracle one..

I got the results of one query in 1minute opposed to 6 minutes using
MSFT driver.

pedro



Pedro Lopes wrote: Hi, Which driver should I use for a C++ Aplication connecting to Oracle database ? Microsoft ODBC from Oracle or Oracle ODBC driver ? Any diferences in performance ? thanks, Pedro

MyLounge.com Site Map
Forum: Cars, Cell Phone, Database, Games, Home Improvement, IT, Music, School, Sports, Web Design, Web Server, Weight Loss

The MyLounge.com forum is intended for informational use only and should not be relied upon and is not a substitute for any advice. The information contained on MyLounge.com are opinions and suggestions of members and is not a representation of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for the accuracy, completeness or usefulness of any postings or the qualifications of any person responding. Please consult a expert or seek the services of an attorney in your area for more accuracy on your specific situation. Please note that our forums also serve as mirrors to Usenet newsgroups. Many posts you see on our forums are made by newsgroup users who may not be members of MyLounge.com Term of Service