Last post Oct 28, 2010 04:55 AM by Hubble
Oct 27, 2010 04:01 AM|amthekkel|LINK
I am trying to test website on a remote server to see if I can read or write to a MySql Database.
In VS Web developer 2010 Express edition, I created a new website and saved it via ftp on the remote host. I have added the 'Mysql.data.dll' to the website and placed it in the bin directory of the project.
When I try to run the program i get "Could not load File or assembly
MySql.Data, Version=184.108.40.206, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.
Line 4: <compilation debug="true" urlLinePragmas="true">
Line 5: <assemblies>
Line 6: <add assembly="MySql.Data, Version=220.127.116.11, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/>
Line 7: </assemblies>
Line 8: </compilation></system.web></configuration>
The remote server supports .Net v2, so I have made my application focused on v2 framework. I have tried similar code on my local machine and works fine.
Can anyone pls advice what I might be doing wrong?
Oct 27, 2010 07:08 AM|Hubble|LINK
You have to install on the server the mysql .net connector. You can download it from here:
Hope this helps
Oct 27, 2010 07:48 AM|amthekkel|LINK
Is there a way resolving this without installing the the MySql connector.
I don't have install access to the server, the only thing I have is access to an ftp client that I can use to upload files to the server.
Is there no way to package the required dll and have the application load the dll on the server?
cheers for your help.
Oct 28, 2010 04:55 AM|Hubble|LINK
I'm not really sure if you can copy the required files from the GAC to your application's bin folder.
Try it, and tell us if it worked for you.
I've found an article that may help you with this: