ASP and MYSQL

[QuikFrozen]

Hey programmers!!
I'm just been asigned to create an ASP-MYSQL connection. I was wondering if that's possible, if so, please help. I don't now much about ASP, I only now it uses visual basic, so it's gonna be boring. Anyway, any help will be well recieved...

[crazyluv]

ASP.NET uses full VB, JScript, C++ or C# but ASP uses VBscript or JScript. Just so you know . I don't see why it would be boring well more boring then any other language but hey everyone is entitled to their own opinions.

To the question, yes you can use MySQL with ASP. You just need to alter the connection screen although that is easy enough to find as shown below.

I find this to be a useful resource:
http://www.google.com.pr/search?q=my...en-US:official

Heres an example found in the above link:
http://www.webafrica.co.za/kb/develo...onnection.html

I'd give you an example but I have yet to play around with MySQL and ASP.

[Paula]

Umm this is how I connect to the MySQL database with ASP, I think this is what you're asking?

<%
set objConn=server.CreateObject("ADODB.Connection")

strConn="Driver={MySQL ODBC 3.51 Driver}; Server=localhost; database=databasename; uid=userid; pwd=password; port=3307; option=1;"

objConn.Open strConn%>

Replace databasename, userid, password and I don't know about port. Depends on the port the database is running from...or something.

[QuikFrozen]

Thanks Paula,
just what I was looking for...