CodeVerge.Net Beta


   Explore    Item Entry    Members      Register  Login  
NEWSGROUP
.NET
Algorithms-Data Structures
Asp.Net
C Plus Plus
CSharp
Database
HTML
Javascript
Linq
Other
Regular Expressions
VB.Net
XML

Free Download:
Zone: > NEWSGROUP > Asp.Net Forum > starter_kits_and_source_projects.dotnetnuke.getting_started Tags:
Item Type: NewsGroup Date Entered: 4/14/2004 10:30:46 AM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 0 Views: 37 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
3 Items, 1 Pages 1 |< << Go >> >|
evelyne
Asp.Net User
Could not connect to database: Access DataProvider4/14/2004 10:30:46 AM

0/0

Hi all,

I'm having problems and don't know how to fix things.
I did a dotnetnuke install at our network. The system administrator set everything up (I don't have these rights) and we went well.
Because I don't want to test within the same environment as people are working, I wanted to setup a second installation of DNN. So I've asked my system administrator to setup directories the same way he did before, but with another name than dotnetnuke.
He created some interesting structure (with other names for the directories then naming the virtual path etc.) but I found out how to make sure DNN is searching for the right location for the database. (DNN is installed within wwwroot\mapname and the dir providers is located at wwwroot\mapname\providers, but within web.config I have to tell DNN to go to \..\mapname\providers\dataproviders\accessprovider\ or something like that, because the virtual directory is set at wwwroot/othermapname which is linked to the directory mapname).

I thought this wouldn't be the problem, but maybe it is.

The error I get is:

The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )

ERROR: Could not connect to database.

Could not find file 'R:\wwwroot\mapname\Providers\DataProviders\AccessDataProvider\DotNetNuke.mdb.resources'.

DNN is searching at the right place, but there isn't a dotnetnuke.mdb.resources yet. Because it's the first time I connect to the site, this file has to be created.
So I thought this could be a permission error. Our system administrator says all the settings are the same for the last installation as this time, so he doesn't believe it's permission.

I thought I could end the discussion by creating the dotnetnuke.mdb by myself, but I don't want to use the dotnetnuke.mdb from the testlocation, because that one is full with information and new modules. Does anyone know what to enter into template.mdb to get it up and running as dotnetnuke.mdb? Do I have to create an extra portal next to the default one or something?

Thanx in advance
yarko
Asp.Net User
Re: Could not connect to database: Access DataProvider4/16/2004 7:40:09 AM

0/0

For Access database, this should be really,really easy - so I suspect you are just doing too much...

All this error is saying is that you are not connecting to the database...

Most people have "trouble" because they want SQL-Server database, and mistakenly (without doing anything) create a DNN using the Access database. That's the default, and it seems to always "just work" (when people forget to change the defaultProvider in their web.config).

If you created a virtual directory, and pointed it to your DNN installation - and if you set permissions on that directory... then you should be up and running...

So - maybe you could be more specific about what you did before getting this error (you mention "within web.config I have to tell DNN to go to..." - you shouldn't need to do anything for using an Access data provider.

Let's find out what you did, maybe then help will come. I'm confident it's something simple.

If you look in your web.config, you will see that the database filename that will be created for an Access instance will be:

databaseFilename = "DotNetNuke.resources"

It is created using "Template.mdb.resources" in your (and you should leave this reference looking like this in your web.config!) ~\Providers\DataProviders\AccessDataProvider\ directory.

I'm wondering why the error mentioned Dotnetnuke.mdb.resources....

You unzipped your DNN distribution in "R:\wwwroot\mapname" ???? Really?
evelyne
Asp.Net User
Re: Could not connect to database: Access DataProvider4/16/2004 7:56:42 AM

0/0

Thanx a lot !

Changing the root to the database back to ~\providers etc. was the missing link.
I changed it the first time, because it wasn't working and I was getting an error about the location. Don't understand why it's working now (have to ask system administrator if he changed anything yesterday when I wasn't here), but it works!

The error is mentioning dotnetnuke.mdb.resources and that was correct, it's also the databasefilename within web.config Didn't change anything about that. The template file is also called template.mdb.resources

At least, within the version I'm using (2.0.3)
3 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
Beginning ASP.NET 3.5 in C# 2008: From Novice to Professional Authors: Matthew MacDonald, Pages: 954, Published: 2007
Beginning Visual Basic 2005 Databases Authors: Thearon Willis, Pages: 736, Published: 2006
Beginning ASP.NET 2.0 in VB 2005: From Novice to Professional Authors: Matthew MacDonald, Pages: 1063, Published: 2006
Beginning ASP.NET 3.5 in VB 9.0: From Novice to Professional Authors: Matthew MacDonald, Pages: 1149, Published: 2007
Pro ADO.NET 2.0 Authors: Sahil Malik, Pages: 561, Published: 2005
Pro Visual Studio .NET: From Professional to Expert Authors: Bill Sempf, James Greenwood, Rob Harrop, Brian Bischof, Colt Kwong, Donald Xie, Kunal Cheda, Jon Reid, Jan Machacek, Pages: 571, Published: 2004
Professional ADO.NET 2: Programming with SQL Server 2005, Oracle, and MySQL Authors: Wallace B. McClure, Gregory A. Beamer, John J. Croft, John J. Croft, IV, J. Ambrose Little, Bill Ryan, Phil Winstanley, David Yack, Jeremy Zongker, Pages: 614, Published: 2005
SQL All-in-One Desk Reference For Dummies Authors: Allen G. Taylor, Pages: 684, Published: 2007
Beginning ASP.NET Databases Using VB.NET: Written and Tested for Final Release of .NET V.1.0 Authors: John Kauffman, Fabio Claudio Ferracchiati, Brian Matsik, Jesudas Chinnathampi, Eric N. Mintz, Jan D. Narkiewicz, Kent Tegels, Donald Xie, John M. West, James Greenwood, Pages: 480, Published: 2003

Web:
Access "Data provider could not be initialized" : could, provider ... This person could connect succesfully in the past. I am hoping for access/SQL programmers this is easy. ... Keywords: Access "Data provider could not be in. ...
ASPRunner Professional manual - Error: Data provider could not be ... Error: Data provider could not be initialized, Home ... Connecting to MS Access database ... I cannot connect to my Excel (Access) database ...
ADE: data provider could not be initialized ADE: data provider could not be initialized - Microsoft Access ADP SQL Server. ... Help needed to connect ADE. There are several posts directly addressing ...
data provider identified by guid ... could not be loaded - MSDN Forums data provider identified by guid ... could not be loaded ... in the server explorer, it will connect to file and manage the database without any problems. ...
TheMSsForum.com >> Ado >> ADO.NET: .Net SqlClient Data Provider ... How do I use database Transaction with tableadapter Ken Tag: ADO.NET: .Net SqlClient Data Provider Could not find stored proce Tag: 118990 ...
ERROR: Could not connect to database. ERROR: Could not connect to database. The type initializer for 'DotNetNuke.Data. DataProvider' threw an exception. ...
README For Sample ASP OAI 2.0 Data Provider for Database 1.5 (We provide an example Microsoft Access Database). We do not make assumptions ... Server database or other ODBC-compliant data source could be used as well. ...
Oracle Data Provider For .NET 11 g NET offers the best performance and greatest access to Oracle database ... instead and those literal values changed, the parsed information could not be ...
ADO.NET Data Provider for DB2 DataDirect Connect for ADO.NET offers IBM DB2 database developers and application ... All other options, including the DB2 data provider, do not employ 100% ...
DB Access using .NET Data Providers Use of an Access database for a middle-tier application is not recommended. ODBC .NET Data Provider. Found in the Microsoft.Data.Odbc namespace. The ODBC . ...




Search This Site:










microsoft visual web developer 2005 express edition starter kit inbuilt errors asp.net 2

sum decimal and null values

designing an attractive background

turn off error logging

image shows in the interal browser but not in external ie

asp.net olap data grid connection

shared user controls in 2.0?

3.0.21: site log -> user registrations by country/date - not working?

getting the resources of an asp.net app

page load process

dnn 3.0.13 install help needed - clean install

open source

dividebyzeroexception error in datacolumn expression

amending the web.config file

populating repeater control with 2 dynamic values related to each other

duh question. how do i retrieve an ntext full-text using query analyzer?

locked out of own website

just getting started

trouble creating new user with sql 2005

solution explorer - how to view solution file name

registertagprefixes and imports

changing profile data on a different user

visual class designer

host pwd issues

using asp.net to copy files

master page and default button problem

wdp no more in beta ?

quick q, can you use asp in an asp.net project?

hosting free for commerce starter kit

masterpage and user control error
 
All Times Are GMT