mySQL and ASP - Is this possible?

I have been put forward for a role using ASP & mySQL

[uk_webber]

As far as I was aware ASP could only work on Windows/ IIS and mySQL on linux, apache etc

I have been put forward for a role and these are the two main skills.

So is it possible to use ASP and mySQL together?

[mattur]

Yes.

MySQL is available for a number of platforms including Windows.

ASP uses ADO to connect to databases, via ODBC or OLEDB. So with a MySQL driver, ASP can connect to MySQL - on a Windows or Unix box.

Chilisoft ASP, now part of Sun One, is a mostly-compatible version of ASP that runs on Unix/Apache.

[uk_webber]

Cool, is it possible to connect to a mySQL running on unix from ASP on Windows?

[mattur]

Yes.

I've done this by installing MyODBC driver, creating an ODBC system DSN to the MySQL server and building a connection string using OLEDB for ODBC driver.

Once you've got MyODBC installed you can just treat MySQL as another data source - so you can open tables via Access etc.

You can use the MS Data Link utility to build an OLEDB connection string. Create a blank text file and rename it with a .udl extension. Click on it and a sort-of-wizard will appear that steps you through creating a connection string. Open the file in notepad to see the string.

I think there is an OLEDB driver for MySQL as well, so it should be possible to create a direct OLEDB Connection (rather than via ODBC) as well - I haven't experimented with this.

[gsmith]

There exists a product called "SWsoft: MyOLEDB provider for MySQL" that I know nothing about beside the fact the it exists. It seems to me that it is what you are looking for, however.

[freeflight2]

ODBC-Mysql works great and can be accessed from java, asp, ...