I'm current working on a project which need to upload local data to
live server database.
Meanings that, i'm current having a server in my local mechine. I need
upload data from local database to live database which host at oversea
company. But i really have no idea how to do this in asp.
I want to export data from SQL Server Database to Access Database through ASP code.
Will it be by running some sort of a batch file?The database structure of both the databases are the same, only there are 3 fields more in the SQL Server DB than the ACCESS DB which need not be exported.
Does anyone know how to export data from an excel spreadsheet, straight into ms sql server database?
View Replies View RelatedIs there away to write data from a database field into a text file on the server.
The data would be more than one line.....
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?
point me to resources that explain how to import/export Quickbooks data to/from an Access database? I tried posting in the db group but got no response. Maybe I worded it wrong the first time.
View Replies View RelatedHow it possible to export sql database to excel worksheet?
View Replies View RelatedI have a client that wants to export their database to excel from their admin section on their website.
Is it possible to export a MySql database using asp code?If so is there sample code that i can look at? I haven't found anything on the net that works or is usefull in any way.
I have googled all over the place to get an answer so I'm hoping there some guru's here that can help. I do a search on my database and return a recordset which I page the results at 10 per page. The data is such that the smallest possible recordsets are around 100 records and the largest could be up to a few thousand.
I want to be able to export the results to excel but give the user an option to export the current page or the entire recordset. Maybe i'm battling with the logic which is messing the code up. I'd post some code here but I'm not sure whats useful or not and likeI said, I've been fighting with this so its a bit of a mess.
At the moment the user goes from the results page to an exports page that has a form on it that processes the export. Well it doesn't work but thats the idea. How do I pass the recordset and its page size to the export page so that if the user had browsed to page 9 for example and wants those 10 records?
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 work with ASP for several weeks now and i really like it! But until now i have just used it in connection with my localhost. I made connections to a SQL Database and to an ACESS Database with using the ODBC Tool from WIndows!!
Now i want to publish my website but i don't know how to handle the connection string kind of thing. My MySQL-Database is on a different server than the website and i need a connection string where i can type in the server, a password and a username and it should then connect.
I have created a form that sends email thru my local server. What I want to do is send the email thru our corporate Exchange server. Does anyone know how I can accomplish this task? Please advise. Thanks.
P.S. I’m using Dreamweaver MX2004.
The code that sends email is shown below ....
I have a master table called ad_dump. ad_dump is an Active Directory dump of 20,000 users across the domain. I capture user's logon to filter ad_dump on department so only user's department personnel show.
This ad_dump will supply data for many databases. Therefore, each application requires a user to "choose" which personnel belongs into a local application(personnel). Personnel choice is the ad_dump of personnel of logged on user's department. The user selects choices by checkbox and submits.
How can I collect the form's hidden values and have them inserted into another database? I assume I can use the form collection object but I cannot seem to figure it out. Code:
How to get the last row of data from database which is integer value by using ASP?
View Replies View RelatedI am using a ASP page(User_Account.asp) to create username and password & updating the info into the database through another ASP page(User_Account_Upload.asp).
The problem I am facing is that, at random instances the data gets duplicated. I tried to check if the user Id exixts in the database before updating. After implementing this logic, whenever I create a new user, if the ASP page tries to store the username for the 2nd time, it generates an error message that the user_id exists and doesn't update the database. However, this error message is displayed on the screen even though the user_id was created for the 1st time ....
I want to display a system maintenance notification on my webpage using a splash screen. I got the code for splash screen from Dynamic Drive and added it on my web page. Now here is my problem. I have created a table in my SQL database with these two fields, Flag and Description. I am trying to connect this splash screen to this table.
This is because-if the flag is set to 1 the splash screen will pop up and display the data in the description field on the splash screen and if it is set 0 the screen will not pop-up at all. Two things I am having trouble with-
1. Displaying the data on the splash screen. I made the connection to my db but can't get it to display it on my splash screen.
2. How to make the splash screen pop-up only if the Flag field is set to 1.
Here's my scenario: I send an email to my customers which contains an embedded URL with a recordnumber within it. What I want to do is create a variable for the recordnumber, write a select statement against my database using the variable as the argument for the WHERE clause, and display the results of the SELECT (its always a single value) within an HTML page.
Here are snippets of the code. The recordnumber is represented by strCallID and the resultset that I'm trying to display is strATG (shown near the bottom of the HTML)
All the connection string stuff has already been taken care of, so that's not included in this code:
I'm using Dreamweaver MX with ASP VBScript and using a MS Access Database. For about the longest time now, I've been trying to make a Mailing List form online and when you submit the data, [data] goes into the Access Database.
The Form is obviously working fine, although sometimes I do get errors, I'm mainly trying to get this data skullduggery working. Is that even possible (with ASP even)? I have to use ASP and I can't use SQL (because I would), but I think my n00b self has tried everything I could think of. Code:
i wanna check one cell value from database and then if cell value is 0 than put this image in the dynamic table, if it's 1 than put other image to dynamic table, and so on Code:
View Replies View RelatedI have a page that allows users to sign on and then have access to the site. What I need to do is to have them sign on and see selected (tables) or data that is in the database.
I need some help. How would this be written. Unfortunalely the only book I have on the subject is asp.net. Code:
I on my site i have a form that users fill in, once they have filled it in, they are then redirected to a preview page. All this is fine.
Then users get redirected to a secure third party that takes all the customers credit card details and checks them all.
If they are all authorised then it will the go back to my page to confirm that everything is ok and that their information has now been added.
What the problem is that i can not carry the information through the secure servers pages and what I need to do is basically get the user to fill out the form have it inserted to the database, then they pay for it, If all ok i want to be able to insert a "confirmed" into the payment field for the advert that they have placed or if it fails for it to say "awaiting payment" in the payment field and a message on the screen to tell them to contact sales team.
I have a site and im trying to make a create account page for users to create an account. Unfortunately after getting everything working right i find out that for some reason the code is not adding the users to the database, i have double and even triple checked my sql connection string im at a complete and total loss Code:
View Replies View RelatedI have 2 textboxes. In first text box i need to enter name, the second text box shud be automatically filled with the person'd id.
Both the name and id is coming from database. I tried using this code, but i'm getting error saying System.NullReferenceException: Object reference not set to an instance of an object. at line 1 Code:
I want my users to be able to update their data(they store hours spend in different courses per week) stored in the Access database. So far they are able to update only one record(i.e. for only one week).....all they do is search for their records using their User_Id and click the WeekNo they want to update.
when there are (e.g. WeekNo1, WeekNo2.....) the user can only update data for WeekNo1 and when they click WeekNo2 the link takes them to WeekNo1 data.Please guys I need help cos I've been trying so hard to figure out what might be the problem and failed.
How to use the for loop to display all the data in database? For example, displaying the data that start with "a".
View Replies View RelatedI have a database which consist of these field:
[Room,Subject,Time,Day]
When the admin enter data to the form, the data will go to another page and will be displayed in a classtimetable form,according to the time, day and room number. i am using Macromedia Ultradev 4 to develiop this page. what i want to do some programming here is.. when the admin enter the data,
1. Room and Time can be same, but in different Room,
2. Room and Time cannot be same(with previous data) in the same Room,
how to code this?
I have been thinking about storing some data, which my users upload, in text files rather than database, since often I do not know how much information users submit for things like item description or images URL paths.
This information may be very short or very long. MS SQL Server requires a maximum field length to be set. Thus, if user enters 5 characters into 5000 character field, a lot of space will be wasted. On the other hand, the database reference would point to the text
files to read users' data and display it on page.
I’m in the middle of designing a simple website poll... nothing to fancy a simply question and results type thing... however I’ve hit a problem in that I cannot figure out how to add one to the running total when a vote is cast. For example:
Do you like this website:
A: Yes Lots – radio button if selected adds one to yeslots column
B: It’s ok - radio button if selected adds one to Itsok column
C: It could be improved - radio button if selected adds one to Itcouldbeimproved column
And of course we’re using an Access database for this one.
We have a server for our intranet and one that has this MS Access mdb database we need to use.So basicly we want our intranet asp page to show data from a database located on another computer in the same lan.
For some reason we can not use the database from the intranet computer.
We've tried so far:
-Direct approach with mapped drive
-Direct lan address.
-Linked access database on the intranet computer.
-Modifying user rights.
When one of these solutions are viewed on the intranet server, they work fine. When tried from client computers trough the intranet, we get error of thiskind:
Error Type:
Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file 'M:TSTOITProject databasedata.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
/intra/db.asp, line 24
I am submitting data to a database field, and the data is being submitted in the following manner to a table in the database:
5,3,4,4,3,3,4,5,4,5,5
It's all comma delimeted. Now, what I would like to do is have an update page in which a user can update these values. I am trying to place the values in a repeated text box that corresponds with a repeated question.
The questions that I am displaying are in a repeated field and each question has a text box that will hold the value that corresponds to. I would like to be able to bring in each value into a repeated text box. Right now, each repeated text box contains the above information. (5,3,4,4,3,3,4,5,4,5,5). Is this possible?
i've got a database in ms access. using ASP (vbscript) and IIS. I can send text e-mails through ASP but i want to attach a file from the database to the e-mail when it is sent. can anyone give me any hints on how to get the data from access, attach it to the e-mail and send it on?
View Replies View RelatedI don't know if this is possible, but I have been amazed at what I have
learned from this group so I will throw it out there.
I have an MS Access database that I connect to through .asp pages. Can
I offer a user of my page the ability to export data from the Access
database (either feeding of a table or a query) to their hardrive in an
Excel format?
If it is possible, I have two followup questions.
1: Can you export in additional formats (Access, Word, Notepad, ...)?
2: Can you do this if connecting to a SQL server?
I have application form in ASP and I�m using a code
which I have use many times before and when I fill out
the forms it doesn't return any errors so it works perfect I guess.
Anyway... when I download the database (Access mdb)
back to my C: and open it a new line of record has been
created but all the fields are empty and no data.
Does anyone know what can be wrong or what are the
possibilities?