DotNetNuke 2.0 Database question

Hi all,
I did a fresh install of DNN 2.0. I did configure my database with my login and password correctly in web.config file. I use my local SQL server so I tried (server=localhost and even tried server=my server name). I created a database and a login before I launch the portal as in the installation documentation. HOwever, I never see any tables or stored procedures in my database. My portal works fine. I can register many users, set roles, add modules, etc. It does everything it supposes to do. The weird thing is I don't know where my database goes? Does anyone have any hint?

Thanks a lot in advance.

Tram

tram doan

 

I was wondering the same thing. All I did was copy DNN to a subdirectory on my DiscountASP site and use the application tool to have the subdirectory recognize the directory and then I was going to search for documentation on how to set up the database I tried the site for kicks. It worked without me having to set anything up. I am wondering where it stores the database stuff as well...

A pleasant surprise but a surprise nonetheless...

Anyone shed any light on why it worked?

 

Greetings ...

I'm running DNN 2.0.3 using MS Access here at DASP - www.webspaceunit.com

Feedback and Documents not working. DNN email is working for registration - smtp set up on DNN. I can see my uploaded files under /portal but not with browser.

Curious, are you guys running with the MS Frontpage stuff enabled via the control panel?

Also, are you guys uploading using MS Frontpage or a FTP utility?

I normally use MS FP 2003.

Roy
www.haygood.com
www.webspaceunit.com

 

Greetings Bruce ...

Fixed feedback/email issue by changing smpt in host setup area.

Regarding documents module - I am able to upload using DDN and confirm w/ FP that files are in /portal directory, but not seeing files with browser. No error messages present.

Roy
www.webspaceunit.com


quote:Originally posted by bruce

What error did you get?

I suggest you do not use FP unless you intend to edit the site using VS.net


quote:Originally posted by haygoodcom0

Greetings ...

I'm running DNN 2.0.3 using MS Access here at DASP - www.webspaceunit.com

Feedback and Documents not working. DNN email is working for registration - smtp set up on DNN. I can see my uploaded files under /portal but not with browser.

Curious, are you guys running with the MS Frontpage stuff enabled via the control panel?

Also, are you guys uploading using MS Frontpage or a FTP utility?

I normally use MS FP 2003.

Roy
www.haygood.com
www.webspaceunit.com
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">

 

Tram:

This may be a silly question but since DNN 2.03 allows for using different database providers and the Web.Config comes configured to use the Access table provided in the install, did you change the line just above where you put in your local SQL Server configuration data that reads:

<data defaultProvider="AccessDataProvider"> to read

<data defaultProvider="SQLDataProvider">

If not then all your configuration data and any setup you may already have done is all stored in the Access table DotNetNuke.mdb.resources in the directory <dotnetnuke>\Providers\DataProviders\AccessDataProvider

Hope that helps! I'm deploying my first large scale project using DotNetNuke as the base and my client loves it!

Brad Weaver
ComputerAid International

 

Brad,

Are you using FP and Copy Project to upload your site (if not - how did you do it?) I have a local version of DNN working just fine. I updated it to discountAsp.net but I am getting a variety of errors. Here are some questions:

1. I am using Access. Do I put the database into the _Database folder (and then modify the web.config file to point there)?

2. I added my url to the DotNetNuke_Portals table in the database (localhost/DotNetNuke,www.WEBurrows.com/Programming). Did you do that too?

TIA ... bill burrows


quote:Originally posted by compuaid

Tram:

This may be a silly question but since DNN 2.03 allows for using different database providers and the Web.Config comes configured to use the Access table provided in the install, did you change the line just above where you put in your local SQL Server configuration data that reads:

<data defaultProvider="AccessDataProvider"> to read

<data defaultProvider="SQLDataProvider">

If not then all your configuration data and any setup you may already have done is all stored in the Access table DotNetNuke.mdb.resources in the directory <dotnetnuke>\Providers\DataProviders\AccessDataProvider

Hope that helps! I'm deploying my first large scale project using DotNetNuke as the base and my client loves it!

Brad Weaver
ComputerAid International
</blockquote id="quote"></font id="quote">

Bill Burrows
MS MVP Academic

 

I appologize for this late posting.
Beware that you may have the Default Connection set to Access instead of SQL server in the Web Config. For version 2.0 you need to edit the <Data> elements also besides the <add key="connectionString"> element .
Not doing this installs and runs on an access db. Your site will work this way also.
Knowlege base document Q10202: HOWTO: How do I install DotNetNuke on your server, does not reflect the 2.0 change


quote:Originally posted by tramdoan

Hi all,
I did a fresh install of DNN 2.0. I did configure my database with my login and password correctly in web.config file. I use my local SQL server so I tried (server=localhost and even tried server=my server name). I created a database and a login before I launch the portal as in the installation documentation. HOwever, I never see any tables or stored procedures in my database. My portal works fine. I can register many users, set roles, add modules, etc. It does everything it supposes to do. The weird thing is I don't know where my database goes? Does anyone have any hint?

Thanks a lot in advance.

Tram

tram doan
</blockquote id="quote"></font id="quote">