
March 10th, 2003, 06:16 PM
|
|
Junior Member
|
|
Join Date: Mar 2003
Location: India
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
How to build connection between Asp and Mysql
I am a web developer, using Asp and MySql for a project.
I have tried to setup a DSN but couldn't find the provider for mysql connection, hence could not able to setup it.
Also I have tried
<%
strConnection = "driver={MySQL};server=localhost;uid=;"
strConnection = strConnection & "PASSWORD=;database=databaseName"
Set adoDataConn = Server.CreateObject("ADODB.Connection")
adoDataConn.Open strConnection
%>
but it is giving me error as
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
I am getting late for this project.
From which I can download the provider for Mysql connection via Asp? or another solution you would like to suggest? please I would be thankfull to .....
|