Skip to main content
Participant
September 7, 2010
Question

asp.net connection to MySQL from Windows 2003 64bit

  • September 7, 2010
  • 1 reply
  • 566 views

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

This topic has been closed for replies.

1 reply

Lawrence_Cramer
Inspiring
September 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