Solved

MySQL Database from Classic ASP

Posted on 2009-04-01
4
494 Views
Last Modified: 2012-05-06
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
Comment
Question by:Richard Korts
  • 2
4 Comments
 
LVL 30

Accepted Solution

by:
Wayne Barron earned 250 total points
ID: 24045529
All you need is here
http://www.connectionstrings.com/
MySQL
http://www.connectionstrings.com/mysql

Have a good one
Carrzkiss
0
 
LVL 22

Expert Comment

by:neeraj523
ID: 24046451
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
 
LVL 14

Assisted Solution

by:shobinsun
shobinsun earned 250 total points
ID: 24047191
Hello,

Hope this will help you:

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

Regards.
0
 
LVL 30

Expert Comment

by:Wayne Barron
ID: 24047321
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now