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!