SQLConnection

[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

 

[Miha Markic [MVP C#]]

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

 

[Cor Ligthert [MVP]]

Maileen,

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

Cor

 

[W.G. Ryan - MVP]

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