Wrox Programmer Forums
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. 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 Databases 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
Old July 21st, 2005, 04:25 AM
Registered User
Join Date: Jul 2005
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Settings to a simple access to a SQL database

I am learning ASP.NET and I am interested in developing web applications that read/write on SQL databases.

I am using Windows 2000 service pack 4, Microsoft SQL Server 2000 and Microsoft Visual Studio.NET 2003.

I need to TEST the C# code that access, read, append, etc information from and to a SQL database.

In this early stage, I need to know what is the SIMPLEST and practical way to access a SQL database just for the purpose of LEARNING C# and ASP.NET.

Is it the method “ASP.NET to SQL Server” ?

What changes should I make in the default machine.config and web.config ?

What settings should I make in a given database through the SQL Server Enterprise Manager ( Users, Roles, etc ) ?

What parameters and how should be set in SqlConnection("server=;database=someSQLdatabase;tr usted_connection=; etc) in the C# code;

Should I make any specific changes in the IIS settings ?

Is there any other places where I should change settings ?

I would be very grateful to whoever helps me on that.

Similar Threads
Thread Thread Starter Forum Replies Last Post
how to sql database access two table ants Beginning VB 6 1 September 21st, 2008 12:33 PM
Blog - Web.Config Settings for Access Database kanzeon4 BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 3 April 5th, 2008 07:46 AM
Save simple record via web form t sql database kbarsi VB Databases Basics 1 January 30th, 2005 11:29 AM
database settings frankv25 ASP.NET 1.0 and 1.1 Basics 0 August 18th, 2004 07:59 AM
Allow SQL to update an Access database levinho Classic ASP Databases 7 November 11th, 2003 08:32 AM

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