ODBC Conection on a Winforms UserControl

[Kurt Denhoff]

I have an odbc connection on a Winforms UserControl when used within a
WinForms project it works fine but when I use it on an aspx page the object
doesn't show. The IIS log indicates code 200(successfully loaded). I am
suspecting this may be an issue with being fully trusted dll. I experimented
with the ODBC connection on a Webform control - it worked fine. I put the
ODBC connection on the aspx page - it worked fine. I put the connection on
my composite control (Winforms UserControl) and it doesn't load.

Any ideas?
Thanks,
Kurt Denhoff

[Octavio Hernandez]

Hi,

Maybe your problem is that you're trying to use the OdbcConnection (which
you initialize on the page Load event) in the Load event of the control.
The Load event of the control executes BEFORE the Load event of the page, so
by that time is has not been initialized yet.
Move the code you have on the control Load event to the PreRender event
(which happens later) and everything should work.

Regards - Octavio

"Kurt Denhoff" <Kurt De*****@discussions.microsoft.com> escribió en el
mensaje news:2B**********************************@microsof t.com...

I have an odbc connection on a Winforms UserControl when used within a
WinForms project it works fine but when I use it on an aspx page the
object
doesn't show. The IIS log indicates code 200(successfully loaded). I am
suspecting this may be an issue with being fully trusted dll. I
experimented
with the ODBC connection on a Webform control - it worked fine. I put the
ODBC connection on the aspx page - it worked fine. I put the connection
on
my composite control (Winforms UserControl) and it doesn't load.

Any ideas?
Thanks,
Kurt Denhoff

[Kurt Denhoff]

I ended up making a control as much bear bones as possible. I placed the
control on the page with a connection string and it fails.

"Octavio Hernandez" wrote:

Hi,

Maybe your problem is that you're trying to use the OdbcConnection (which
you initialize on the page Load event) in the Load event of the control.
The Load event of the control executes BEFORE the Load event of the page, so
by that time is has not been initialized yet.
Move the code you have on the control Load event to the PreRender event
(which happens later) and everything should work.

Regards - Octavio

"Kurt Denhoff" <Kurt De*****@discussions.microsoft.com> escribió en el
mensaje news:2B**********************************@microsof t.com...

I have an odbc connection on a Winforms UserControl when used within a
WinForms project it works fine but when I use it on an aspx page the
object
doesn't show. The IIS log indicates code 200(successfully loaded). I am
suspecting this may be an issue with being fully trusted dll. I
experimented
with the ODBC connection on a Webform control - it worked fine. I put the
ODBC connection on the aspx page - it worked fine. I put the connection
on
my composite control (Winforms UserControl) and it doesn't load.

Any ideas?
Thanks,
Kurt Denhoff