ASP with MySQL

[asabi]

I am trying to connect from an ASP page to mysql DB.

I need the connection string and a basic example.

questions:

How diffrent is MySQL from SQL server ?
Does it return the same recordset object ?
How do I declare the variables ?
will a server.createobject ("ADODB.recordset") would work with it or do I need something else ?
which is better mySQL or Access ?

Thank you very much

[Cawas]

The main difference is on Connection String.

I have no prior knowledge to mySQL and ASP myself. But I do have experience with ASP + SQL, ASP + Access, ASP + DB2 and PHP + MySQL.

And I can tell that everything else will be the same, inside the ASP code. The other difference can come from Query Strings. Since I have no deep knowledge on MySQL, I don't know for sure, but i'm pretty confident that will be some little differences.

Well, I'm ressurecting this because I was looking for the connection string on ASP + MySQL, I wrote on search "MYSQL Connection" and I didn't found answers. So, I'm asking here, while answering some questions from this guy:

Someone knows a good string to do the connection? I don't want to use ODBC and I want a code that can work by itself, because I will make tests on one server and copy all to another one. I know there is a good string for this, but since there are 6 months I don't deal with ASP, and I'm with my FTP down, I don't have the code and can't remember it.

Well, I would modify the code to connect to SQL that I have someplace on my files, but I said I can't access my files rite now.

[techgnome]

Goto http://www.mysql.net (or is it http://www.mysql.com ?? one of those). Any ways, do a search for MYODBC. It's a component that can be used similar to ADO. THey have examples on how to connect and what the conneciton string needs to look like, etc....

[Cawas]

Originally posted by techgnome
Goto http://www.mysql.net (or is it http://www.mysql.com ?? one of those.)

Hehe, take a look at the .NET one... Very funny thing on internet...

[techgnome]

SOrry about that..... it is .COM after all.... I can never keep them straight..... now that I think about it ... it's http://www.php.NET and http://www.mysql.com ....

[Cawas]

No need to sorry. I found it funny about those sites who use the others name.

But I still can't make my connection string work.

Do I need to install something from www.mysql.com on my IIS 2000 Server? If there's no other way, ok. But I wishto know that first...

I'm back to mysql.com trying to find some answers while someone here can't help me on this issue.

edit: Oh yeah, I wish to avoid MyODBC. As I said, I want less dependent on external applications as possible to have. Even I need some Class, like one I have to uploading files, which I don't need any extra DLL installed on my IIS.

[lleemon]

Not sure if you got your answer. For a connection string check here:http://www.able-consulting.com/MDAC/...oviderForMySQL

If you don't want to go there I will paste it in:

oConn.Open "Provider=MySQLProv;" & _
           "Data Source=mySQLDB;" & _
           "User Id=myUsername;" & _
           "Password=myPassword"