Re: ODBC

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

  • (Fwd) Re: Cross-version DBD Oracle Connectivity for local SYSDBA connection
    ... Subject: Re: Cross-version DBD Oracle Connectivity for local SYSDBA connection ... I am working on Perl application that needs to be able to work with multiple versions of Oracle ... would end up with the segmentation core dump, when trying to connect to 10g database (with the ...
    (perl.dbi.users)
  • Secure connections to oracle
    ... Developing application to talk with Oracle 10g database from Windows platform. ... Connectivity will be used by application to connect to the Oracle DB ... Is the ODP .NET connection encrypted? ... User credentials will have to be 'hard-coded', which means that someone with access to the scripts will be able to extract the UserID/Password to connect to the database. ...
    (Security-Basics)
  • Re: Camping or Merb
    ... and has heavy persistent database connectivity. ... anyway i would recommend nginx as load balancer and for serving static files and flv's, evented mongrel for backend, merb for backend, erubis for templates, and sequel fro postgresql database - supports connection pooling and persistent connections. ...
    (comp.lang.ruby)
  • Re: idiot database flamewars
    ... > I have manged to get connectivity at leased I think I do. ... next section lists ... The database will ask for a password but so will ... >>It's more of a Wine question than anything else, ...
    (Fedora)
  • Exception in creating InitialContext.
    ... here is a class to make connectivity with Derby database. ... public static boolean validate ...
    (comp.lang.java.programmer)