Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 1.0 and 1.1 > ASP.NET 1.0 and 1.1 Basics
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old November 21st, 2003, 03:48 PM
Friend of Wrox
 
Join Date: Aug 2003
Location: Warks, Warks, United Kingdom.
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
  #2 (permalink)  
Old November 21st, 2003, 03:56 PM
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

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.
  #3 (permalink)  
Old November 21st, 2003, 05:29 PM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 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.
  #4 (permalink)  
Old November 21st, 2003, 07:12 PM
Friend of Wrox
 
Join Date: Aug 2003
Location: Warks, Warks, United Kingdom.
Posts: 137
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for info guys your opinions are much appreciated

Gaz
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 03:35 AM.


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