Re: ODBC

I'd use their SQL driver. ODBC is slower than an afternoon with the IRS.

Robin S.
---------------------------
"Dennis" <Dennis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:728ABF5E-5526-481B-AB8B-F73362A1F34D@xxxxxxxxxxxxxxxx
I am trying to use "MySQL" and I have a choice, I think, of using their
SQL
driver or OBDC driver with VB.Net. Which do you think would be faster
and
the better choice?
--
Dennis in Houston


"tomb" wrote:

My preference has always been to get the database vendor to provide
the
connectivity to use with .Net. I've done that with Oracle and it
worked
SO MUCH BETTER than the MS version.

Tom

marcmc wrote:

Hey,

What do people/gurus think of ODBC connections to databases?
The beauty of .net is it allows the database to only be connected to
for the
length of time you need it. This is great for classes like SQLClient
and
OLEDB.
However, I'm quite worried that my use of Microsoft.Data.odbc.dll to
connect
to Teradata will impose application performance issues(it takes 20
seconds)
by constantly connecting/disconnecting/connecting again etc.

Does anyone know for sure that the .NET Provider for Teradata is
only
compatible with VS 2005?







.

Relevant Pages

  • Re: SSIS package Informix to SS 2005
    ... I am using Avaya Openlink driver 4.2 and after much trial and error I have ... picking data from ODBC and pushing it to SS 2005 Database through SSIS ... Multi-tier ODBC Driver forInformix. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Problem with perl DBI ODBC driver (bug or misconfig ?) [String data right truncation]
    ... Therefore there is no problem at source or at ODBC level, ... but it is a bug in IBM iSeries driver. ... database in UTF-8. ... Denis had UTF-8 set and his data contained some ...
    (perl.dbi.users)
  • Microsoft ODBC for Oracle Driver problem
    ... I think I have a resource issue with this driver. ... we are having an issue where suddenly the ODBC ... customer on that hosted machine. ... Microsoft ODBC Driver for Oracle. ...
    (microsoft.public.data.odbc)
  • Re: Excel cant find FileMaker Pro Files
    ... Excel) as a front end to other databases via ODBC. ... product for using FMP as a data source, mainly because FileMaker Inc ... makes their own driver available for free. ... DSN parameter values, since the driver doesn't include a DSN setup ...
    (microsoft.public.mac.office.excel)
  • Re: ODBC - SQL Server image data problems with recent releases of ODBC
    ... there are two problems with build 824 with an upgraded ODBC ... The following code is a workaround for a problem in SQL Server ... The older SQL Server driver: ...
    (perl.dbi.users)