Solved

: ODBC connection to MySQL from standard ASP code

Posted on 2011-02-25
5
900 Views
Last Modified: 2012-05-11
I am very familiar with using DSN connections in my standard ASP codes getting connected to MS Access.

I am using traditional ASP and want to get connected to MySQL database on my local server.  Local computer is windows 7 professional (32 bit). I downloaded the relevant MySQL ODBC 5.1 driver from
www.mysql.com.
I am testing the ASP code in my local host. It is giving ODBC connection error message.
Initially, I tried creating a system DSN.  DSN was created successfully.  It gave a message “connection successful”  when I pressed the button “test”. When I tried to open the DSN in administrative tools to look for the configuration again, it is giving the message “Invalid attribute string”.
I have searched web for the solution to the problem on
http://bugs.mysql.com/bug.php?id=56233
I have gone through the discussions.
I am not able to find the solution

Instead of DSN-based connection, I tried to use the DSN-less connection in ASP code which is as follows:
==========================================================
<.html>
…..
<table></tr>


<%
Set objdbconmysqldemostr=Server.CreateObject("ADODB.connection")

set rsusers=server.createobject ("adodb.recordset")



objdbconmysqldemostr.Open ("DRIVER={MySQL ODBC 3.51 Driver};" & _
                 "Server=localhost;" & _
                 "Port=3306;" & _
                 "Option=16384;" & _
                 "Stmt=;" & _
                 "Database=abcxyz;" & _
                 "User=root;" & _
                 "Password=thefire")




rsusers.open "select * from userlogin order by ename",objdbconmysqldemostr,1,1
dim rn,mr
rn=0
while not rsusers.eof

rn=rn+1


response.write   "<td>" & rn & "</td>"
response.write   "<td>" & rsusers("username") & "</td>"
response.write   "<td>" & rsusers("password") & "</td>"
response.write   "<td>" & rsusers("ename") & "</td></tr>"

rsusers.movenext

wend

rsusers.close
set rsusers=nothing
objdbconmysqldemostr.close
set objdbconmysqldemostr=nothing

%>
 
</table>

……………
</html>

Again the same problem with database connection
Any thoughts for solving the problem
0
Comment
Question by:smanthanims
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 34984753
This is the code that I use to connect to MySQL both on Windows XP with IIS5.1 and on Godaddy with IIS7.
connectstr = "Driver={MySQL ODBC 3.51 Driver};SERVER=yourserver;DATABASE=yourdb;UID=youruser;PWD=yourpwd"

Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open connectstr

Set idresult = Server.CreateObject("ADODB.Recordset")
idresult.Open "SELECT * FROM yourtable", oConn

Open in new window

0
 

Author Comment

by:smanthanims
ID: 34985274
Again the same problem.  The log file on IIS 7.5 shows the following message:

2011-02-26 01:39:17 ::1 GET /mydomain/mysqldemo/mysqldemouserlist1.asp |39|80004005|[Microsoft][ODBC_Driver_Manager]_Data_source_name_not_found_and_no_default_driver_specified 80 - ::1 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.1;+Trident/4.0;+GTB6.6;+SLCC2;+.NET+CLR+2.0.50727;+.NET+CLR+3.5.30729;+.NET+CLR+3.0.30729;+Media+Center+PC+6.0;+.NET4.0C;+AskTB5.5) 500 0 0 0

I think problem is with ODBC driver for mysql
0
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 500 total points
ID: 34985420
I believe you're right.  You can try changing it to {MySQL ODBC 5.16 Driver} or whichever version you downloaded or you can download and install the 3.51 version.
0
 

Author Closing Comment

by:smanthanims
ID: 34985707
I downloaded the following driver from www.mysql.com
Windows (x86, 32-bit), MSI Installer
Connector-ODBC  5.1.8

Among mirror sites I have chosen, Hoobly Classifieds / Chicago, IL, United States   HTTP  

I reinstalled the driver and restarted the system. I created a new DSN for mysql database.  It was configured correctly without errors.  I used the DSN connection in my ASP code.
I worked perfectly
thanks for the prompt support
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 34985712
You're welcome, thanks for the points.
0

Featured Post

Webinar: Choosing a MySQL HA Solution

Join Percona’s Principal Technical Services Engineer, Marcos Albe as he presents Choosing a MySQL High Availability Solution on Thursday, June 29, 2017 at 10:00 am PDT / 2:00 pm EDT (UTC-7).

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question