ASP access to Data on Remote devices
in [ASP]
|
From: Anthony Jones on 26 Aug 2008 04:33 "p byers" <pb(a)sst-ltd.co.uk> wrote in message news:48B2CCAE.92E14D6(a)sst-ltd.co.uk... > Anthony > Thank you for your reply. > > I tried so hard not to 'screw-up' my request and to give all of the relevant > information !! > > Such irony to slip-up on the 'Salutation' - lol > > The access to the ASPages (both on the PCs on the Local LAN and on the 'Public > Internet') will be anonymous. > > The access to the Databases is Jet Queries only - not uploading or downloading. > > In simple language, I would like several servers running IIS (LAN and 'Public > Internet') to serve ASPages to be able to use the a Common (the same) Database - > not individual copies. > > -AND- > > to do it simply by quoting the appropriate Shared Folder in the DataSource of > the 'Open' statements. > > -BUT- > > I am too dim to be able to do it, I have Searched, Read and Struggled for ages - > and FAILed so far. > > -HENCE- > > My simple plea for simple help from clever folks > I'm gonna guess that what you mean by public server is a server you run on your network which is accessible to the public. Add a new user to your domain (lets call it IUSR but you call it what you like) and make it a part of the GUESTS group. Set its password never to expire. On the File server (MAXTOR?) grant IUSR read/write access to the file share that contains the mdbs. Similarly grant the IUSR access to the folder that is being shared. The 2000 server will have a website or application folder which needs access to an mdb on the file server. Open the site or applications properties in IIS manager. Go to directory security, click edit... in authentication control, clear Intergrated Windows authentication, click edit... anonymous access, change the username to the domain IUSR account (use the browse button to select this) and enter the IUSR account password. Clear the Allow IIS to control password box and ok out the dialogs. Grant IUSR at least read rights on the folder that is the root of the site or application. Open local security policy (in admin tools) on the 2000 server. Expand Local Policies and click User Rights Assignment. In the list select and edit 'Log on as batch job' add IUSR to the set of accounts that can logon as a batch. While you're there look through the list of rights looking of rights granted to IUSR_<machinename> where ever such a right is granted add the IUSR (I think batch is the only one necessary, if that). Access some simple htm or gif in the application from a browser to check you got those steps correct. If that fails check the event logs, you'll likely have some message complaining about the username, password or access rights. I notice form subsequent replies that you may be attempting to access the mdbs on a mapped network drive. The process that ASP applications run in cannot see network drives. You must use UNCs to access network resources. The site should now be able query the mdb files. The steps for the XP systems are the same (note you only need one IUSR account for the domain). -- Anthony Jones - MVP ASP/ASP.NET
From: p byers on 26 Aug 2008 04:55 Anthony Thank you for your reply I will follow your advice step-by-step - hopefully arriving at the desired solution. I guess that I need to get to understand ActiveServer and create a Local Domain on my LAN before I can start. At the moment, connections on the LAN are achieved by IP Address or Machine Name. Only one point of correction - "Public Internet Server" is a phrase that I use to describe a Windows 2003 Server hosted for me by '1and1 ltd' - I have total use and control over that server, it is NOT shared access to a '1and1' Server. I host around 80 of my own WebSites on it and provide hosting for other folks too. Sorry that I did not make that clear in my original question. I also have several sites hosted with other ISPs I dream of giving these other sites access to Databases on my 'own' server !! Pete (Notholt UK) Anthony Jones wrote: > "p byers" <pb(a)sst-ltd.co.uk> wrote in message > news:48B2CCAE.92E14D6(a)sst-ltd.co.uk... > > Anthony > > Thank you for your reply. > > > > I tried so hard not to 'screw-up' my request and to give all of the > relevant > > information !! > > > > Such irony to slip-up on the 'Salutation' - lol > > > > The access to the ASPages (both on the PCs on the Local LAN and on the > 'Public > > Internet') will be anonymous. > > > > The access to the Databases is Jet Queries only - not uploading or > downloading. > > > > In simple language, I would like several servers running IIS (LAN and > 'Public > > Internet') to serve ASPages to be able to use the a Common (the same) > Database - > > not individual copies. > > > > -AND- > > > > to do it simply by quoting the appropriate Shared Folder in the DataSource > of > > the 'Open' statements. > > > > -BUT- > > > > I am too dim to be able to do it, I have Searched, Read and Struggled for > ages - > > and FAILed so far. > > > > -HENCE- > > > > My simple plea for simple help from clever folks > > > > I'm gonna guess that what you mean by public server is a server you run on > your network which is accessible to the public. > > Add a new user to your domain (lets call it IUSR but you call it what you > like) and make it a part of the GUESTS group. Set its password never to > expire. > > On the File server (MAXTOR?) grant IUSR read/write access to the file share > that contains the mdbs. Similarly grant the IUSR access to the folder that > is being shared. > > The 2000 server will have a website or application folder which needs access > to an mdb on the file server. Open the site or applications properties in > IIS manager. Go to directory security, click edit... in authentication > control, clear Intergrated Windows authentication, click edit... anonymous > access, change the username to the domain IUSR account (use the browse > button to select this) and enter the IUSR account password. Clear the Allow > IIS to control password box and ok out the dialogs. > > Grant IUSR at least read rights on the folder that is the root of the site > or application. > > Open local security policy (in admin tools) on the 2000 server. Expand > Local Policies and click User Rights Assignment. In the list select and > edit 'Log on as batch job' add IUSR to the set of accounts that can logon as > a batch. While you're there look through the list of rights looking of > rights granted to IUSR_<machinename> where ever such a right is granted add > the IUSR (I think batch is the only one necessary, if that). > > Access some simple htm or gif in the application from a browser to check you > got those steps correct. If that fails check the event logs, you'll likely > have some message complaining about the username, password or access rights. > > I notice form subsequent replies that you may be attempting to access the > mdbs on a mapped network drive. The process that ASP applications run in > cannot see network drives. You must use UNCs to access network resources. > > The site should now be able query the mdb files. > > The steps for the XP systems are the same (note you only need one IUSR > account for the domain). > > -- > Anthony Jones - MVP ASP/ASP.NET
From: Anthony Jones on 26 Aug 2008 06:51 "p byers" <pb(a)sst-ltd.co.uk> wrote in message news:48B3C4FD.DA3F061B(a)sst-ltd.co.uk... > Anthony > Thank you for your reply > > > > I will follow your advice step-by-step - hopefully arriving at the desired > solution. > > > I guess that I need to get to understand ActiveServer and create a Local Domain > on my LAN before I can start. > Umm... that would seem to me to be a pre-requisite. > At the moment, connections on the LAN are achieved by IP Address or Machine > Name. > > > > Only one point of correction - "Public Internet Server" is a phrase that I use > to describe a Windows 2003 Server hosted for me by '1and1 ltd' - I have total > use and control over that server, it is NOT shared access to a '1and1' Server. > Sorry I'm not clear on this now. You want query an mdb hosted on this server from one on your internal network? Do you have access to file services on this machine? Are you really sure you want to be doing JET queries (not known for their robust nature) over a VPN style link (if you have file service access you would want be using a VPN)? > I host around 80 of my own WebSites on it and provide hosting for other folks > too. > Thats both the blessing and the curse of IIS. Much can be achieved without a great deal of understanding of how it works. > Sorry that I did not make that clear in my original question. > > I also have several sites hosted with other ISPs > > I dream of giving these other sites access to Databases on my 'own' server !! > > -- Anthony Jones - MVP ASP/ASP.NET
From: Chris Hohmann on 26 Aug 2008 19:08 "p byers" <pb(a)sst-ltd.co.uk> wrote in message news:48B3A115.151A059B(a)sst-ltd.co.uk... > Bob > > Thank you for your advice. > > The "Computer Name" of my MAXTOR storage device is: MSS-0135F8 > On the PC on which I am testing, it is Mapped as the 'S:' drive > > I created a tiny test ASPage which is shown below. > > There are three "dataBaseRoot" values > > ================================================================ > > The first is to prove the Script by using a Local Database table - it > works OK > > ================================================================ > > The second uses the Mapped drive name - it fails as below > > Error Type: > Microsoft JET Database Engine (0x80004005) > 's:\atest\ReConstituted_wwwroot\Data\common\data\org_data.mdb' is not a > valid > path. Make sure that the path name is spelled correctly and that you are > connected to the server on which the file resides. > /test/testshare.asp, line 14 > > ================================================================ > > The third is my attempt to use a UNC string - it fails as below > > Error Type: > Microsoft JET Database Engine (0x80004005) > '\\MSS-0135F8\atest\ReConstituted_wwwroot\Data\common\data\org_data.mdb' > is not > a valid path. Make sure that the path name is spelled correctly and that > you > are connected to the server on which the file resides. > /test/testshare.asp, line 14 > > ================================================================ > > Where do I go next ?? > > Pete (Northolt UK) > > > > <% > > dataBaseRoot = "c:\inetpub\wwwroot\Data\common\" > > ''dataBaseRoot = "s:\atest\ReConstituted_wwwroot\Data\common\" > > ''dataBaseRoot = "\\MSS-0135F8\atest\ReConstituted_wwwroot\Data\common\" > > DBCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & dataBaseRoot & > "data\org_data.mdb" > ''Response.Write("<P>" & DBCon) > ''Response.end > > set my_conn = Server.CreateObject("ADODB.Connection") > my_Conn.Open DBCon > > %> > > > > Bob Milutinovic wrote: > >> >> There's an oft-abused acronym of "UNC" which'd help you greatly here. >> >> Have a read of the URL below; hopefully that'll be enough to set you in >> the >> right direction. >> >> http://en.wikipedia.org/wiki/Path_(computing)#Uniform_Naming_Convention >> >> - Bob. > The "S" drive is mapped to a network file share on MSS-0135F8, correct? If so, what is the name of that file share. The name of the file share should appear in the folder tree in Windows Explorer (i.e. the file manager). It should appear as something like: myfileshare on 'MSS-0135F8' (S:) So, in the example above the UNC you should use would be: \\MSS-0135F8\myfileshare\atest\ReConstituted_wwwroot\Data\common
From: Bob Milutinovic on 26 Aug 2008 23:35
"p byers" <pb(a)sst-ltd.co.uk> wrote in message news:48B3A115.151A059B(a)sst-ltd.co.uk... > Bob > > Thank you for your advice. > > The "Computer Name" of my MAXTOR storage device is: MSS-0135F8 > On the PC on which I am testing, it is Mapped as the 'S:' drive > > I created a tiny test ASPage which is shown below. > > There are three "dataBaseRoot" values > > ================================================================ > > The first is to prove the Script by using a Local Database table - it > works OK > > ================================================================ > > The second uses the Mapped drive name - it fails as below > > Error Type: > Microsoft JET Database Engine (0x80004005) > 's:\atest\ReConstituted_wwwroot\Data\common\data\org_data.mdb' is not a > valid > path. Make sure that the path name is spelled correctly and that you are > connected to the server on which the file resides. > /test/testshare.asp, line 14 This would appear to be a major failing. From the machine you're running the ASP scripts on, can you get to S:\atest\ReConstituted_wwwroot\Data\common\data\org_data.mdb using Windows Explorer? If not, you'll need to create a permanent mapping to drive S: on _that_ machine, so IIS can reference the network drive. If you can navigate to it with Explorer, then it'd likely be a setting/permission issue within IIS, but I've never encountered this before - and not having an IIS machine readily available to me at the moment, I can't dig through the settings to see if there's anything in there which would prevent you from accessing network shares from within a script. To eliminate the possibility of it being a peculiarity of the external Maxtor device, you might want to try accessing a share on another physical (Windows-based) computer. You might also want to use Scripting.FileSystemObject and ReadTextFile to read a text file from drive S:, to see if an ASP script can access simple files from a shared source (and if this succeeds, the blame'll lay on JET/OLEDB). - Bob. |