|
Scenario:
I've a WebFarm with 2 web servers which are NLBs (network load balanced).
Web1 and Web2; they are not part of a domain.
I have a third server, Server3, which is part of a domain and on the same physical network, and it has an MSAccess database which is used on the external webfarm as well as on the internal intranet. I can connect via the intranet because the DB file is on the same box from which the intranet is being served (Server3)
While I've got code below which is VB.NET-related, to me I think this is an OS-related topic; but I could be wrong..
How can I 'connect' to the MSAccess database file on Server3 from either Web1 or Web2?
When I use the code below, I get this error:
The Microsoft Jet database engine cannot open the file '\\Server3\C$\MSAccessDBs\Database.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
Any clues?
Here's more info:
I'm using ASP.NET v1.1, using a standard OLEDb connection (referencing the database by path [see code below]).
From the ASP.NET v1.1 "web.config" file (I'll refer to this as ConnectStringA)
1 [appSettings]
2 <[dd key="strConnectAccess" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\Server3\MSAccess\DatabaseFile.mdb"/]
3 [/appSettings]
actual "connect" code:
... I'm pausing here.
I went to go look at the connection code and there is a direct inline connection string to another database which ap[ears to not be failing:
\\Server3\C$\MSAccess\LogError.mdb
--> I'll refer to this as ConnectStringB,
The difference between ConnectStringA and ConnectStringB is that ConnectStringA assumes a shared folder, whereas ConnectStringB goes direct, as it includes the "\C$" element.
Well, I added the "\C$" to ConnectStringA, (now "\Server3\C$\MSAccess\DatabaseFile.mdb") and it still fails.
Yes, I would agree there is some sort of permissions error. The database is set for Shared.
Here is my "connect" code (modified to protect a client's database)
1 Sub btnlogin_click(ByVal sender As Object, ByVal e As EventArgs)
2 Dim conpw As OleDb.OleDbConnection
3 Dim cmdpw As OleDb.OleDbCommand
4 Dim strsql As String
5
6 Dim dappw As OleDb.OleDbDataAdapter
7 Dim dstpw As DataSet
8 Dim rowpw As DataRow
9 Dim bldpw As OleDb.OleDbCommandBuilder
10 Dim inti As Integer
11 Dim rdrpw As OleDb.OleDbDataReader
12
13 Dim xx As String
14 Dim yy As String
15 Dim strmsg As String
16 Dim strcounties As String
17 Dim lngposition As Long
18 Dim strIsCSR As String
19
20 If txtIsCSR.Checked = "True" Then
21 Session.Contents("IsUser2") = "True"
22 Session.Contents("userName2") = txtUserName.Value
23 Session.Contents("userPass2") = txtPassword.Value
24 Response.Redirect("user2Logon.aspx")
25 End If
26
27 lngposition = InStr(txtPassword.Value, "'")
28 If lngposition > 0 Then
29 Response.Redirect("loginError.aspx")
30 End If
31
32
33 conpw = New OleDb.OleDbConnection(ConfigurationSettings.AppSettings("strConnectAccess"))
34 conpw.Open()
35
36
37 strsql = "SELECT * " & _
38 "FROM [ User] " & _
39 " WHERE ( ([ User]].UserName = '" & txtUserName.Value & "') AND ([ User].password = '" & txtPassword.Value & "') ) "
40
41 cmdpw = New OleDb.OleDbCommand(strsql, conpw)
42 rdrpw = cmdpw.executereader
43
44 xx = 0
45 While rdrpw.read
46 xx = xx + 1
47 strmsg = rdrpw.item("userID") + rdrpw.item("userName")
48 strcounties = strcounties + strmsg
49 End While
50
51 conpw.close()
52
53 If xx > 0 Then
54 Session.Contents("counties") = txtMemberid.Value
55 Response.Redirect("Here.aspx")
56 Else
57 If Len(Trim(Session.Contents("logintrys"))) = 0 Then
58 Session.Contents("logintrys") = 0
59 End If
60 ctry = (Session.Contents("logintrys"))
61 ltrys = CInt(ctry) + 1
62 If ltrys > 6 Then
63 Response.Redirect("lockout.aspx")
64 End If
65 ctry = CStr(ltrys)
66 Session.Contents("logintrys") = ctry
67 Response.Redirect("loginError.aspx")
68 End If
69
70 End Sub
So, in all, this error [below] is occuring, it does point to "permissions" of some kind, I think. the Database is not set to exclusive. "Everyone" and "guest" have "Read/Write" to all files in folder (yes, a security hole).
The Microsoft Jet database engine cannot open the file '\\Server3\C$\MSAccessDBs\Database.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
FYI ~ I have set all 3 servers up with the same username/password (used by IIS). The user account on Server3 has full control to the folder and file.
I did create a page on Web1 and Web2 that accesses an image in the same directory on Server3 (for display on a web page), and the image displays fine.
I did visit Microsoft's website and read through several KB articles, but no success; #253580, #315276 (NTRights Utlitity)
The NTRights utility (KB #315276) adds permissions from ServerA to access content on ServerB.
Thing is, how to I "connect" from a webfarm not on a domain to a server (Server3) which is on a domain?
ASP ~ Apple Simply Performs
|
|
|
|
|
Check if you have access rights on the table you are trying to view. If the account you log on with the connection string doesn't match the table access rights you may get that message. Thats one possible check. There is also a connection attribute that needs to be assigned for DataReaders to work correctly. Asynchronous Processing=true; I believe Good luck
nothing
|
|
|
|
|
Dear All,
I am making web application using Asp.net C#(Visual Studio2005).
I want to populate web control based on dropdownlistbox value.
I tried this code
Label lbl = new Label();
lbl.Text = "Welcome ";
TextBox txtname = new TextBox();
txtname.Height = 50;
txtname.Width = 20;
PH1.Controls.Add(lbl);
My problem is how can I place this controls to perticular place.
Please Guide me or atleast give some help full link.
thanks
regards
imran khan
|
|
|
|
|
HI
Instead of Adding Directly to page Add Place Holder staticly where you want to show the control then at Run time add the dynamically created control to the place holder Also you have PH1.Controls.AddAt(child control) method
i don't know much about that
<l>Thanks and Regards
Sandeep
|
|
|
|
|
Apply a style and use css to position the control where you want it, either absolute or relative, etc.
only two letters away from being an asset
|
|
|
|
|
i want to create a custom control for my project.
how to do this
can any body help me regarding this
|
|
|
|
|
|
Hi guys,
I'm having a problem with a grid view. It all works great, but i added a set of textboxes that are used to generate a filter string. This filter string works fine, and enables me to sort, edit, delete, etc.
The problem i have now is that when i delete (via delete command) or insert (via a seperate form) an item, the datagrid re-freshes without the filter being applied.
I've tried re-applying the filter string to the ODS, i've also tried re binding the DataGrid. Neither of these has any effect.
Can anyone point me in the direction of a fix?
Cheers
Tris
|
|
|
|
|
Hi,
How do i create a template column containing an image at the end of a datagrid.Thanks in advance...
|
|
|
|
|
Runtime or design time??
[design time]
- Right Click on Datagrid.
- Click "Property Builder"
- Go To "Column"
- Add "Template" Column.
- Click "OK"
- Right Click on datagrid again.
- Select "Edit Template" (you wil see all template columns.)
- Select Last Column. (eg: Column [3])
- Add Image Control in ItemTemplate.
- Click "End Template Editing"
That's all.
[Runtime]
Dim tCol As New TemplateColumn
tCol.ItemTemplate.InstantiateIn(New System.Web.UI.WebControls.Image)
dgOvertimeRate.Columns.Add(tCol)
Try those codes. Hope it works.
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
If you want to thank me for my help, please vote my message. Thank you.
|
|
|
|
|
i want to travel on one website through .net coding.
i.e i have one web project and it contains one web form.
i have one website. in that web site contains search field box. thorugh coding i have to give value for that search filed and trigger the go button.
for example if i want to search the topic "TriggerButton" on google means i have to manually open that site and write TriggerButton in the search field box and click the google search button.
is it possible to do it through .net coding. (give value to that search field box and trgger the click event. )
|
|
|
|
|
|
Hi,
I'm trying to deploy my asp.net web application, but I don't know how can I access the default web page after I install the application on another computer??
Can someone please tell me in details how to depoly my web application and how to use the application after installation.
I'm using Visual Studio.Net 2005, Asp.net 2
I also want to add to the installation file, the .Net framework just in case the other computer doesn't have it??
|
|
|
|
|
Hi,
Just follow below steps:
------------------------
1. New -> File -> New Project
2. Expand Other Project Types (in Project Types Tree)
3. Click Setup and Deployment
4. Select Web Setup Project
5. Enter some file name and save it
6. Right click Web Application Folder (in (File System Tree).
7. Click Add
8. Add all web files (.aspx and .aspx.cs) as much as you wanted.
9. If you want to create new folder under main folder, right click the Web Application Folder -> Add -> New Folder.
To set default .aspx file for your web application
---------------------------------------------------
1. Click properties of Web Application Folder
2. Change the file name in ‘DefaultDocument’
a. Can be default.aspx or index.aspx or anything
3. You can also change the ‘VirtualDirectory’ (so that web application can be accessed as 'http://<servername>/<VirtualDirectory>'
a.Server name – can be localhost or machine name if deployed in some other
machine
b.Virtual Directory (optional) – can be your project name. If it is blank,
then files will be copied in the main directory i.e folder will not be
created.
Once you are done, now rebuild the solution. This will create .msi file in the debug/release folder in the saved directory.
When you are delivering a project, always change to Release mode. So that file will be created in Release folder
Finally for deploying the web application, double click that .msi, this will deploy in the server. Open Inetmgr and check all files are copied.
Is this easy nah ??! Fine 
- Harini
-- modified at 6:57 Thursday 22nd February, 2007
|
|
|
|
|
Nice I given 5 score for this.
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
|
|
|
|
|
thnx a lot for ur reply.
I did all these steps then I opened the IIS and found the project and everything but when I write: http://localhost/<virtualdirectory>
the application cannot be accessed (Page cannot be displayed).
I want the other machine to access the application through the computer name.
like that: http://<computername>/<virtualdirectory>
|
|
|
|
|
You must define a default page, so when the application is requested its called,
you might also consider typing a virtual directory name.
|
|
|
|
|
Hi
After deploying the web appliction, Open Inetmgr, expand your web application and right click the default.aspx or default page, Click browse... then this will open your default browser. This is just for testing.
Now you will see the correct URL in the address bar (along with http://)..right??.
From next time you can type the URL directly in the address bar (i.e no need to go to Inetmgr again).
If you are getting some permission error, again right click the web appln (in inetmgr), go to Properties. Go to 3rd tab - 'Directory Security'. Click Edit.. Button. Uncheck Anonymous Access.
Click OK and refresh your web appln. Hope you are able to see your web appln 
- Harini
|
|
|
|
|
Preven user to access previous page how i an i do that?
|
|
|
|
|
HI Nikhil
Please Modify your post no one is unable to understand what you want to ask ?
<l>Thanks and Regards
Sandeep
|
|
|
|
|
Don't, period. This is very bad usability practice to force the user to do anything. Design your application better.
|
|
|
|
|
Prevent user to access previous page??
maybe. you may use javascript to clear the broswer history..
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
If you want to thank me for my help, please vote my message. Thank you.
|
|
|
|
|
VS 2005, VB. I drop an AccessDataSource on the web page and click on
"Configure Data Source". If I used the browse button, the Access database
that is within the application path does not display. I moved the database
to other directories that the browse button is definitely showing, but it
does not display. If I ask it to show all files, I see other files in that
directory, but not the MDB. When I type the name of the MDB in manually, it
says that the file "does not exist or could not be mapped to a local file
that could be read". Access 2003 opens this MDB file and displays data from
it just fine, so the file can be read. I found nothing on this error
message using Google. Anyone know?
My small attempt...
|
|
|
|
|
I am having trouble finding out how to open a document in its native external program client side.
The application is a web based serverside .Net App(C#) that needs to open a file which exists on the server, but using a clients local program (eg notepad for .txt files). I have tried Process.start(), however, this only starts a server-side process which the client machine never sees.
I want to avoid using a hyperlink as I really need the files to be opened on a _SelectedIndexChanged event, and also creating a hyperlink to the servers local drive will not work for the clients. The scope for installing on client machines is basically nill so I seem to be somewhat stuck.
Please can someone help, as this is the whole point of the app and it will screw up my process if it can't be done 
Thank you all in advance
Mark
|
|
|
|
|
If you stream the file to the client and put a bit in the header of the page as so:
Response.AppendHeader("content-disposition", "attachment;filename=<filename>")
Should open the file (as long as the user has the appropriate application.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
