[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.odbcnet

SQLConnection vs ODBCConnection

Doug J.

11/20/2005 4:15:00 PM

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
2 Answers

Paul Clement

11/21/2005 6:43:00 PM

0

On Sun, 20 Nov 2005 17:15:16 +0100, Maileen <noemail@nospam.com> wrote:

&#164; Hi,
&#164;
&#164; Is the SQLConnection component only for SQL Server (from MS) or can we
&#164; use it for MySQL and PostgreSQL too ?
&#164;

I don''t believe so, no.

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

I don''t know what could be causing this problem. Are you using the correct connection string? What
kind of database are you having trouble with?


Paul
~~~~
Microsoft MVP (Visual Basic)

jt

11/22/2005 7:23:00 AM

0

Maileen wrote:
> 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.
It can happen if you set a breakpoint... and take too much time
analyzing something without querying the database...

>
> thanks a lot,
> Maileen