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.
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?
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.
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.
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?
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?
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 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 downloaded the DiscIDCalc program from CDDB. I've used it a lot because I've written my own application for my CD collections (keeping track of the track information of each CD, track duration etc). I've already got all my CDs into the application, I'm now just going through each of the disc again just to add in the DiscID information. I do it by running the DiscIDCalc program, generating the DiscID, and then then copying and pasting this DiscID into my application and then save it. if anyone has successfully generated the DiscID within an asp page? Now I have to have my browser up and this DiscIDCalc program up. Just want to know if there's a way to incorporate the two together (even if it means I'm not using the DiscIDCalc anymore.). This DiscIDCalc has a documentation for its DiscIDCalcDLL.dll but it's not something that I can CreateObject with, so I'm quite clueless... I don't want to use VB to write APIs for that
I use query string to search for records by using GET method. This method will generate querystring automatically by using the form name. Using search field together with drop down is fine but the problem is when i didn't enter any keyword or left the search field blank it won't display any result.
Unless I put "%" in the search field. How do I make the querystring change to "%" whenever the field is blank so that all records will be displayed.
i am trying top update a field in my sql database but it wont let me??? does anyone know if my syntax is correct?? I have a field called userId in the database and want to replace it with my form request. Code:
Method Not Allowed The requested method POST is not allowed for the URL /Database/processForm.asp.
Apache/1.3.33 Server at antonyx.freestarthost.com Port 80
i just got this error, however, i have managed to post data into my database on this server b4, why is this error comin up now, could there be a prob with my asp file??
When using ActiveX Combo Boxes, can you use the GetString method to populate the control? I currently am using AddItem, however, it is taking a long time to process. I know that GetString works well to improve the performance. Here is my code while using AddItem:
Now this is a weird one. I'm having a problem with a system in development. When I post data from a form in IE 5.01 it works fine, but in IE 5.5 it refuses to post the data to the server and in IE 6 it's scatty -- works sometimes but not others. Anyone seen this before? Edit: By the way -- this is normal VBS/ASP running on IIS 5 on an NT server
I have a form that ignores my form validation code. My code works if I use the post method of <%=Request.ServerVariables("SCRIPT_NAME")%>.
But, If I post the form to another .asp page, which I prefer, the code doesn't work. Do anyone have any suggestions? Here's my code.
I have a form that ignores my form validation code. My code works if I use the post method of <%=Request.ServerVariables("SCRIPT_NAME")%>. But, If I post the form to another .asp page, which I prefer, the code doesn't work. Do anyone have any suggestions? Code:
I have a service provider that's sends sms messages from clients mobile phones to my asp page, problem is I don't know how to show the data and they are not being helpful. The process is simple as outlined below (instructions from service provider
Example: If you provide this: http://www.yourdomain.com/sms/sms.asp then we will do a post via a standard HTTP GET as follow:
http://www.yourdomain.com/sms/sms.a...ISO-8859-1&udh= How do I receive the url with the parameters in the address bar?
What's the best method to hide, or not show a certain record when doing a pull from a database, as in I am pulling a list with a dozen category's and I don't what to show one of them.
I have a demo.asp page, that can't pass hidden value "mr progrramer" to itself using POST method. Only "mr" is passed.
I created a second asp file demo1.asp and passed "mr programmer" and whole string (include space b/w mr and programmer was passed successfully).
The code for demo.asp is:
<% name = request.Form("name") response.Write "hello " & request.Form("name")
' if name is empty then store some string with space in it ' problem is the word before space 'mr' is passed, but 'programer' is not passed if len(name)=0 then name = "mr programmer" end if %>
