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.
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?
i m developing General Ledger application in asp.my company is located head office at south and is branch office in west so i have to developed an application that data related to south they can post there data.so as well as west.now problem is that what techniquei should use.
In my opinion i can create administrator login form where person in south can log on with it and enter his data while same as person in west. or what should i use.
We have an IIS+ASP based application server that is capable of providing complex reports to hundreds of users but in some circumstances these reports can take a long time to create. However the data for the report is cached so subsequent calls to view the same report come back with a sub-second response time.
In order to make use of this caching we pre-prepare some of the reports by getting back a list of potential users from the server and then executing reports on their behalf. When the real users log in the report is served from the cache.
I wrote the warm caching application using VB6 and it uses XMLHTTP requests to execute the reports. However because ASP serializes the requests to the server the application can only have a single session open with the server. To get round this I spawn multiple instances of the application, each instance then has its own ASP session and the server is loaded more efficiently.
The question is how can I create multiple ASP sessions from within a single VB application and have each session handle its own XMLHTTP requests? Its obviously possible as MACT, OpenSTA and LoadRunner all achieve it.
what mean of this application is hosted by multiple processes on the same server When an application is hosted by multiple processes on the same server it is said to be a web garden environment.
I have developed an ASP web application. If I sell this out to my client, how can I make sure that he doesn't run multiple copies of it. That is when I sell the web application my client should be restricted from running more than one copy.
We have our web-site developed in classic ASP, and I need to add this additional feature on one of the pages to access a VB application. How can I do that? The VB application basically sends output to the COM3 port and opens a USB-Cash drawer that is attached to it. I am not sure how to go about with this.
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.
I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.
If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews headline content
tblDatabank filename description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
i hav problem with updating the data. In the asp page i hav displayed records based on search criteria. in display mode im displaying the to be updated field in combo box for each similar contract_no. each contract_no will hav different no of rows and to be updated combo box.
based on the selected value in the combo boxes of different contract_nos i hav to update the combo value with old value. user select multiple combo values at a time I need anybody's help with detailed programming logic.
Sometime this morning our classic asp web application stopped authenticating against active directory. This is our only "classic" asp app that authenticates against ad. Note that this app has been in production for three years with no problems. All .NET apps are authenticating fine from the same server. This same classic asp app authenticates fine from our development server. There have been no code changes to this app. We're using the login id and password to bind the necessary ad objects - we check for err.number - if equal to zero, we're authenticated, if not equal to zero then authentication failed. We checked with the network people and they say ad is working fine and the server is able to authenticate. The app doesn't go through a firewall -so no hang up there. The guys who manage the web server say they haven't made any changes to it. They confirmed that the app is in the correct app pool so it doesn't conflict with 2.0 apps. I'm stumped.
I remember coming across a MS tool that would allow me to monitor the performance of all aspects of a DNA based application - all the way from the ASP level to MS SQL server. It was part of the NT resource kit. I am trying to locate this tool for Win 2000. Can someone who has come across such a tool help me
I've just been given some code to decipher in classic ASP and have come across this function (Application()) in several instances. I can't seem to figure out what it does?
I am about to create a web application using asp and vbs to build an online roster for a department of 25 people. The roster covers some 10 shifts a day, 7 days a week always starting on a Sunday. I will be using an access database file to hold the information. At this this stage I will hold all the data for each week based on the date that the week starts. I am looking for ideas on how to dynamically give the user the option to choose any given week in any given year, always starting on a sunday. Could this be created on the fly or would it be easier creating a database table holding the dates for Sunday for a year or 2 ? Once a week is chosen a check on the database will determine if that weeks roster has been created or not. If not a user with the correct permissions can then create it.The rosters are currently written out by hand. It is a labourious task which must have certain numbers of staff working each shift for a given day. By creating a web application automating the checking process and making the roster available online and by email will make life easier for all staff involved.
i am trying to install my ASP web application to my client side server, but 1 thing i am worry is they my stole my source code to sell-over or they might modify my source code... how those software house which develop ASP web application they gonna avoid this?I know Microsoft have a program that can encrypt & encode ASP files and run properly in IIS.... But to bad... i also found the Decode program too So what is the safety way to deploy my application to client without any worries? Some might ask me go for .NEt, in this momment not yet toward .NET.
I am trying to develop an ASP.net application using Visual Studio .Net 2003. When I attempt to create the project, it gives me an error stating that the IIS on my hosting server may not be compatible and the active directory cannot find the web server. The server is running Windows 2000, IE 5.5. Is there some sort of patch I can download to allow me to create ASP projects on that server? Or something I should install?
I am trying to set up a fax ASP web (or vb 6) application and I want to use the FaxComEx.dll library that comes with winXP fax services. But I cant find documentation about this library.
I found something in msdn but it is very dificult to watch the logic that appeared. It's very confusing. Is there something else that can I rely to learn how to make a fax application?
I have a client that wants to have ticket system on their web site where people could order a ticket online and after they send their payment to paypal they would be redirected back to the web site and have a unique ticket that they would be able to print out the ticket but they cant be the same ticket to prevent people from printing out the same tickets. Is this possible? Is there a program?
create a user subdirectorie with a webpage that he o0r she can fill with there own logo and with some text,perhaps a link but just one page.That page must automaticly come up in a link page so people can see his page.
Thing I want to have is a way that our customers, that dont want to pay for a a bigger website,can have just one page on our website in there own subdir.
I see lot's of free csm style websites but that's to time consuming for people that want just a simple page with just there logo an advertising and some info.
I am building a web reservation system for a hotel. I'm working in the hotel as a manager as well. Hotel has 18 rooms and 4 Suites. Now it is my first time with such application. I planned to use ASP and Access DB. Can anyone give me ideas of basics. How to start and what an application should look alike. This is nonpaid project so i cannot actually go somewhere else except looking into forums and i can find anything.
Functionality will be, for user, gives dates, no of people and search, select room and pay. backend will be process payment(i have one processor), store it in db and generate email for the reception. Managing will be set availability, review availabity and set prices individually for the room. how the database should look alike and what will be the search criteria.
I need to build a web application based on user's rights (roles) web interface where each user has his/her own web page depending on their user role.It is a web application that is based totally the user needs Could you please give me some insite on where to begin.
On my local sandbox , in IIS I created some Websites. Now when I try to create a ASP.NET we app , it tries to create it in the website last created and fails .
But my requirement is to create it in the Default We Site mapped to C:Inetpubwwwroot
Can anybody guide me how to do that? I have a doubt that when a new website is created in IIS , it becomes the Default web site . If it is so how to revert the default back to 'Default Web Site'
You are required to create an online tracking system for the Webmaster which should show the current online status of all the users currently logged on to your site with the following details about every user:
SessionId Current Page requested Time of request Browser used for making the request
If a user remains inactive for 10 minutes, then it should be assumed he is not online. You are not supposed to use any permanent storage features.
you know when you have a browser based application (written in ASP or whatever), which uses a database, how can you ensure that the username and password of the database is secured? My ASP application has got a file containing all the information you need to connect to the SQL database, if anyone happens to get hold of that file on the Web server then he'll be able to do anything he wants.is there a safer way to handle this?
I am creating a scheduling application like that of what Mcdonalds' uses.The screen shows which cars are in need of services in which they were entered into the system. The application will refresh and show the mechanics, which car arrived first for an oil service. Does anyone have any demos, samples, or examples of something like this? This is my first full-fledged ASP application and I need some help getting started.
