Wrox Programmer Forums
|
BOOK: ASP.NET Website Programming Problem-Design-Solution
This is the forum to discuss the Wrox book ASP.NET Website Programming: Problem - Design - Solution, Visual Basic .NET Edition by Marco Bellinaso, Kevin Hoffman; ISBN: 9780764543869
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET Website Programming Problem-Design-Solution 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 January 2nd, 2004, 12:05 PM
Authorized User
 
Join Date: Sep 2003
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to cjcd
Default Database use

I know this application has been designed to work with SQL, however, somewhere I read it could be used with MSAccess, is this possible? If so, how can I create the tables in Access? And where are the configuration files where it specifies the database routing?

Thanks.

 
Old January 2nd, 2004, 12:19 PM
Authorized User
 
Join Date: Nov 2003
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The database connection strings are in the module config files
in <wwwroot>\ThePhile\Config

I guess you could use the ODBC provider, but you'll also have to change the Base DbObject class to work with the DbClient namespace instead of SqlClient. Probably a lot of the other Data Access modules too.
A lot easier to stick with SQL/MSDE - that's the point of the book, isn't it?

brian

brian
 
Old January 2nd, 2004, 12:26 PM
Authorized User
 
Join Date: Sep 2003
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to cjcd
Default

Thank you so much for your prompt reply. I understand the pont of the book is SQL, however, it is truly expensive and way out of my reach to buy SQL Server, that's why I was asking you for a MSAccess DB, so I guess I should rephrase the question: Is there an al ternative to MSSQL? Or is there a free version much more limited of course than the Enterprise version?

Thank you so much for your time.

 
Old January 2nd, 2004, 12:56 PM
Authorized User
 
Join Date: Nov 2003
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default

MSDE is a free download from Microsoft. The Developer edition of SQL Server can be bought for $40-50 - see "Purchasing SQL Server" thread in this forum..

brian

brian
 
Old January 3rd, 2004, 03:09 AM
Friend of Wrox
 
Join Date: May 2003
Posts: 229
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

You can also download the trial edition of SQL Server 2000 from the following URL

http://www.microsoft.com/sql/evaluat...al/default.asp

This trial edition works for 120 days and according to my understanding all the client tools such as query analyzer and enterprise manager will continue to work on your client machine after the trial period also.

By doing so you can use client tools along with the MSDE for easy database management other related issues

Charul Shukla






Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem to restore database in C#2005 database acmuralee MySQL 0 March 25th, 2008 04:42 AM
Microsoft JET Database Database Engine (0x80040E09 cannielynn0312 Classic ASP Professional 2 December 17th, 2007 02:50 AM
Copying Table From one Database To Anoter Database jayanth_nadig VB Databases Basics 1 June 19th, 2006 02:39 PM
Upload image to database or not to database? thachnn SQL Server ASP 0 October 11th, 2004 03:00 AM





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