Connection to Database

[plasterx]

Hi all, would like to ask some questions on connecting to mySQL. is the syntax the same as connecting to mssql using asp?? this is how i connect to mssql using asp:

Set Conn = Server.CreateObject("ADODB.Connection")
Set RS = SErver.CreateObject("ADODB.Recordset")
strConn = "DSN=FYP_Actual;Driver={SQL SERVER}; UID=sa;pwd=;"
Conn.Open strConn

is this the same way i connect to mySQL too?

[ecnarongi]

what language are you using now trying to connect to the mysql database?

[plasterx]

Asp.=)

[mysqlautobackup]

Please install the MyODBC first.

:)