I've just recently been looking into DNN, and am fairly new to ASP.NET in general.  I've looked through some of the documentation, and the first few chapters in the Professional DotNetNuke 4 book, but I'm getting a little frustrated.  i'm clear on the concept that DNN is built on a database, but not entirely clear on how to connect to another database.

are there any tutorials/articles that walk you thru the process of how and where to update the web.config file and anything else you need to do in order to be able to access data from another database.

e.g., if the company's SQL Server database 'X' is located on server 'Y' then 


  
       
   
 

and can i use the existing SQLDataProvider class?  or do i have to write another DataProvider class specifically to access that db?  and if so where do i place that in the hierarchy?

any help would be appreciated!

You may find some material from Michael Washington to be useful.  Look at his blog on the DotNetNuke site.

You may also find: Module Developer Resources useful

Thanks!  I'll check those out.

I guess I should also have said that you can just build SQL calls into your module code using datareaders, etc.

I think that DotNetNuke also has some SQLHelper (not quite sure about that name but it's close) that will simplify the process. Michael Washington has some nice examples at http://www.dotnetnuke.com/Community...ault.aspx.

You can put connection strings and other data into your web.config file and get at that information using the ASP.NET classes that retrieve information from web.config.