SQLConnection

20 Nov 2005 4:15 PM

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

20 Nov 2005 4:38 PM

Miha Markic [MVP C#]

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

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Show quote

"Maileen" <noemail@nospam.com> wrote in message
news:OaePa2e7FHA.1188@TK2MSFTNGP12.phx.gbl...
> 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

20 Nov 2005 5:03 PM

Cor Ligthert [MVP]

Maileen,

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

Cor

Show quote

"Maileen" <noemail@nospam.com> schreef in bericht
news:OaePa2e7FHA.1188@TK2MSFTNGP12.phx.gbl...
> 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

21 Nov 2005 5:39 PM

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
Show quote

"Maileen" <noemail@nospam.com> wrote in message
news:OaePa2e7FHA.1188@TK2MSFTNGP12.phx.gbl...
> 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