Last post Jun 10, 2010 02:27 PM by Segundo
Jun 09, 2010 04:54 PM|ishan_bakshi|LINK
I am using Asp.net 2.0 with MySQL for the first time and i am stuck for a long time now.
This is my test page code
Partial Class test
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim connectionString As String = "SERVER=mysql50-29.wc1:3306;DATABASE=414701_XXXX;user id=XXXX;password=XXXX" '
Dim conn As New MySqlConnection(connectionString)
' Do Something......
End Sub 'Form1_Load
I have added mysql.data.dll file in bin folder ( downloaded mysql-connector 1.0 and added the dll reference)
Jun 09, 2010 06:12 PM|Segundo|LINK
are you testing it in production server? if yes, the server should be an ip address.
Please check this link:
Any dout, post your comment.
Jun 10, 2010 06:53 AM|ishan_bakshi|LINK
hi sugendo, thanks for your reply. The code runs properly on my system but when i upload the file to live environment the following error appears
"System.Security.SecurityException: That assembly does not allow partially trusted callers."
FOR Mysql.data.dll i executed mysql connector 6.0 version
Can you speicify what do i need to add in the web.config file to make this run ? i havent added any assembly tag.
DO I NEED another version of DLL ?
Jun 10, 2010 02:27 PM|Segundo|LINK
Please see this thread:
Any doubt, post your comment.