How To Sync Local And Web Database?
I am wondering if their is a strategy or tool for syncing a local
database with a web-based database? Specifically I have an application
where orders are entered via a web form and the data emailed to my
client who processes the orders. I extract the order information and
update a local "order tracking" database. There are several order
processing steps.
I want to update a web database to reflect the status
of the order as it flows through the local tracking application. I will
send an email to the "orderer" at the major steps, but my client wants
to have a web-based report shows the status of all orders for a company
that has pending orders. In other words a company will enter multiple
orders and will be able to track the status of the orders by signing on
to the web site.
This status report gets its data from the
web-database.....which I must update from the local tracking database.
A pretty long winded explation which I hope mades sense. Has anyone
found a solution to this problem? Any reference or tools you can
suggest?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Application To Sync Multiple MDBs
I've got quite a few identical MDB files running on an IIS5 server. From time to time I need to go into various tables and add a field or two. It would be great if there were an application out there that could either: (a) sync all MDBs designated to match one I've added some fields/tables to OR (b) tell all designated MDBs to have an extra field(s) or table(s). I've began writing something like this that right now just does part of (b) but I'd rather find something that is much more slick and complete.
Local Filesystem
Is there anyway I can get the information about a file on the local machine of a user that is reading pages from my web site? Scripting.FileSystemObject does not have permission to do this, and I want to check the size of a file before I try to get it uploaded.
Server To Local
An application runs on server, and is used for Hour-registration. Now I want to run the application local, I use SQL Server 2005, and managed to fix connection changes. But now, I get this error everytime I run the application: Microsoft VBScript runtime error Error Code :0x800A01CA Error source : Error Description :Variable uses an Automation type not supported in VBScript Any solution please?
Local Settings
The webserver I'm using (which I can't make any changes to) has a Dutch-localsettings. When doing simple calculations the decimal-symbol in ASP is a , (komma). Is it possible to force IIS to use a . as decimal symbol by code? (IIS5)
Using ASP On IIS (Local Machine)
I would like to evaluate some shopping cart software to use on my next project. I am new to asp and as yet my hosting does not support it. Before I go ahead and upgrade my hosting I wanted to see how the various packages work. I am running XP Pro SP2 and have installed IIS. The folders seem to be where they should be and I have access to the settings through the Administrative Tools. When I put a htm file in the wwwroot folder it loads fine if I type http://localhost but the asp files are either downloaded or opened in dreamweaver. Do I need to do something special to enable asp files to open on my local machine??
On My Local Machine.
I'm not a networking/IT guy, but I was put in charge of figuring out how to use ASP to tap into an Oracle db for my office. I am using a windows 2000 laptop, and I want to be able to run ASP code on my local desktop (without being plugged into a network). I need a lot of help here. I know I have to turn my computer into a webserver, but I'm not certain what I need to do with the IIS. What do I need to do in general to make my computer a webserver? In addition, I will be using a local Oracle database. So I wasn't sure what I would need to do to make that db available for querying with ASP. What is the best way to make that connection? Anyone who can point me to useful documentation.
Code On Local IIS
I am running this code on my local IIS and everything works fine. The code detects the file I select using the INPUT TYPE=FILE. The problem is that when I move this code up to my host’s web server, it never works as in it never finds the file. It is the exact same code so why is it working on my local IIS but not on the web server? It is ASP code. Code: set fso = createobject("Scripting.FileSystemObject") If fso.FileExists (strValue) then 'File exists continue with code Else Response.Redirect("aspError.asp") End if
Local ASP Server
I need to setup my home computer to view ASP files like I veiw PHP files through Apache2Triad or some other similar installer package. I'm using Windows XP Home,is this possible?
Calling A Local .exe
I am trying to set up an internet page on our intranet that contains logoff/shutdown and restart buttons.This needs to work in a remote desktop situation which rules out various options. Next stage is to call this .exe from a webpage...which I'm struggling with. My test code (to test a reboot) is below but doesn't seem to work. Can anyone help remembering this needs .exe needs to run on the local machine and not the server.
Local Web Server
I have a computer running Windows XP home edition and i would like to have a local web server for testing my classic asp pages.
Local Execution
How do I execute a users program from a web page? When a user goes to a webpage - I want a link on that page that will execute a program on the users local hard drive - like say...notepad.exe . Everything I have tried will only execute it on the server.
LOCAL MACHINE
have an SQL DB which clients access via asp pages through the internet, in the case of a power outage I need to write that data automatically in the background to a txt file on their local machine, I would imagine it would involve a script of some kind.
Local Host Id
is anybody know how to capture lan id(localhost id ) address in lan. u can check the same under dos using command ipconfig. but i am not geting the same id using bewlo code <% Response.Write Request.ServerVariables("REMOTE_ADDR") %>
Dynamic ASP Local Variables...
I'd like to create a series of variables created dynamically, example such as this... For i = 1 to 5 TheVariable & i = "blah" Next This would during the first loop create a variable called 'TheVariable1' with a value of 'blah'. Is this possible as so far I'm getting syntax errors?
SQL Express Connection From Local IIS
While I know within visual studio express 2005 it's easy enough to test and connect to SQL Express 2005 database's I ask can standard ASP connect to this also? I will be attempting from localhost IIS as obviously visual stuido does not host ASP sites.
Converting Local Time To UTC
1. I need to convert the local-time of the server on which I run my website to UTC and I don't want to rely on the server local time and timezone (i.e. I don't want to hardcode the timezone information), is there a generic way to do this? 2. Is there a general for converting time between timezones in ASP?
Browse Local Save
How do I allow users to browse their local machine and upload a file to the server? I'm looking for the pop up window that allows the user to search for a file in their local machine. Also, once the file is in the server and the user needs to delete it, how do I do that?
About Testing On Local Computer
I have been teaching myself ASP for several months now and seem to have a pretty good handle on it. All along, I have been uploading changed files directly to the website and refreshing to test. However, today I will be at a location with no internet access and would still like to be able to work and test my programming. How do I go about testing ASP pages on my local computer without an internet connection? For now I am not worried about testing any databases or anything, just layout and design. If it is useful, I am running Windows XP Home edition and I use Dreamweaver to write the ASP.
Getting Size Of A Local File.
I made a image upload a while ago, but too many people submits too large images (this is no problem, since ASP Upload won't upload too large images) but people gets frustrated when their images are not uploaded!I want to do so that you can't submit the form if the pictures are too large. I was thinking of doing a asp functions to check the file size and then pass the result to a javascript function, which will then alert the user and denie him to submit the images.I know how to do the javascript part, but I don't know how to check a local file's size with asp? I'd appreciate if someone could help me! Thanks.
Can't Run Website On Local Machine
I copied one of our websites to a CD and wanted to run the website off of the CD. However, it won't run the index.asp on Windows XP machine. Do I need to install some dll's or something?
Setting Up Local Server?
What is the best way to set up a server with MSSQL on your local machine. I have IIS set up, and am wondering if there is some way to get MSSQL for testing purposes for a reduced cost? From what I understand, a typical MSSQL license is around $8,000, am I right
Local Path Reference
I took over an ASP site and am having trouble uploading pics through the user interface. I get the following message: Microsoft VBScript runtime error '800a01ad' ActiveX component can't create object: 'SoftArtisans.FileUp' /admin/UPLImage.asp, line 15 The line refered to by the message states: upl.Path = "d:htmlusersusernamewebsite.comImagespages"
Logon With Local Accounts
i am developing an intranet area where my boss says he wants the logon to be related to the local accounts,if no local account exist then they will be refused access, i am a little lost with this.
Local Server Error
I am using Windows XP Pro, and since I updated to Internet Explorer 7 I am having problems getting web sites to work on my PC in Internet Explorer using the local IIS web server. These web sites are using ASP and Access databases. The two errors I get are: Operation must use an updateable query or Cannot modify the design of table 'TABLE_NAME'. It is in a read-only database. Does anyone know how I can get this working so I can test my web sites locally before uploading them to the live sites?
IIS 5.1 Local Host Error 500.100
Installing IIS and getting a strange error. ..Error Type: Active Server Pages, ASP 0134 (0x80004005) The object has an invalid ProgID of 'MSWC.MyInfo'. //global.asa, line 1 This error comes after on Page not Found error after entering http://localhost .I have done all the localhost not found suggestions in the localhost not found thread. I also looked up the error in the knowledge base and the Anonymous login was not checked for the localstart.asp file. I also ping 127.0.0.1 just fine.
Viewing ASP Files On Local Machine
I'm using WinXP Professional SP2, I've installed IIS, but am having a problem viewing the temp version of the ASP file IE makes when you go to view an ASP page. So, I hit F12 to bring up IE and my ASP page, IE generates a URL something like, http://localhost/MyWeb/ACEI/TMP91g0dk4dw.asp ... but that always comes back as a "File Not Found" error, however if then I replace the TMP91g0dk4dw.asp part with the actual file name e.g demo1.asp..the page runs fine.
Where Does My Local Cookie Hide And What's It Called ?
I'm running my script locally and the cookie has been saved on the machine because the login page is by-passed (with the Redirect to "menu.asp" below. OK - but where is my cookie stored? Or at least give me clue. What will the cookie be called and what text will it contain if: iAuthorID = 1 iSecurityLvl = 3 uName = "barny" ? The machine user is "flintstone" and machine name is "W2KPro". The CookieName will be "mABmyASPBlog" ....
Enumerate Local Variable Scope
Does anyone know of a way to enumerate the local variable scope? The reason I ask is that I have a function that dumps the contents of response,request,server,etc... for debugging purposes. I'd like to also display the local variables.
CreateMHTMLBody With Local ASP URL Doesn't Work
I have an ASP page that I call on my server, say: http://myserver.com/firstPage.asp In this first ASP page, I want to send a MIME email that has the contents of another ASP page which is located on the same server. So the code looks like: <% Set objCdoMesg = Server.CreateObject("CDO.Message") objCdoMesg.CreateMHTMLBody("http://myserver.com/secondPage.asp") objCdoMesg.To = "me@mymail.com" objCdoMesg.From = "me@mymail.com" objCdoMesg.Subject = "Testing MIME messages" objCdoMesg.Send %> This process will hang on the CreateMHTMLBody() method call. If I move the second page to another server and reference it there, it's fine. If I rename the second page to "secondPage.html" and leave it on the local server and reference it that way (the second page doesn't have any ASP code in it at this point, just HTML), it's fine. It seems like the only time the hang occurs is when the requested file is an ASP page and is located on the local server. Anyone seen anything like this? I'm running on Windows 2000 Server with all the current security updates. Seems like it may be something in the way the process(es) are running.
Allow User To Update Form From Local Dsn
I want to allow users to send information from their local database to my web form. Their local database has a dsn, I am hoping that will help. Basically I am doing this because I do not want them to have to enter information twice. If I can get help populating a form on screen I can take it from there to my online database.
Testing Email From IIS On Local Machine
I have written an asp page that is supposed to send email (using CDONTS). I think my code is correct, but I'm trying to test it from my local machine and although the ASP code runs I am not sure the email portion of the code works. I have not yet received any messages from the code. Perhaps there is a delay of some sort - or perhaps it is because I am on a network behind a firewall. Whatever the case, could someone offer some suggestions in testing the emailing portion of my code? Code:
Detecting Local Account / Domain
Is it possible to use IIS 5.x software on WinXP/2K OS and VBScript to detect the logged in user account. ie, we login with our firstname initial, last name (amartone) as well as the domain the computer resides in? My account is under ITU, so I am ITUamartone. Can ASP detect this? I'm making an intranet app, and I'd rather validate users that way than have them log in over and over.
Setting Local Host Permissions
I download an application from a 3rd party for a forum that uses Microsoft Access. When I try to log in, I keep getting an error about the database being read only. I go to the hard drive and right click and uncheck "Read Only" but it never works, I've done this on the database file, the directory it is in, the parent directory, the wwwroot directory, the Inetpub directory.
File From Local Machine To Server
im trying to create a intranet site which copies files to the server. im guessing i should use filesystemobject to achieve this but im not sure on how to accompish this.
Current Media In Local WMS Server
anyone could assist me in finding an ASP script to find the current playing media in a local Windows Media Services server. Since the particular stream is a broadcast, it will have constantly changing media.
ADSI And Local Windows Users And Groups!
I am looking at the ability for a user on my website to add/remove/edit windows user accounts, thus controlling access to my website. I have integrated windows authentication checked on the website and unchecked anon access in IIS, so I am always asked for a username and password. I have seen some ADSI scripts that I can use in my ASP pages to manipulate local user accounts. However, when I try and use these they dont work as I need to have admin rights. Of course I don't wish to add the user to the admin group for security reasons.... Anyone have a code snippet to do this?
Pulling Files From Local Hard Drive
I am using a file type input box in an HTML form. When a file is selected, the local pathname results. Is there a way to run this form online, and access a file on the visitor's PC from the web? What pathname needs to be used?
Windows Auth With Local User Accounts Or SSL
I have question about whether it is best to use windows local user accounts to authenticate against when logging into a website OR using SSL for any communication sent to and from the web server. I know these are slightly different issues here, but I will explain my situation. Clients will log onto my website and will be gived user access based upon their username and password. Therefore I initially wanted to use windows local user accounts and restrict anon access within IIS. However, I am thinking it would be just as secure to use HTML/ASP webpage and database access to the website, as long as the data was encyrpted.
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?
Copy File From Local Comp To Server ?
how can I copy a file from local disk to windows server using ASP (not asp.net)? I have a control file on my web side, <input type="file" name="file1" /> I choose file on local computer and what function must I use to copy this file to server ?
Save A File From Remote Location To Local?
Is there a way to save a file from a remote location to my local computer with asp? Let's say as an example that I would like to save a file from http://www.somesite.com/file.txt to c:file.txt on my pc using an asp page located either on one of the two locations?
Opening A Local File From A Hosted Link
I'm working on a document management app that saves scanned docs as PDF files in a local directory, then saves document metadata in an Internet-based SQL server. The SQL server is then queried to retrieve document info and links are created that point to the files. The code points to the proper local directory and file, but I can't get the browser to open the document in a target frame. If I open a test doc locally it works fine.
Copy Local Directory To Network PC Problem
After months of developing an Intranet Site on my local machine, the company has finally set up their webserver. I have just transferred the ASP pages, SQL Databases, etc. and am testing the application. Really annoying if you ask me. However I have run into an issue with an application that was developed. Here's the background, sans code ... not really an issue now. I had an upload page (using freeaspupload) that the user would upload a .DAT (delimited text file) file for insertion into a table (which BTW, works great), but along with this it would go out to another directory and grab a text file that was also inserted into the table along with the other data (this text file is a declaration of sorts). Working on my Local PC (running IIS and containing the files/directory), this processed worked miracles. However, since it was moved to the actual webserver, I get 'File could not be opened.' , which I know means that the directory and file I'm sending the script to doesn't exist on the server (c:dir1dir2ext1.txt), it does, however, exisit on my local machine, so the ASP Page doesn't run. What I need to know, is there something I can run, through an ASP Page, that will copy the directory from it's current location to a directory on the network where I can then have the script point to to get the txt file needed to be included in the insert for the record. I know I can point this line: Code:
Write Text Files To Local Machine
I need to know how to write a text file to a local machine. Here is my code: Set myFSO = Server.CreateObject("Scripting.FileSystemObject") Set WriteText = MyDrive.CreateTextFile("C: est.txt", True, False) Right now it writes the file to the C: drive on the server.
Copy File From Local Machine On Server
I have one .asp page with form and <input file> field on it.I want to copy selected file from local machine on server.But it doesn't work. Should I use some component?
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.
|
TRACKER
