Allright, I gave the myODBC a try in order to connect to MySQL, but I got this error:
System.Security.SecurityException: Request for the permission of type 'System.Data.Odbc.OdbcPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
It works perfectly on my own computer, but not on the Webwiz server. I googled the error message, and it seems to be something about trust levels? Have no clue what to do about it. I'm not quite sure about my connection string though, it looks like this:
"DRIVER={MySQL ODBC 3.51 Driver};SERVER=mysql.webwiz.net;PORT=3306;DATABASE=myDatabase;UID=myUsername;PASSWORD=myPassword;OPTION=3"
Does my connection string look right, or can anybody point out what's wrong? If there is no simple way to solve this problem, I will probably skip mySQL and go for the SQL Server instead...
Topic Options
Post Options
Thanks(0)
