asp.net connection to MySQL from Windows 2003 64bit
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
