FSO Remote Server Access
Wish I'd found the thread yesterday before spending half the day fighting
the same battle and finding a workaround. But at least it explains why my
final approach worked.I set the remote folder as a virtual folder on the webserver, assigned web rights to a domain user and used fso.copyfile(server.mappath) to copy a
file created locally.I'm not thrilled that access to the remote location can't be controlled at the user level this way but at least access to the calling script can.
Strange though, the problem showed up during a migration. Server A had been
hosting this asp page and connecting to server B sucessfully. I was moving
the application to server C when I ran into the problem. All three machines
are W2K, same service pack, same domain, same users, same access
rights/method configuration. Go figure.
View Complete Forum Thread with Replies
Related Forum Messages:
Remote Access To SQL Server
I was given the following by my host: Database name: asdfafasf IP/Host: 11.111.11.111 Server: asfafaf Username: afafdadaf Password: adfadf Every program I use (excluding Enterprise Manager - I don't have it) to connect is unsuccessful. Access Projects for example, when I try to establish a connection, it doesn't ask for IP/Host.
View Replies !
Access Remote Server
I have admin privileges on a remote server and would like to use a web interface (asp) to manipulate various files. It seems that when I access the remote web pages I only have IWAP and IWAM privileges. Is there a way to automatically send my admin username and password via the asp pages so I will have admin privilages?
View Replies !
Access Remote Access Database From ASP
I have an ASP page needs to access a remote MS Access2000 database, I got error "The Microsoft Jet database engine cannot open the file 'F:Collect.mdb'. It is already opened exclusively by another user, or you need permission to view its data. ". The 'F:' is a mapped drive from remote machine where the access database loactes. If I copy the database back to local box, no problem.
View Replies !
Remote DB Access
If I have the line adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("produkten.mdb") to access an Access Database local to the site, is it possible to have something like adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=http://www.somesite.com/somedb.mdb" To allow the site to connect to a db on another site/server which also belong to me?
View Replies !
Remote MS Access DB?
How do I connect to a remote Access DB from my desktop? I have a MS Access DB online adn wish to hook up to it from my desktop absed DB?
View Replies !
Remote DB Access
I have a access database on my server which my users can download it from my website. I have update.asp file which will update the database on the client. So say if there are 2 users each will download a copy of the database on to their machines. When they run the update.asp file, the information will go to their respectively database(the one's on their machine). The architecture of the DB's remains the same but each client will have his only data. Is this possible? IF yes then, why do I get this error... Microsoft JET Database Engineerror '80004005'Could not find file C:Test.mdb.
View Replies !
Why I Can Not Access Remote Database
I have asp page needs to access remote database, I got error"The Microsoft Jet database engine cannot open the file 'Unknown'. It is already opened exclusively by another user, or you need permission to view its data. " Could anyone show me the steps to configure permission (I tried creating IUSER_DBMACHINE local account on the database box, give this account full permission on the database folder, doesn't work.
View Replies !
Remote Access Database
I am connecting to remote access database through my asp script. The Access database is on a different domain and my webserver(where asp scripts reside) is on a different domain.When i ran the script i got this scary error message:Code: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x3a8 Thread 0x7c4 DBC 0x2770ff4 Jet'. i think this is related to some permissions issue, but not sure how to correct it.
View Replies !
ADSI Remote Access
I'm trying to access the ADSI data on a remote machine in my network usng ASP and the GetObject("IIS://...") call, but I keep getting an "Access Denied" message. It works perfectly on the localhost. Did anyone pass by this problem?
View Replies !
LoadFromFile Method: Trying To Access Remote URL
I'm trying to use the Stream ADO object, and I need to access a file that is on a remote server. I tried using the FileSystemObject object, but I need to save a CSV file that contains some funky characters. The documentation I have access to does not tell me that I can or cannot enter in a remote location...(e.g. "http://10.10.10.10/foo/foobar.csv") I receive this error: ADODB.Stream error '800a0bba' File could not be opened Code:
View Replies !
Connec To Remote Access Database
What I am trying to achieve here is a connection to an access database on another server on our network. Every method that I try I get SQLerrors or DNS errors nothing seems to work. Does anybody know a solid method I can try to gain the connection i require?
View Replies !
Remote Editing Of A MS Access Database
I'm new to programming databases with MS Access. I'd like to know how I get user input for a database, in a form, read from it and do "if" statements. Does anyone know how to do this? I've tried ASP approaches (with the FSO function and .txt files) but none are as effiecient and organized as databases appear to be.
View Replies !
Connecting Web Server And Remote Db Server Via Asp
my prob is i have 2 different computers, one that runs my asp pages and the other my database server (mySQL). im working on my local and trying to connect my remote database with my remote webserver using DSNless connection string as more advisable. Code:
View Replies !
Local Server To Remote Server
I am not an expert but I am trying to create an application where I need to connect my website to the user's(basically my client) database in access and then I will read the values from the database in the local drive and upload all the values in the database at my webspace. I will have everything like the database name and the password....so how can I do this
View Replies !
Remote Server
I work with dreamweaver 8. I use the tools provided within dw to create my asp features etc. I downloaded a news script to save time since its a very low budget site, but I need to customise how its displayed. The news script connects using a Server.MapPath connection. I would like to be able to work locally using a dsn. dsn=nwnews; but I would like to be able to change that connection to work on the remote server for testing etc. This is Dreamweavers Connection file: Code:
View Replies !
FSO On Remote Server
We're wanting to upload files and save them to a different server on the network (Windows 2000) from the web server. The upload works fine but we cannot copy files, using the File System Object, to this other server folder. what is required in terms of mapping and registering the folder so that the web server can link to it?
View Replies !
Remote Server By FSO
I just want to delete a file in a server by FSO. My code is: Set objFSOD = Server.CreateObject("Scripting.FileSystemObject") objFSOD.DeleteFile Server.MapPath(".") + "Greetings" + sFileName1, True Set objFSOD = Nothing When I check the code locally, everything is fine. I have two remote servers. When I check the code in each servers, one is fine and other is thrown a error. But the error msg is in Korean language while I'm not korean, that is why I can't read the error msg. What would be the error msg about? The sFileName1 was always correct every time I checked.
View Replies !
Remote Server
Currently we have a site that allows users to listen to mp3 files. It is creating bandwidth issues. So we want to move the mp3 files to an ISP that caps bandwidth usage. Ours is currently burstable. Now I am able to do the following: Set fs = CreateObject("Scripting.FileSystemObject") If fs.fileExists(music_file) Then 'show music file Else 'do not show a link for file End If set fs = nothing Is it possible to do the same thing, but on a remote server?
View Replies !
Cannot Access Remote File From Mapped Drive
I want to access files from a remote server so I mapped it in my server under z: for myserverwebmysiteimages I added this UNC path to my IIS virtual directory and name it as "upload" but I still cannot use any FSO to read it. Here is my code:
View Replies !
Linked 'tables' (access) Local - To -remote
Is it actually possible for a local access 2000 database to link to a remote database online via linked tables. I just wanted to know how feasible a LINKED TABLE scenario would be. If this was possible it would solve so many administration problems and save development time when it comes to building asp-admin pages to manage the backend.
View Replies !
Access A Remote Database On A Local Harddrive
i want to run a website on a server with an sql database ( that in itself is no problem, i've done this before) but with a possibility to update the sql database with data stored on a local harddrive in an acess database, can ianyone give me some hints or websites with related info ?
View Replies !
ASP.net Not Working On Remote Server
Localy along with VS2005 when hitting ctrl+f5 the asp application server get's launched, and the whole site works fine, now on my windows 2003 server i installed IIS, it also has apache running and that works fine but the IIS part, i cant get it to work.... i have my inetpub filder on c which has a www folder but when i copy my project to there it tells me it's unable to process the page (aspx), can somebody help me out here please..... I did the configuration and rule statements in the server manager which now displays ASP.net working and active, but it does NOT work at all....
View Replies !
CDO - And Remote SMTP Server
1. I wonder, why do I need to add the following lines when sending forms through mail, using CDO component? 2. If I remove these lines and the form is still submitted as it should, and I get the mail as a result as it should, does it mean I do not need these lines? 3. In other words - How do I know if an SMTP service is installed on the local server, and not in another network (besides asking the admin)? Code:
View Replies !
Database On Remote Server
I try to get data from a database which is on an other server. I can view the files on this server via the directory "t:" from the machine the ASP pages are on. Constring: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=t:database.mdb" Error: 't:Database.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.
View Replies !
Connecting To SQL Db On Remote Server
I need to connect to a SQL db on a remote server but my connection string doesn't appear to work as the page just keeps timing out. The physical url of the db is (not real IP) 0.0.0.0/Databases/query and the connection string looks like so: strConn = "Driver={SQL Server};Server=0.0.0.0/Databases/;Database=query;" What should the connection string look like?
View Replies !
FileExists On Remote Server
how to use FileExists to check to see if a file exists on a local server BUT what if I want to check if a file exists on a remote server (webserver)? If I enter "http://domainname/folder/image.jpg" it always returns false.
View Replies !
Asp Forms In Remote Server
im hosting my website in linux server...so i need to develop an enquiry form....my fren is hosting in a windows hsoting server and he have the asp enquiry coding.. is there any way i can do remote coding hosting ...where the enquiry form will be in my php server and the asp coding will be in my frens windows hosting server..
View Replies !
Server Side Vs. Remote
I'm having a problem viewing a pdf file via intranet from the remote location. When I view it from the server side it works. Here is the code and the file name. This is what the path looks like in the Access 2k database. c:/Inetpub/WWWroot/TEB/Documents Okay this is what happens, when I use this path it doesn't open the file because it's looking for it on my local machine. But when I use this path f:/Inetpub/WWWroot/TEB/Documents in which F: is mapped to the server where the web site is locate it opens the file. If I use this method this would mean mapping everyone to this server which causes a security issue. I cannot allow anyone to view or modify my files for the intranet, they may become corrupted. So what I need is some kind of alias or something that. Is there a way that I can capture the c drive from the server using Access 2k without using the actual c: format so that it will read from the server and not the local pc. Code:
View Replies !
Connecting To Remote Oracle Server
How can I access remote oracle server?. I'm using the following connection string. " Provider=MS Remote;Remote Provider=MSDAORA;Data Source=XYZ;Remote Server=http://DBServersIP;User Id=id;Password=pw" Both the web server and DB server has oracle client. I can tnsping, connect using sql * plus from the webserver. But when I try to do simple connection & query , I get the following error. " Microsoft ADO/RDS(0x80072EFD) Internet Client Error: Cannot Connect to Server. " Can someone throw some links or help.?
View Replies !
Remote Server Drive Space
I have wrote small script that can get local drive information (e.g. size). Is there anyway I can get disk information from server ? 'Get Drive's Free space dim MyDriveC,MyObject, MySpace set MyObject = Server.CreateObject("Scripting.FileSystemObject") 'Set Object set MyDrivec = MyObject.GetDrive("c:") 'Free Space MySpace = MyDrivec.AvailableSpace 'Write msg 'Response.Write("Available space on Drive C: " & MySpace) code is working fine but when I try to put other then "c:" it says path not found. is there anyway I can get infromation from server or remote computer ?
View Replies !
HTTP Post To A Remote Server
I have an asp page. There I enter some text. This text needs to go some other web site but as jsp page ( such as http://www.web.com/Link.jsp). Now, I was told to submit my asp page as HTTP Post to their jsp page. This is completely a new thing for me to do. Code:
View Replies !
Connect To A Database On A Remote Server
I have my access database on a xp workstation setup as a web server using IIS. I am trying to access the mdb from another web server, but when I run my code below I keep getting : Microsoft ADO/RDS error '800a20ff' Internet Server Error. Code:
View Replies !
FTPing Files To A Remote Server
I'm trying to write a script that will put files uploaded through a page on a remote server via FTP. I've tried the code on this page: http://benmeg.com/code/asp/ftp.asp.html but I get a permission denied error when trying to execute ftp.exe. Does anyone know how I can fix this, or recommend another way of getting the files onto the other server? The production servers are running Windows 2003.
View Replies !
Save Remote Image To My Server
I would like to reference a remote image, such as http://www.mysite.com/pic.jpg and save it to a local folder such as c:pics . Can this be done with ASP? I have played with many image manipulation components and none of them perform this fuction.
View Replies !
Load Text File From A Remote Server?
Is there a way to load a text file from a remote server into a string much like using the Inet Control in VB? I am familiar with reading in RSS feeds, but what should I do if the content is a straight text file?
View Replies !
Can Connect To A Database On A Remote Server But With An Error
I eventually managed to create a connection between my IIS LocalHost ASP WebPages and my database located on a website on the net. Here is the solution: Dim conn, connect set conn=server.CreateObject ("adodb.connection") connect = "Provider=MS Remote; Remote Server=http://www.example.com; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & server.mappath("database_filedatabase.mdb") & ";" conn.Open connect When I point my connection to my database on the net like in the code above I get the following error: Error Type: Microsoft ADO/RDS (0x800A2011) Internet Server Error: Object/module not found. Any Suggestions?
View Replies !
Fetching Xml File Data From Remote Server
We are working on a real estate web site which lists real estate listings from different affiliated realtors. Our client wants to have a system where it display real estate listings from affiliated realtors without having to enter listing information into our database. Affiliated realtor will provide a link to xml file containing listings information and we have to fetch the data from it and display it into our web site. The xml file will be on some other server. Is this possible?
View Replies !
Global.asa - Different Behavior On Local And Remote Server?
On a remote server running W2K and thus IIS 5 I have session variables declared in a global.asa file in the root of the application which are passed and visible on all pages with no problem. This was also the case on my localhost before (127.0.0.1), also on W2K / IIS 5. But now for some reason one variable doesn't pass through at all and the other is taken as a String on the localhost. The problem area in question in my Global.asa file (which is identical on the remote and local servers) <script language="vbscript" runat="server"> Sub Session_OnStart CInt(Session("indx"))=0 CInt(Session("total"))=0 ... End Sub When I view the values locally with: pprice = Request.QueryString("fpPrice") Session("total") = Session("total") + pprice Response.Write "Index: " & Session("indx") Response.Write "Total: " & Session("total") I get (for example - pprice = 45, and after 3 attempts): Index: Total: 454545 Whereas on the remote server I get: Index: 3 Total: 135 Has anyone else experienced this?
View Replies !
Connect To A Remote Server To Grab Data
I am wondering if it is possible to have an asp script, called script1.asp sitting on a server called server1. when this asp script runs, i want it to connect too a different server (called server2) somewhere else in the world and grab data, maybe an xml file. Is this possible? and if so what is the process called (and/or function names etc) that can help me do this, so i can look them up in google and get cracking on the code.
View Replies !
SQL Server Vs. Access
I have an Access DB connected to an IIS via ODBC, and use ASP pages to get info to/from the DB. My guys in IT now want to migrate the Access DB to SQL Server. Can anybody tell me what this implies in terms of : a) syntax of my ASP pages b) syntax of my SQL statements c) other problems I may not have thought of. I am told it is really easy, however, I just cannot get is to work. BTW, I have activated the "SQL Syntax" option in Access, in case that helps any.
View Replies !
ASP & ACCESS/SQL Server
This might be more of a database question than ASP. But when you create a database and then create relationships with the database, once you open an asp page say to create a new record; once the record is saved, shouldn't it also update the relationship with the table involved? Unless I am doing something wrong, it is not updating the second table; for example: rs.AddNew rs("username") = Request.Form("txtUserName") rs("password") = Request.Form("txtPassword") rs("firstname") = Request.Form("txtFirstName") rs("lastname") = Request.Form("txtLastName") rs("email") = Request.Form("txtEmail") rs.Update Response.Write("Record has been added!") Say the information is entered, because of the UserID field is "autonumber", that would be my primary key: so "1" would be related with the second table where I have: upload.id (PK) userID Upload1 date1 Upload2 date2 Upload3 date3 If on the other table I have number of uploads to generate, whenever it adds a document, it would have the relationship of the username, and the upload: But when I do that, even adding the code, it does not update the code. So what am I doing wrong? Do I have to do another Add.New at the same time for the second table?
View Replies !
Access MS SQL Server
I ask this here because as ASP Developers I figure you have more experience with windows Webhosts. I know Phpmyadmin is usually provided on Apache platforms to manipulate MySQL databases. What interface is usually provided by webhost to access and manipulate your Microsoft SQL databases?
View Replies !
From PHP/MySQL To ASP/SQL Server Or Access
I have always used PHP and MySQL to do anything database related on the web, however I find myself in a new situation. I've been handed the daunting task of creating a (relatively) simple, partially database driven website for my company's intranet. The one problem I have is that all of our servers are Windows 2000 based because all of the in-house software we have works off of SQL Server... and I've never touched a windows based server, SQL Server, or ASP in my life. Searching through the forums, I've been able to find a few ASP tutorial sites, but everything I've found seems to be either all technical info and no basics or a basic tutorial written for people who are already familiar with Visual Basic, C, or another type of windows programming 'thing'.
View Replies !
Export Access To SQL Server
I have a database in MS Access and have one table in it (tblcontest) which has 30 fields in it, I want to export all the fields into Sql Server 2000, any idea how to? PS: I dnt wanna create all the fields manually one by one in SQL Server.
View Replies !
Access, SQL Server Or MySQL?
I've been using URL asp shopping cart (free version) for a while with an access database and it worked perfectly. My store is very popular now (more than 200 simultaneous users) and I need to migrate to a professional database. Comersus is compatible with SQL Server and mySQL. Which one do you recommend? My idea was to use mySQL since in that case I can purchase Power Pack Medium ($239) instead of Premium (.$370)
View Replies !
Moving From Access To SQL Server
Im changing from Access to SQL Server and had a few questions: What is the Equivalent in SQL: Access: Memo Field Also, for my Autonumber field, which is Identity in SQL Server, why can I only go up to (int) 4 in Length for SQL Server?
View Replies !
|
TRACKER
