mysql and

Results 1 to 2 of 2

Thread: mysql and

  1. #1
    Join Date
    Dec 1969

    Default mysql and

    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, &#039;Provider=SQLOLEDB;&#039;. <BR><BR>i have uploaded the web.config file that was created by dreamweaver

  2. #2
    Join Date
    Dec 1969

    Default RE: mysql and

    Ugh. I think that you&#039;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>&#060;%@ Assembly Name="Microsoft.Data.Odbc" %&#062; <BR>&#060;%@ Import Namespace="Microsoft.Data.Odbc" %&#062; <BR><BR><BR>Then, you can call the mySQL DSN like so....<BR> <BR> dim Conn as New OdbcConnection("DSN=YourDSN")

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts