Solved

: ODBC connection to MySQL from standard ASP code

Posted on 2011-02-25
5
898 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Populate custom post type/custom fields from an external database in WordPress 3 130
send email part1 9 52
Time comparison asp 1 27
Save data in two Database, Asp 2 68
I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
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 …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

732 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