Connection to MySQL via the network

[KaHuNa]

this code works perfectly when i use it on the server where mySQL is
installed, but i have a security error when i use it on a client computer.
I don't know how i can change that.


using System;
using System.Data.Odbc;

class database
{
// OleDbConnection oConn;
// OleDbCommand oCmd;

public void setConnection()
{
string MyConString = "DRIVER={MySQL ODBC 3.51 Driver};" +
"SERVER=192.168.1.2;" +
"DATABASE=golf;" +
"UID=root;" +
"PASSWORD=;" +
"OPTION=3";


OdbcConnection myConnection = new OdbcConnection(MyConString);

try
{
// myConnection = new OleDbConnection(MyConString);
string mySelectQuery = "SELECT * FROM golfnews";

myConnection.Open();
OdbcCommand myCommand = new OdbcCommand(mySelectQuery, myConnection);
myCommand.CommandTimeout = 20;
OdbcDataReader myReader;
myReader = myCommand.ExecuteReader();
int i = 0;

while (myReader.Read())
{
Console.WriteLine(myReader.ToString() + i++ );
}
myReader.Close();
}
catch (Exception exc)
{
Console.WriteLine(exc.Message);
}
finally
{
myConnection.Close();
}
}
}

class Prog
{
static void Main()
{
database db1 = new database();
db1.setConnection();
}
}

 

[Nicholas Paldino [.NET/C# MVP]]

KaHuNa,

What exactly is the exception that you are getting?

Also, when running it on a client computer, is it running in ASP.NET
perhaps (where the ASP.NET application is the client ot the MySQL server).
If not, are you sure that you have rights to the server and to the network
as well.

i

 

[KaHuNa]

i don't have exception i have that sorry for the french but i don't know
the translation for that)

Exception non gérée : System.Security.SecurityException: Failure of request.
at database.setConnection()
at Prog.Main()

Le jeu autorisé de l'assembly défaillant était :
<PermissionSet class="System.Security.PermissionSet"
version="1">
<IPermission class="System.Security.Permissions.EnvironmentPermission,
mscorlib, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
version="1"
Read="USERNAME"/>
<IPermission class="System.Security.Permissions.FileDialogPermission,
mscorlib, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
version="1"
Unrestricted="true"/>
<IPermission class="System.Security.Permissions.FileIOPermission,
mscorlib, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
version="1"
Read="J:\Prog\C#\"
PathDiscovery="J:\Prog\C#\"/>
<IPermission
class="System.Security.Permissions.IsolatedStorageFilePermission, mscorlib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Allowed="AssemblyIsolationByUser"
UserQuota="9223372036854775807"
Expiry="9223372036854775807"
Permanent="True"/>
<IPermission class="System.Security.Permissions.ReflectionPermission,
mscorlib, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
version="1"
Flags="ReflectionEmit"/>
<IPermission class="System.Security.Permissions.SecurityPermission,
mscorlib, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
version="1"
Flags="Assertion, Execution, BindingRedirects"/>
<IPermission class="System.Security.Permissions.UIPermission, mscorlib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Unrestricted="true"/>
<IPermission class="System.Net.DnsPermission, System, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Unrestricted="true"/>
<IPermission class="System.Drawing.Printing.PrintingPermission,
System.Drawing, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a"
version="1"
Level="DefaultPrinting"/>
<IPermission class="System.Diagnostics.EventLogPermission, System,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1">
<Machine name="."
access="Instrument"/>
</IPermission>
<IPermission class="System.Security.Permissions.UrlIdentityPermission,
mscorlib, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
version="1"
Url="file://J:/Prog/C#/database.exe"/>
<IPermission class="System.Security.Permissions.ZoneIdentityPermission,
mscorlib, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
version="1"
Zone="Intranet"/>
</PermissionSet>
Exit code: -532459699 , E0434F4Dh