[SOLVED] Connecting/Using MySQL and ASP

[Monie]

I don't know if this is a good idea, but at least I am migrating myself from the "not-popular" MS Access into MySQL
I have just install WAMP (windows apache mysql php) in my pc, but before go into php, i just want to know how to make asp interact with mysql.

Is anybody you out there that have been using ASP and MySQL before?
I would glad if you can teach me on the connection procedure, I mean what should I do in order to make my ASP page to interact with MySQL database.

Thanks...

[robbied72]

Hi Monie, Try looking Here http://www.codeproject.com/database/...ings.asp#MySQL

[Monie]

Hai robbied,

Actually, I don't have problem with the connection string. I know how to use the WAMP tools and successfully create my first page that interact with my MySQL database. (display data from MySQL database)

My problem is, I wanted to learn how to do that not with php but with ASP. I search the net and I found out that you have to install some kind of odbc driver for mysql called MyODBC that you can download from www.mysql.com.

I have installed them and follow each instruction but couldn't manage to make my page interact with the MySQL database.

That's why I am asking if there is someone that design their page using asp and MySQL.
I wanted to know what are the thing's that I need to do for this asp-MySQL communication.

Thanks..

[Monie]

I did it! I just could not believe it, I' done it!
Thats mean we dont have to install anything on our pc in order to make asp talk to MySQL, we just need the CONNECTION STRING that tell asp to find the MySQL.

Ok, now this code is just diaplays what are the field that I have in my table "contacts". What are the code for diplaying the data inside the field?

I have tried <%=myrecordset("firstName")%> but failed!

Code: Select all

<% on error resume next %>
<%
    dim adoConn
    dim adoRS
    dim counter
    dim strQuery
    
    set adoConn = Server.CreateObject("ADODB.Connection")
    set adoRS = Server.CreateObject("ADODB.Recordset")
    
    adoConn.Open "Driver={mySQL ODBC 3.51 Driver}; Server=localhost; Port=3306; Option=4; Database=address; Uid=root;Pwd=monie;"
    adoRS.ActiveConnection = adoConn
    
    if adoConn.errors.count = 0 then
    
    response.write "<h2>Fields In The 'Contacts' Table:</h2>"
    adoRS.Open "describe contacts"
    while not adoRS.EOF
    
    response.write adoRS.fields(0).value & "<br>"
    adoRS.MoveNext
    wend
    else
    response.write "ERROR: Couldn't connect to database"
    end if
%>

[Monie]

Yes, once again. I've done it.
Now I can Throw away my MS Access Application and welcome my brand new friend MySQL

Code: Select all

<% on error resume next %>
<%
Dim sConnection, objConn , objRS

sConnection = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=address; OPTION=4; UID=root;PASSWORD=monie;"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open(sConnection)
Set objRS = objConn.Execute("SELECT * FROM contacts")

While Not objRS.EOF
Response.Write objRS.Fields("firstName") & ", " & objRS.Fields("lastName") & "<br>"
objRS.MoveNext
Wend

objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
%>

[robbied72]

Well done mate.

[Monie]

Originally Posted by robbied72

Well done mate.

Thanks robbied, just one more question ...

I am developing my page in ASP-MySQL...

Is there any program like phpmyadmin (MySQL-Interface) that I can use to manage my database?

Thanks..

[alexgeek]

Monie, Visual web developer comes with a built in Database GUI.
It's exactly like PHPMyAdmin,

[Monie]

Thanks alex,

I have downloaded mysql manager from www.mysql.com. It's quiet nice too. But I am looking something that are similar to phpmyadmin.
Maybe I'll look into your suggestion. Did you mean This link?