I am building a web part that has a connection to a database to pull data (diffrent database than the default database for Sharepoint use).
Trying to go the route of using Son of SmartPart, creating a user control and placing it as a web part in Sharepoint. Son of SmartPart works fine, I can create simple user controls, place it in the user control directory for sharepoint and can load them on the page.
Now when I create a user control that hits the database to retrieve data and follow the same steps, I get the error message that the 'Could Not Load abc.ascx' in the drop down box to select the user control. The user control does work when added to a regular page and I am developing on the same box that Sharepoint is installed.
The obvious thing that comes to mind is that it is having problem with the database connection within the control. Any ideas as to what the problem is or if I am skipping a step?
Trying to go the route of using Son of SmartPart, creating a user control and placing it as a web part in Sharepoint. Son of SmartPart works fine, I can create simple user controls, place it in the user control directory for sharepoint and can load them on the page.
Now when I create a user control that hits the database to retrieve data and follow the same steps, I get the error message that the 'Could Not Load abc.ascx' in the drop down box to select the user control. The user control does work when added to a regular page and I am developing on the same box that Sharepoint is installed.
The obvious thing that comes to mind is that it is having problem with the database connection within the control. Any ideas as to what the problem is or if I am skipping a step?