Hi,

Please help me if you can...

I'm getting kind of desperate here, i've just found out through mysql 

manager that myodbc is not configured even though myodbc manager says 

successfully installed. All this is happening because i'm trying to 

connect my asp page to the corresponding database.

Ken, if you happen to read this; yes its regarding the same problem you 

offered help before, except this time i'm doing it on my pws.

Cheers

Rich

> Hi,

> Please help me if you can...

> I'm getting kind of desperate here, i've just found out through mysql 

> manager that myodbc is not configured even though myodbc manager says 

> successfully installed. All this is happening because i'm trying to 

> connect my asp page to the corresponding database.

> Ken, if you happen to read this; yes its regarding the same problem you 

> offered help before, except this time i'm doing it on my pws.

> Cheers

> Rich



Hi,

I was able to get myODBC 3.51 installed on my system and also configuring 

it at the control panel. But this is the error i am presently getting, 

from this code.



<%

Dim Conn, rsCatalog, ConnString

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

Conn.Open ConnString

ConnString = "DRIVER={MySQL ODBC 3.51 Driver(Scart1)}; DBQ=" 

Server.MapPath("63db.mdb") 

Set RSCatalog = Conn.Execute("Select * from catalogs")

%>



Microsoft OLE DB Provider for ODBC Drivers error '80004005' 

[Microsoft][ODBC Driver Manager] Data source name not found and no default 

driver specified 



I will appreciate your help

Cheers 

Rich

 

Rich,



Forgive my ignorance of mySQL, but do mySQL files have .mdb extensions? I

though those were *Access* files?



: ConnString = "DRIVER={MySQL ODBC 3.51 Driver(Scart1)}; DBQ="

: Server.MapPath("63db.mdb")



The correct syntax for connecting to a mySQL database is here:

http://www.able-consulting.com/ado_conn.htm#ODBCDriverForMySQL



If you want to connect to an Access database, then you need to use the

Access driver, not the mySQL driver.



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Rich Debonair" <debonair47@h...>

Subject: [asp_database_setup] Re: Having problems getting myodbc configured

to mysql for asp/database link





: > Hi,

: > Please help me if you can...

: > I'm getting kind of desperate here, i've just found out through mysql

: > manager that myodbc is not configured even though myodbc manager says

: > successfully installed. All this is happening because i'm trying to

: > connect my asp page to the corresponding database.

: > Ken, if you happen to read this; yes its regarding the same problem you

: > offered help before, except this time i'm doing it on my pws.

: > Cheers

: > Rich

:

: Hi,

: I was able to get myODBC 3.51 installed on my system and also configuring

: it at the control panel. But this is the error i am presently getting,

: from this code.

:

: <%

: Dim Conn, rsCatalog, ConnString

: Set Conn = Server.CreateObject("ADODB.Connection")

: Conn.Open ConnString

: ConnString = "DRIVER={MySQL ODBC 3.51 Driver(Scart1)}; DBQ="

: Server.MapPath("63db.mdb")

: Set RSCatalog = Conn.Execute("Select * from catalogs")

: %>

:

: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

: [Microsoft][ODBC Driver Manager] Data source name not found and no default

: driver specified

:

: I will appreciate your help

:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~