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.
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.
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 :
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.
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:
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
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.
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?
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.
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?
IM trying to put up a small database in my website and having my visitors to search it. A record of this database will have four fields: The first one will hold a number, the second one a Street name, the third a City, and the fourth a picture. The database will be searched either by the number or by the city.
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....
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:
Whenever i put in a remote location to server.map, it errors about an invalid character (the colon is what gets it. is there any way to do xml parsing remotely?
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.
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:
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.
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..
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.
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?
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:
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.
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.
In my latest school project, i would need to use ASP to connect to a remote database that is NOT located on the ASP server. I was wondering if this is possible?
Is there a way of making a connection to a database on a remote server? The intention is not to hack, but I have a customer who would like to perform a search in several identical databases on different web servers (with the owners permission) and show the result on the customers own web page.
Could this be done? Of course there must be some level of security, the db owners will if necessary give permissions to our customer.
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.
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.
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?
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.
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?