asp.net page Error

System.ArgumentException: The .Net Data OLE DB Provider(System.Data.OleDb) does not support the MSDASQL Provider, Microsoft OLE DB Provider for ODBC Drivers.
at System.Data.OleDb.OleDbConnection.ValidateConnectionString(Hashtable hashtable, String connectionString)
at System.Data.OleDb.OleDbConnection.set_ConnectionString(String value)
at System.Data.OleDb.OleDbConnection..ctor(String connectionString)
at DreamweaverCtrls.DataSet.NewDbConnection(String strConnection)
at DreamweaverCtrls.DataSet.DoInit()  

When previewing my aspx page the above error appears, Please help
wizardofmiraclesAsked:
Who is Participating?
 
jay_eireCommented:
Hi wizardofmiracles,

This error occurs when the provider "Microsoft OLE DB Provider for ODBC Drivers" is selected as the driver when creating a connection within Dreamweaver MX. This provider, like all others, requires a very specific set of parameters formatted in a specific way. Currently, the connection code Dreamweaver MX writes does not work with this Microsoft OLE DB provider.

Please have a look at the following TECHNOTE:
http://www.macromedia.com/go/tn_16303

Solution
To avoid the error use any other provider. A complete list of available providers is available by creating an OLE DB connection and clicking the Build button.


Thanks
Jay Eire
(<>..<>)
0
 
wizardofmiraclesAuthor Commented:
thank you ever so much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.