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" <ka****@quickemail.de> wrote in message
news:40********@news.vo.lu...

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();
}
}

[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.EnvironmentPerm ission,
mscorlib, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
version="1"
Read="USERNAME"/>
<IPermission class="System.Security.Permissions.FileDialogPermi ssion,
mscorlib, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
version="1"
Unrestricted="true"/>
<IPermission class="System.Security.Permissions.FileIOPermissio n,
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.IsolatedStorage FilePermission, 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.ReflectionPermi ssion,
mscorlib, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
version="1"
Flags="ReflectionEmit"/>
<IPermission class="System.Security.Permissions.SecurityPermiss ion,
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.UrlIdentityPerm ission,
mscorlib, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
version="1"
Url="file://J:/Prog/C#/database.exe"/>
<IPermission class="System.Security.Permissions.ZoneIdentityPer mission,
mscorlib, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
version="1"
Zone="Intranet"/>
</PermissionSet>
Exit code: -532459699 , E0434F4Dh
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> a écrit
dans le message de news:OX**************@TK2MSFTNGP09.phx.gbl...

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" <ka****@quickemail.de> wrote in message
news:40********@news.vo.lu...

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();
}
}