SQLConnection

  • Thread starter Thread starter Maileen
  • Start date Start date
M

Maileen

Hi,

Is the SQLConnection component only for SQL Server (from MS) or can we
use it for MySQL and PostgreSQL too ?

Because when i use the OdbcConnection component, and try to debug my
application, i have a "database connection was disabled" message after a
long timeout...and i do not know what did generate this long time out.

thanks a lot,
Maileen
 
SqlConnection is Sql Server only.
You have to use MySQL custom one (or whatever database) or OleDbConnection
which uses OleDb.
 
Maileen,

I have seen the question from you answered in another newsgroup.

Cor
 
Everythign in SqlClient is only usable with SqlServer. And although you can
use OleDb for Sql Server, I'd shy away from a generic approach and opt for a
provider specific approach for each db I'm interacting with. You can use a
Factory pattern to implement this functionality quite easily.

HTH,

Bill
 
Back
Top