Connect to MYSQL with ASP.Net

[dischord13]

I am trying to connect to a MYSQL database from an ASP.net page I copied the
format below from another website.

"DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost;
DATABASE=Your_Mysql_DB; UID=mysql_username; PASSWORD=mysql_password; OPTION=3"

The connection tests fine and looks great but when I test the page it says I
need an OLE DB Provider specified in the connection string. It gave me an
example "Provider=SQLOLEDB;"

This is all very new to me. I hardly know what a provider is. Can someone
please give me an example of what provider I could use for MYSQL? I appreciate
any help you can give.

Thank You

[Chris In Madison]

Not sure if this will help, but did a quick Google search and this article
series appeared:

[url]http://www.15seconds.com/issue/050210.htm[/url]
[url]http://www.15seconds.com/issue/050407.htm[/url]

Best regards,
Chris

[Mr. L]

Hi there, I am having a similar problem. I tried both, the ASP.NET C# and the
ASP.NET VB server model. Both returned the following results. But first... here
is my setup: Dev Machine: - Windows XP Pro SPII - IIS 5.1 - MySQL 4.1 - MySQL
ODBC 3.51 Driver - Microsoft .NET SDK Computer Dreamweaver MX 2004 is
installed on: - Mac OS X 10.3.8 - DW MX 2004 7.0.1 version - Using following
connection string with the OLE DB connection type: 'DRIVER={MySQL ODBC 3.51
Driver}; SERVER=localhost; DATABASE=mydb; USER=dbuser; PASSWORD=dbuserpass;
OPTION=3' When I test the connection everything is great. Dreamweaver
connected successfully. So, it seems that all is well there. I would like to
add that dbuser had all priviledges as the root user (I just wanted to rule out
any possible permission problems). When I open a new document in dreamweaver
and click the Bindings tab, then click the + button to create a new DataSet
(Query), select my previously create connection that tested successfully, I get
in the table select tab following message: *** No Table Found Now, I know for
sure that this particular Database had 3 tables in the database, and since this
particular user has all priviledges on all databases and tables in those
databases as the root user, it really can't be a permissions problem. Further
more: When I connect to this database with the PHP/MySQL server model (using
my Free BSD production server as the application server, because it has PHP
installed), and connect to that MySQL database residing on my Windows XP Dev
Box, and do a simple select Query, all tables are listed to be selected, not a
problem. Conclusion: Is there some sort of a compatibility problem with
Dreamweaver's ASP.NET server models using MySQL as a database? One more thing
... I tried setting up a connection to my product MySQL database server (wich is
running Free BSD OS) with the ASP.NET server model and my Windows XP Pro dev
box... same problem... no tables found. It's too weird. I just don't get it.
What is going wrong here. I tried doing searching on the internet for any sort
of tutorial for ASP.NET server model in Dreamweaver MX 2004, using MySQL as a
database server and ODBC driver, but there is not much info out there. It's
quite strange. Perhaps someone at MM or a senior developer on here can shed
some light on this strange situation. Thank you, Martin Lerch

[Mr. L]

Hello dischord13,

You may check following forum post at
[url]http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=263&thre[/url]
adid=990645.

The post is long, and I may need to work on my English composition and writing
skills as Clinton G. puts it, but maybe you'll get something out of it. It at
least works for me.

Bye for now,

[dischord13]

Thanks! I will go through that carefully. I made similar progress and tried
"MySQLProv" but then got "unidentified error" message. I had just given up and
decided to stick with PHP!! I appreciate the detail and don't listen to
Clinton. Some people are... well, I don't want them to delete my e-mail for
profanity so I wont say it. But thanks, great post. I'll try connecting again.

[gbarret]

I have the same problem. When I test the connection it works fine, but when I
try the page I receivin the error about the "Provider".
If write the connection as it is explained by 15seconds it works fine. I have
the udl file too but nothing.

Please if somebody has a solution .