ASP MySQL DSN less Connection

[bestip]

Hi,

Can any one give me the code, for how to connect mySQL using ASP with DSN Less.

Thank You

[bruce]

http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForMySQL

I have not tested this and cannot confirm whether this works or not.

[b]quote:Originally posted by bestip

Hi,

Can any one give me the code, for how to connect mySQL using ASP with DSN Less.

Thank You
</blockquote id="quote"></font id="quote">

[Aristotle]

I think you have to use a DSN. I don't think that the OLEDB drivers for MySQL are installed.

[yiouli1]

Set Con=Server.CreateObject("ADODB.Connection")
Con.Open "accessDSN"


accessDSN is the virtual name for my database. I hope that's what you need....

[bestip]

Hi all,

How can i use DNS for the connectivity? Because i want to connect the MySQL database which is running on another hosting server not on aspdiscount server.

Here is the code i am trying to connect using ASP from discountASP server to abother server.

'================================================= ===
<%
strConnection = "driver={MySQL};server=WWW.ANOTHERSERVER.COM;uid=us ername;pwd=password;database=db_name;option=NUM"

Set adoConn = Server.CreateObject("ADODB.Connection")

adoConn.Open strConnection


%>
'================================================= =============