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.

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

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.

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

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