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.
View Replies
ADVERTISEMENT
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 Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
Im trying to detect multiple logins...
Im using a application object in my global.asa, for some reason it doesnt seem to work. here is my code
<script language="vbscript" runat="server">
Sub Session_OnStart
Session("LoggedIn")=0
End Sub
sub Application_OnStart()
Application("Logged")=1
End sub
</script>
In my pages if i print the Application("Logged") value, it does not show....
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
I am Geting the Error "Application uses a value of the wrong type for the current operation in one of my asp pages"
VB Method
oCMD.Parameters.Append oCMD.CreateParameter("@CustNo", adDecimal, adParamInput, 9, intCustNo)
oCMD.Parameters("@CustNo").Precision = 9
oCMD.Parameters("@CustNo").NumericScale = 0
For adDecimal Data Type Should i have to set Length as 5 instead of 9.
Is this causing the above or something else ?
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
My web application i need to view it on the palm. Backend is SQl and front end is ASP
How do i make it work on the PALm
View Replies
View Related
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.
View Replies
View Related
I am developing a web application that will allow user 3 trials to login with the correct password and user name.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
how i can run the command prompt from an asp application?
View Replies
View Related
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'
View Replies
View Related
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.
View Replies
View Related
Is there is any way to use SQL OLAP in Web application .IS possiable
View Replies
View Related
I need to create an online email application which will receive and
send emails from given accounts using ASP.
I am aware that I can use ASP components such as ASPEmail or
ASPSmartMail to send messages, but have no idea how to receive emails.
I read somewhere that CDONTS may help, but my provider has disabled
these on his server.
View Replies
View Related
When I use the Excel.Application object in window 2000 Advanced Server,
I have the following issue
'------------------------------------------get excel template file
'create excel application
Set xlApp = server.CreateObject("Excel.Application")
'open excel file
Set xlbook = xlApp.Workbooks.Open(targetFile)
xlApp.Workbooks.Open(targetFile) will create a shortcut under the C: etc.
So when I open as many as files, the shortcuts under c: are so many.
How could I avoid create the the shortcuts under c:????
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
