SQL or MySQL?

Michaelk

Well-known member
Joined
Jun 3, 2004
Messages
58
Location
Australia
Programming Experience
3-5
Hi, i'm currenlty in the process of turning my current web page into an asp.net page using Visual Basic.NET. But i've got a few questions.
1. Someone offered to show me how to integrate a SQL database, my current web host offers mySQL, is this very differant? Would it be hard to change SQL code into mySQL?
2. What is reccomended to write an asp page. I have both Visual Studio.NET and Web Matrix.NET. I've done some programming in Visual Studio.NET and know my way around it. But what is best for a first time attempt at an asp page?

Thanks,
 

Paszt

Staff member
Joined
Jun 3, 2004
Messages
1,500
Location
Raleigh, NC - USA
Programming Experience
Beginner
ADO.NET is designed in such a way that the code is easily reusable for almost all types of dataBases. The only thing you should have to change would be the connectionString. There may be some slight differences in SQL statements, although I believe SQLServer and mySQL use the same syntax.
 
Top Bottom