asp.net connection to MySQL from Windows 2003 64bit

Report · Sep 07, 2010

hello

I'm unsuccessfully trying to have my asp.net pages work on a Windows 2003 64bit.

I've installed MSDASQL, I have a working DSN (I've tested it) and my script is:

<%@ Page Language="C#" ContentType="text/html" validateRequest=true%>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %>

<MM:DataSet
id="ds_xxx"
runat="Server"
IsStoredProcedure="false"
ConnectionString='Provider=MSDASQL;Dsn=my_dsn'
DatabaseType='Odbc'
CommandText='SELECT xxxxxx FROM xxx WHERE id = x '
Debug="true"
></MM:DataSet>

***

But I receive this error message:

System.ArgumentException: The .Net Framework Data Provider for OLEDB (System.Data.OleDb) does not support the Microsoft OLE DB Provider for ODBC Drivers (MSDASQL). Use the .Net Framework Data Provider for ODBC (System.Data.Odbc).

Stacktrace is about System.Data.OleDb.* namespace.

Is it possible to create an ODBC connection, or to tell Dreamweaver librery to do so ?

Any ideas ?

Pages were created with Dreamweaver CS3.

I've changed the page so to show and test easily connection string and database type.

thanks

Marco

Report · Sep 16, 2010

Hi Marco,

The sad truth of it is that Dreamweaver is simply the wrong tool to be using for .NET. CS3 has only support for .NET 1.0, and poor support at that, Dreamweaver now has no support for .NET - it has been completely removed.

Due to this fact, you'll find your level of help for .NET in these parts sparse at best. You'll be better server over at one of "Their" forums. You've probably already surmised this, but I hated to see your post sitting there with no response at all. Hope you find the help you need.

--
Lawrence Cramer - *Adobe Community Professional*

http://www.Cartweaver.com
Shopping Cart for Adobe Dreamweaver
available in PHP, ColdFusion, and ASP

Stay updated - http://blog.cartweaver.com