Need help whit a connect string to mysql

hellur · #1 (**permalink**) 11-25-02, 08:33

Well my probs is that I have installed mysql and its work but now to problem I coding in asp and need a connection to the mysql

<%
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="& _
Server.MapPath("ops.mdl")
Set dbcon = Server.CreateObject("ADODB.Connection")
Set rs=Server.CreateObject("ADODB.recordset")
dbcon.open strConnect
%>

This you use for access databas but how do I do one for mysql ? someone have a answere pls answere

Mulligan · #2 (**permalink**) 11-25-02, 09:39

Download and install MyODBC (link from MySQL.com) and follow the instructions. You can't connect to MySQL using OLEDB or any of the native providers. Install it, set up a DSN and do it that way.

edit: example from an ASP page connecting to MySQL

Code:

	Set cn = Server.CreateObject("ADODB.Connection")
	Set rs = Server.CreateObject("ADODB.RecordSet")
	' option=16384 forces MyODBC to cast BIGINT to INT for count(*) statements - ADO can't handle BIGINTs
	cn.Open "Driver={mySQL}; Server=10.0.0.1; Port=3306; Option=16384; Socket=; Stmt=; Database=databasename; Uid=username; Pwd=yourpassword;"

Internet Services

Web Development

Digital Marketing

Consumer Tech