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 RepliesI 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.
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 View RelatedI 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.
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.
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 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.
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.
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 View RelatedI 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 View RelatedI'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:
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 View RelatedI'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 View RelatedI 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:
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.
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 ?
I have an application i am creating that will require the ability for a remote site to access some of the abilities of the program.
For example: Program will have a product manager and the webmaster will need to be able to place the product information on his/her remote site.
another funtion: the remote site will need to pass variable data back and forth between the application hosting server and webmasters site.
I have thought about using cookies or XML but cookies are kinda limited in respect to what i need and XML requires an XML enabled browser like IE 5+.
Am I missing something? any ideas on how i can accomplish this
I was wondering if it's possible to get "the name" istead of ip from a user that runs a asp page?
cust10354-344.someisp.com istead of 231.13.434.23
I'm trying to get remote ip address and local ip address
of the user (i.e. machine name) but i couldnt find out it.
however i can see the public remote ip address.here is
the little code that i have written..
<%
For Each Item in Request.ServerVariables %>
<tr>
<td><%= Item %></td>
<td><%=Request.ServerVariables(Item)%></td>
</tr>
<%
Next
%>
I use the RemoteScripting with the rsproxy.class within my asp pages.
I don't have problems except, when the Java console is not active in IE.
Is there a way to detect from asp, if the java console is active or not ?
or, how to do remote scripting without the rsproxy ?
i want upload a txt file to remote server
View Replies View Relatedi have just completed the charity web site www.leahpattison.org (please give
your support) and i have the news system that they can update hosted on
shared hosting on a sub domain of one of our core domains leah.neue.co.uk on
the main sites home page i have a scrolling news ticker in an iframe that
calls a page from the 'news server' and whenever you click on a news item it
pushes you onto the news server to deliver the pagesonly it keepstiming out.
anyone have any suggestions? the host say 'because we host many asp sites we
have a lot of traffic hitting msaccess databases, some of which do not
properly close their connections' basically tough luck. is there any way i
can make this site more efficient and make the news system work?
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:
I have a Web application that uses Remote Scripting to provide dynamic data to a web page.I am testing the application in Internet Explorer 6 SP1 running on Windows XP Professional.
When I use the Microsoft JVM,the application works without any problems.However, as a result of future withdrawal of support of the Microsoft JVM as a result of the settlement with Sun, I need to ensure that the application works okay with the Sun Java plug-in for Internet Explorer.
This component is no longer available,and clicking on the OK button only reiterates this message. When I click on the Cancel button instead, the Remote Scripting functionality fails to work.Is it possible for Remote Scripting to be configured to work with an alternative JVM, such as the Sun Java Plug-In, or is it entirely dependent on the Microsoft version?
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.
View Replies View RelatedWe'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?
How to include remote file in an asp file? Anybody woh know about it.
View Replies View RelatedEvery so often my database log files fill up and i have to truncate the file.
DBCC SHRINKDATABASE (database_name_here, TRUNCATEONLY)
GO
BACKUP LOG [database_name_here]
WITH NO_LOG
Any idea how I could run this? From an asp page...?
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....
I was susseesful in mapping remote machine with vbscript. Now I am building the same tool with ASP .I am using the same code but its not working. Below is the portion where I am mapping the drive: Code:
View Replies View RelatedI have a shell script that needs to be executed on a unix machine on our network and text output needs to be retrieved How can I make a asp.net page do it ?
is there a way to batch execute the command that I execute in the command prompt and just retrieve the outoput.
Here is what I am manually executing currently from the dos command prompt
Step 1. telnet <unixmachine>
Step 2. login <login name>
Step3. I Provide the password
Step4. once logged in to the machine I Provide the <shell script command>
The results of the script get displayed on my command window. I copy and paste the result
can the above be done through asp/asp.net page