[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 331
  • Last Modified:

Connect to MySql Db from ASP driven website using Dreamweaver

I have looked all over to find a way to connect to a MySql db using DW. I understand that Macromedia does not support connection to MySql from an ASP driven website. I have an IP address + user information to MySql db.

0
nilu-72
Asked:
nilu-72
1 Solution
 
cmc2006Commented:
i believe you can use the ODBC connector from the MYSQL site (downloads area) to create a datasource connection which you can access using ASP.
0
 
cmc2006Commented:
Also Interakt Phakt Extension (www.interaktonline.com) will allow you to connect to mysql the PHakt extension is Free.
0
 
nilu-72Author Commented:
I am using this string to connect:
<%
'Connectionstring
Dim objConn, objRS
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.Recordset")
objConn.ConnectionString="DRIVER={MySQL ODBC 3.51 Driver};SERVER=xxx.xxx.xxx.x;DATABASE=volare;UID=volare;PWD=xxxxxx;"
objConn.Open
%>
In dreamweaver it shows that the connection is a succes, but I can not see the tables.

The Phakt extension is only for PHP sites. This is an ASP website.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
Jason C. LevineNo oneCommented:
nilu-72,

cmc2006 is right,  you need to use the mysql odbc connector to use mysql with asp.

https://service.breezecentral.com/support/dreamweaver/ts/documents/dwmx_dynamic_faq.htm#mysql

and

http://www.mysql.com/products/connector/odbc/index.html
0
 
siva350Commented:
0
 
Jason C. LevineNo oneCommented:
Hi mrichmon,

cmc2006 has the answer.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now