Re: ODBC or OLE DB

Hi,

Thanks for the reply, but do you know if there is a document where they
compare response times etc?

Regards

Chris

"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@xxxxxxxxxxxxxxxxxx> wrote in
message news:O2O9Vss2GHA.1304@xxxxxxxxxxxxxxxxxxxxxxx
As long as you can find providers for each database, OLEDB is faster than
ODBC. ODBC has more options, but I believe you can find providers for all
of the databases you have listed (have not tried Ingres personally; there
is an open source driver for MySql, however).

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think outside of the box!
*************************************************
"Chris" <chrisxxxNO_SPAM@xxxxxxxxx> wrote in message
news:450df606$0$7315$5a62ac22@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

What should I choose ODBC or OLE DB?
I need to connect to Oracle, SQLServer, Ingres and maybe MySQL.
I am not using stored procedures.

I cannot find any microsoft recomendations on there MSDN site.

Can anyone point me to some documents that have the benifits of one over
the other. i.e Performance Issues....

Thanks

Chris





.

Relevant Pages

  • RE: ODBC logging via ISS Internet Scanner
    ... Here is a synopsis of the situation: I want ISS ... I have a ODBC connection to this MySQL ... > Check out Yahoo! ...
    (Security-Basics)
  • Re: Native ODBC access for python on linux?
    ... Can you tell me what I have to use in order to utilize the MySQL native ... > ODBC is a vanilla interface that puts a layer between the program ... The native API can provide access to all ... >> I'm getting my feet wet with making Python talk to MySQL via ODBC. ...
    (comp.lang.python)
  • MySQL/OpenOffice/ODBC
    ... MySQL-Version MySQL 4.1.16-standard-log ... GTK-based ODBC configuration library ii libmyodbc 3.51.11-5 the ... 4.1.15-1 mysql database client library ii libmysqlclient 5.0.18-7 ...
    (de.comp.os.unix.linux.misc)
  • =?iso-8859-1?q?A97_DB_mit_MySQL_Backend...Verbindung_bricht_st=E4ndig_ab?=
    ... Als Access Version hab ich hier Access 97 SR2 und den ODBC Connection ... Ich hab die Tabelle in die MySQL DB ... dieses Formular ein bissel crapy programmiert ist, ...
    (microsoft.public.de.access)
  • Re: OpenOffice database
    ... I downloaded the java and odbc connectors from mysql, ... today but I will try to find the time to create a MySQL database and access ...
    (alt.os.linux.suse)