Solved

MySQL Database from Classic ASP

Posted on 2009-04-01
4
497 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 31

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 31

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MS SQL Update query with connected table data 3 61
Import MySQL data into MS Access using VB.Net interface 5 50
Generate Unique ID in VB.NET 21 102
MYSQL responding very slow 3 49
I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

756 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