Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Professional For advanced coder questions in ASP 3. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old February 23rd, 2004, 10:35 PM
Authorized User
 
Join Date: Nov 2003
Location: Phnom Penh, , Cambodia.
Posts: 44
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to eapsokha
Default How to use ASP and MS SQL 2000

I want use ASP with SQL 2000. How can I do that by using ADO? And what should I do if I want to host my SQL database to the remote web server?

Many thanks

__________________
Mr. Sokha Eap
Webmaster
UNDP Cambodia
  #2 (permalink)  
Old February 24th, 2004, 12:27 AM
planoie's Avatar
Friend of Wrox
Points: 16,481, Level: 55
Points: 16,481, Level: 55 Points: 16,481, Level: 55 Points: 16,481, Level: 55
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2003
Location: Clifton Park, New York, USA.
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

This is kind of a broad question. What is your familiarity with working with databases, ASP, ASP with databases? There are loads of tutorials online about basic database ASP pages and plenty of books on the subject.

Regarding the remote web server: do you mean you have a web host for your site and want to have SQL support? You'll have to make sure your web host supports SQL2K.

Peter
------------------------------------------------------
Work smarter, not harder.
  #3 (permalink)  
Old February 26th, 2004, 11:59 PM
Authorized User
 
Join Date: Nov 2003
Location: Phnom Penh, , Cambodia.
Posts: 44
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to eapsokha
Default

While I am encoding, I use ADO to connect SQL database. So how can I export SQL to be used in the remote server?



Similar Threads
Thread Thread Starter Forum Replies Last Post
How Run .sql Script file in MS SQL Server 2000? aarkaycee SQL Server 2000 5 October 12th, 2009 05:43 AM
SQl Injection through ASP and MS SQl 2000 cancer10 Classic ASP Databases 1 October 27th, 2007 03:21 AM
Database migration MS Access 2003 to MS SQL 2000 ayazhoda SQL Server 2000 3 April 23rd, 2007 11:38 AM
Isolation IN MS SQL 2000 Israr Pro VB Databases 0 October 31st, 2005 10:58 AM
MS SQL 2000 & ASP Adam H-W Classic ASP Databases 3 August 22nd, 2005 07:58 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.