• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 504
  • Last Modified:

MySQL Database from Classic ASP

I'm considering using a MySQL database to replace an Access database. All the web srcipts (about 80 files) are CLASSIC ASP, NOT asp.net.

Is there a simple tutorial somewhere that shows how to connect to MySQL from classic ASP?

I know it well in php, & have done many apps that way.
0
Richard Korts
Asked:
Richard Korts
  • 2
2 Solutions
 
Wayne BarronCommented:
All you need is here
http://www.connectionstrings.com/
MySQL
http://www.connectionstrings.com/mysql

Have a good one
Carrzkiss
0
 
neeraj523Commented:
hello

You can use following querystring fro connecting to mySQL database from asp page

Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

But important to note that just chnaging querystring will not give you desired results because queries written for MS Access database wont work as it is for MySQL. You will have to do some tweaking to these queries to get it working for mySQL. For example, you dont have 'Top' keyword in MySQL and MSAccess accept any date format but mySQL only understands yyyy-mm-dd etc

Hope it will help you in taking decision on this transition..
0
 
shobinsunCommented:
Hello,

Hope this will help you:

http://www.aspdev.org/articles/asp-mysql-connect/

Regards.
0
 
Wayne BarronCommented:
neeraj523 & shobinsun
Both of your content that you provided is included in the link that I provided.

The link that I provided basically covers all area's of the connections string(s) that are available.

Have a good one
Carrzkiss
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now