Eric,
If you have Microsoft Transaction Server installed on the web server you can
use it similar to the below answer only insert the ADODB components instead
of the FSO component... it's what I do (it's for an intranet) and has worked
fine so far!
HTH,
Brenda
What I found that works well for me so that I can access the file systems on
remote servers is to create a new package in Transaction Server on the web
server with the FileSystemObject. This is a one time set up and you can
control the access rights by the identity you use to set up the package. I
don't know how this would affect the hit metrics since I haven't had a need
for that yet.
To create a new package:
1) Open Transaction Server on the web server.
2) Click Computers -> My Computer -> Packages Installed.
3) Click Action -> New -> Package
4) Click Create Empty Package
5) Enter a name for your new package (doesn't really matter what it is
called, I named mine FileList)
6) Click Next
7) Decide what Identity option you want to use.
(This would depend on the type of access rights you want to use, I used a
set user identity that has read only rights set up on the remote server I
needed to access. You can use the browse option too.)
8) Click finish
Now you have a new package BUT... you have to tell it what component to use!
9) Click on the + next to your new package and highlight the Component
folder
10) Click Action -> New -> Component
11) Click on Import Components already registered
12) Scroll down and highlight Scripting.FileSystemObject
13) Click Finish
You should now be able to use the FileSystemObject with UNC names in your
web page.
EX:
Dim objFSO
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
Dim strPath
strPath = "\\amglks200\group\homepage\"
Dim strCurrentFolder
strCurrentFolder = "Environmental"
Dim objFolder
Set objFolder = objFSO.GetFolder(strPath & strCurrentFolder)
-----Original Message-----
From: Eric Levine [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 1:58 PM
To: ActiveServerPages
Subject: DSNLess Connection to Remote MS-Access DB
Good afternoon to all,
Quick question.. I am in the process of creating an application that
will go across multiple web servers. Can someone please help me with
the code necessary to connect to an Access DB that is located on one
server, from ASP code on another.
I understand that HTTP is not acceptable in the connection string so I
am a bit stumped on how to recognize the .mdb file on the remote server.
Example:
Server 1 - Connection String
objSConn.Open "Provider = Microsoft.Jet.OLEDB.4.0; " & _
"Data Source = http://www.dbstore.com/data/test.mdb";
Server 2 - .mdb File on server www.dbstore.com
c:\data\test.mdb
Many thanks in advance.
Regards,
Eric
---
You are currently subscribed to activeserverpages as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
%%email.unsub%%
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
