First off I have a 1.7g and 768m machine now running 2000(since last post i formated and reinstalled) and I installed vs.net 2002.
Ok i reinstalled 2000 after that was done I first updated windows and got all the patches. Then I installed all of IIS components. then updated windows again. Then I did the vs.net ent arch install and installed all the components.
Ok now i made a new aps.net file, added a connection to a access db using jet4 and did all the regular stuff and then i keep getting an error saying
The Microsoft Jet database engine cannot open the file 'C:\Inetpub\wwwroot\WebApplication1\test.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
Source Error:
Line 101:
Line 102: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Line 103: OleDbDataAdapter1.Fill(DataSet11)
Line 104:
Line 105: Page.DataBind()
ok so i checked the db and there is no lock file and i dont have access open.
this is the same error i had before, but this time its from a clean install any ideas?
And also, a few people before asked why i did the project with access. I did it with access for a few reasons, first of all i think access is a program everyone has, this way the client can update the db easily. Also i think stored precedures are a pain on the ****. I can switch it to sql, but does 2002 ent arch have sql server with it?
If i goto the server explorer window and click on my machine then it shows sql servers on the bottom. then i click on register sql server instance, it works then i try to add an sql db to it and i get an error :
ADO error: '
[DBNETLIB][ConnectionOpen (Connect()).] SQL server does not exist or access is denied. '
Thanks so much for so much help you guys are the best!Have you checked the file properties of the database to make sure IIS has permissions to read and write to the database?
I gave all the accounts on the machine full access. But thanks alot for trying :) any other ideas?
Theres is a evaluation download of SQL server you can use for 120 days at
http://www.microsoft.com/sql/evaluation/trial/default.asp
or why not use the MSDE, think of it as SQL server for the desktop at
http://www.microsoft.com/sql/msde/
You'll be surprised as to the power of MSDE
0 comments:
Post a Comment