Are you trying to view the data or simply give a user the ability to download the data into a particular format via a ASP page.
Main Topics
Browse All Topics
Loading Advertisement...
Question
In need of ASP Pages to extract data from SQL 2000
I am in need of some ASP pages to be developed to extract data from a SQL 2000 database through my web page. I'm not sure how ,much work is required to do this so I am really just asking a general question. I do not know how to do this nor do I know where to start. Can someone point me in the right direction. Would I waste too much time trying to do this myself or is it pretty easy to pick up on? Thanks in advance for your help.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Subscribe now for full access to Experts Exchange and get
Instant Access to this Solution
- Plus...
- 30 Day FREE access, no risk, no obligation
- Collaborate with the world's top tech experts
- Unlimited access to our exclusive solution database
- Never be left without tech help again
Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.
- "The time we save is the biggest benefit of Experts Exchange to Warner Bros. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange." Mike Kapnisakis, Warner Bros.
- "Our team likes having a resource that is more secure than just using Google and most experts using this service really know their stuff. It's nice to look here first versus using Google." Dayna Sellner, Lockheed Martin
- "Anytime that I've been stumped with a problem, 9 out of 10 times Experts Exchange has either the accepted solution or an open discussion of the potential solution to the problem." Kenny Red, eBay Inc.
See what Experts Exchange can do for you.
Got a question?
We've got the answer.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
Need individual assistance?
Our experts are ready to help.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Want to learn from the best?
Read articles from industry experts.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Working on a long term project?
Store your work and research.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
What Makes Experts Exchange Unique?
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Trusted by the world's most respected brands.
Faithfully serving IT professionals since 1996.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Free Tech Articles
-
WARNING: 5 Reasons why you should NEVER fix a computer for free.
It is in our nature to love the puzzle. We are obsessed. The lot of us. We love puzzles. We love the challenge. We thrive on finding the answer. We hate disarray. It bothers us deep in our soul. W...
-
SCCM OSD Basic troubleshooting
SCCM 2007 OSD is a fantastic way to deploy operating systems, however, like most things SCCM issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispe...
-
Migrate Small Business Server 2003 to Exchange 2010 and Windows 2008 R2
This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Windows 2008 R2 with Exchange 2010. For this migration to work you will need the fo...
-
Create a Win7 Gadget
This article shows you how to create a simple "Gadget" -- a sort of mini-application supported by Windows 7 and Vista. Gadgets can be dropped anywhere on the desktop to provide instant information, ...
-
Outlook continually prompting for username and password
There have been a lot of questions recently regarding Outlook prompting for a username and password whilst using Exchange 2007. There are a few reasons why this would happen and I will try to cover t...
-
Backup Exchange 2010 Information Store using Windows Backup
There seems to be quite a lot of confusion around the ability to backup Exchange 2010 using the built in Windows Backup feature. This stems from the omission of this feature prior to Exchange 2007 s...
Cloud Class Webinars
- Avoiding Bugs in Microsoft Access
Alison Balter takes and in-depth look at avoiding bugs in Access. In this webinar you will learn about using the immediate window to debug your applications, invoking the debugger, using breakpoints to troubleshoot, stepping through code, setting the next statement to execute, ...
- Top 10 Best New Features in Visio 2010
Scott Helmers gives live demonstrations of the top 10 new features in Visio 2010. This webinar will teach you how to create compelling diagrams by adding shapes to the page with a single click, linking the shapes in a diagram to data in Excel (or SQL Server, or SharePoint), ...
- IT Consultant Business Secrets Revealed
Michael Munger, Experts Exchange tech pro and IT consultant, pulls back the curtain on his very successful businesses and answers question on every IT consultant and business owner should know about. He shares secrets on what he did to solve the 5 most common problems in IT, ...
- Disaster Recovery and Business Continuity
Quest CTO, Mike Billon, gives an overview of the steps involved in building a dunamic disaster recovery plan. Through case studies and an examination of software/hardware tooles for monitoring and testing, you'll gain a better understandin of where you are, where you want ...
- Organize Your Visio Diagrams with Containers and Lists
Scott Helmers uses cross functional flowcharts, wireframe diagrams, data graphic legends and seating charts to teach you: how to ustilize all three new structured diagram components in Visio 2010, the best practices for organizeing shapes in previous version of Visio, how to organize ...
- How to Us Objects, Properties, Events and Methods in Microsoft Access
Alison Dalter gives an in-depbth look at objects, properties, events and methods in Microsoft Access. In this webinar you will learn about using the object browser, referring to objects, working with properties and methods, working with object variables, understanding the ...
Join the Community
Give a Little. Get a Lot.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Answers
Three questions.
1) do you know VB or VBscript or any programming languages at all?
2) do you know HTML design?
3) Do you understand what Active Server Pages(ASP) do for you?
If you know 1 and two then I'd say it's easy to pickup on
If you don't know one or two, then you'd be wasting time, unless your intent is to learn ASP development.
Thanks for the quick responses. I do not have a strong desire to learn ASP unless I have to. I do not know VB script and I’m not strong on HTML either. My current Web host coded the ASP pages for me, but since I am leaving them and going to move my web page to my ISP they will not give me the code.
I have customers access their carrier data through my web page via ASP. They only pull their data based on a 4 letter carrier code. I am only pulling data from 3 tables in one database and on my other web page I am pulling from 5 tables, but it’s basic shipment information. I’m not doing anything exotic or doing calculations.
Ok that said, you might find someone here who could "help you" develop what you need. Or, you might be better off finding someon to do the coding for you. It doesn't sound like it would be that difficult; I'd suspect no more than 2- 4 hours of actual work assuming.
1) you can provide the DB information
2) the table structure
3) what you want to do... Just display... save.... edit... what. since you said extract, I assume just a report or two...
After writing this up I realized it might be too much work for you to even think about trying to do , but here it is anyway for you to take a look at.
Each carrier has a uniqure carrier code called 4ltrcode and a password to access the database.
On my webpage I have a login screen where the Carriers put in their carrierinfo.4ltrcode and their carrierinfo.password. Once they have been authorized access, another page comes up where they can view a shipment by Shipment.GBL or Shipment.LName or you can press the Import or Export button to see all shipments in the pertaining category. If you depress the Export or Import button a prompt is displayed for you to select the year. Right now the default is 2003.
There are 2 seperate sections that people extract data out of my SQL tables. There is an Export section and an Import section.
EXPORT
Export jobs are displayed under an Export button where Shipment.JobType = Origin and Shipment.4ltrcode = the 4ltrcode selected on the login screen.
There are 2 parts to each section, summary and detailed.
The summary section consists of the following fields:
Shipment.GBL GBL
Shipment.Lname Last Name
Shipment.LoadDate Loading Date
Shipment.OrCity and Shipment.OrState Origin Location
Shipment.DepDateWhse Departure Date
Shipment.DnCountry Destination
Shipment.RDD RDD
If a carrier wants to see the details on one of the shipments that is displayed, then they just click on the GBL field which then takes them to the details of the shipment.
The detail section consists of the following fields:
Shipment.GBL GBL
Shipment.LName Last Name
Shipment.FName First Name
Shipment.HPhone Home Phone
Shipment.WPhone Work Phone
Shipment.SIT_DateIn SIT Date In
Shipment.SIT_DateOut SIT Date Out
Shipment.CodeofSVC Code of Service
Shipment.Weight Weight
Shipment.LoadDate Load Date
Shipment.#ofPieces # of Pieces
Shipment.OrAddress Origin Address
Shipment.OrCity Origin City
Shipment.OrState State
Shipment.OrZip Zip
Shipment.ORCountry Origin Country
Shipment.DnAddress Destination Address
Shipment.DnCity Destination City
Shipment.DnState State
Shipment.DnZip Zip
Shipment.DnBase Destination Base
Shipment.DepDateWhse Departure Date at Warehouse
Shipment.TruckingCo Trucking Company
Shipment.RDD R.D.D.
Shipment.DeliveryDate Delivery Date
Shipment.SIT# SIT #
Weight Ticket
Warehouse.Cube Cube
Warehouse.Gross Gross
Warehouse.Tare Tare
Warehouse.Net Net
Density - this is a calculated field (Shipment.Weight/Total Warehouse.Cube) Density
IMPORT
Import jobs are displayed under an Import button where Shipment.JobType = Delivery and Shipment.4ltrcode = the 4ltrcode selected on the login screen.
There are 2 parts to each section, summary and detailed.
The summary section consists of the following fields:
Shipment.GBL GBL
Shipment.Lname Last Name
Shipment.ORCountry Origin Country
Shipment.ArrDateWhse Arrival Date
Shipment.RDD R.D.D.
Shipment.DeliveryDate Delivery Date
Shipment.SIT# SIT #
If a carrier wants to see the details on one of the shipments that is displayed, then they just click on the GBL field which then takes them to the details of the shipment.
The detail section consists of the following fields which is exactly the same as the Export section:
Shipment.GBL GBL
Shipment.LName Last Name
Shipment.FName First Name
Shipment.HPhone Home Phone
Shipment.WPhone Work Phone
Shipment.SIT_DateIn SIT Date In
Shipment.SIT_DateOut SIT Date Out
Shipment.CodeofSVC Code of Service
Shipment.Weight Weight
Shipment.LoadDate Load Date
Shipment.#ofPieces # of Pieces
Shipment.OrAddress Origin Address
Shipment.OrCity Origin City
Shipment.OrState State
Shipment.OrZip Zip
Shipment.ORCountry Origin Country
Shipment.DnAddress Destination Address
Shipment.DnCity Destination City
Shipment.DnState State
Shipment.DnZip Zip
Shipment.DnBase Destination Base
Shipment.DepDateWhse Departure Date at Warehouse
Shipment.TruckingCo Trucking Company
Shipment.RDD R.D.D.
Shipment.DeliveryDate Delivery Date
Shipment.SIT# SIT #
Weight Ticket
Warehouse.Cube Cube
Warehouse.Gross Gross
Warehouse.Tare Tare
Warehouse.Net Net
Density - this is a calculated field (Shipment.Weight/Total Warehouse.Cube) Density
Thanks for taking a look.
Bill
Whoa.... Ok, it's not a simple reporting mechanism. As you stated
"After writing this up I realized it might be too much work for you to even think about trying to do "
Its not that I don't want to help, its that people get paid for this kind of thing. This is a little above and beyond typicall help offered by people here. I'd estimate that this would take me about 8-12 hours to rough out and another 2-4 hours to finalize (excluding all graphics and layout junk)
So, if I were you, I'd look at finding a web development company near you that can do this for you. I'd go that route for a few reasons.
1) Faster app dev time (than what you could do)
2) More robust code (they say they can do it, hold them to it)
3) What you've roughed out will be EXACLTY what they want as requirements. Make certain you've covered EVERYTHING you want. Client side validation on dates, security using (or not) SSL. And much more. Make sure that you don't get burned again. (eg. you get to KEEP the code regardless of where its hosted) The company I work for by policy does not Own the code, we are just developers who we work for is the group that owns the resulting code)
4) It promotes you in your community.
5) Now, you might be able to find someone who will do it for low cost, but think about support. etc.
Sorry I can't be of more assistance but I can't imagine spending 8+ hours on one question.
Luke_davis is right, usually alll of these questions are answered off the tops of your head. If you need to out source this I would recommend you do a search on the net. I found a website called www.Gonzalezconsulting.com
3 Ways to Join
Business Accounts
- Perfect for organizations
- Multiple users
- Save over 36%
- Create a Business Account
Answer for Membership
- Earn free access
- Showcase your knowledge
- No credit card required
- Sign Up to Answer
Loading Advertisement...
by: iuhhPosted on 2003-07-15 at 10:41:37ID: 8927489
Try this page:
http://www.w3schools.com/a
Basicly you would need to use ADO to access SQL databases. That page would give you some ideas of how to.