mysql and asp.net?

mak-hoo

New Member
is this combination possible ?<BR>i use dreamweaver mx and can make a connection to my database<BR><BR>but when i try the page on my webserver it comes with this error:<BR>System.ArgumentException: An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'. <BR><BR>i have uploaded the web.config file that was created by dreamweaverUgh. I think that you're goping to have to leave Dreamweaver behind, for this one.<BR><BR>Yes, it is possible. First, create a DSN to the mySQL database.<BR><BR>Then, download and install the Miscrosoft.Data.ODBC namespace. Then, copy the Microsoft.Data.ODBC.dll into the in subdirectory of your application. <BR><BR><BR>Then add this to your page to identify and import the assembly.<BR><BR><%@ Assembly Name="Microsoft.Data.Odbc" %> <BR><%@ Import Namespace="Microsoft.Data.Odbc" %> <BR><BR><BR>Then, you can call the mySQL DSN like so....<BR> <BR> dim Conn as New OdbcConnection("DSN=YourDSN")
 
Back
Top