Wrox Programmer Forums
|
ASP.NET 1.0 and 1.1 Basics ASP.NET discussion for users new to coding in ASP.NET 1.0 or 1.1. NOT for the older "classic" ASP 3 or the newer ASP.NET 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.0 and 1.1 Basics 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 November 21st, 2003, 03:48 PM
Friend of Wrox
 
Join Date: Aug 2003
Posts: 137
Thanks: 0
Thanked 0 Times in 0 Posts
Default ASP.NET database connection MySQL


I am developing a FREE graduate website, that due to limite funds, will need to use a FREE open source database. Is it possible to use a ASP.NET which is enabled to connect to a MySQL 4 database? If so where do I start? is it easy to connection to a MySQL database?

I have become clued up on ASP.NET by reading the Wrox book "Beginning ASP.NET with C-Sharp" but as all the examples prefer a Microsoft database am not sure what is involved should a MySQL database be used. Would I be creating extra work for myself? and would the database be secure?

Gaz
__________________
Gaz
 
Old November 21st, 2003, 03:56 PM
planoie's Avatar
Friend of Wrox
 
Join Date: Aug 2003
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

How would SQL be any more secure than MySql?

You can use the .Net OLEDB classes just like you'd use the SqlClient classes to access the database. You just need a ODBC database DSN to connect to MySql.

Peter
------------------------------------------------------
Work smarter, not harder.
 
Old November 21st, 2003, 05:29 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

If you want to use MySQL in combination with ASP.NET, then check here: http://www.mysql.com/articles/dotnet/

It provides links and an explanation how to use these two technologies together.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
 
Old November 21st, 2003, 07:12 PM
Friend of Wrox
 
Join Date: Aug 2003
Posts: 137
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for info guys your opinions are much appreciated

Gaz





Similar Threads
Thread Thread Starter Forum Replies Last Post
how to connect MySql Database through ASP.NET v2 shahhussain ASP.NET 2.0 Basics 0 September 27th, 2006 03:59 AM
Database connection error. asp.net/dreamw/access peacesquid Classic ASP Databases 1 July 28th, 2005 06:56 PM
Database Connection Problem with ASP.NET fukai100 Classic ASP Databases 2 August 13th, 2004 12:12 PM
Database Connection Problem with ASP.NET fukai100 SQL Server ASP 1 August 12th, 2004 07:37 PM





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