Connection to a db

K

KaHuNa

I want make a connection with MySQL (don't know why, i need, that's all
; ) ) in C#
but i don't know a lots the OleDbConnection, i have do that:

using System;
using System.Data.OleDb;

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

public void setConnection()
{
OleDbConnection myConnection = new OleDbConnection(
"Provider=MySQL ODBC 3.51 Driver;Data
Source=192.168.1.2;Database=golf;");
string mySelectQuery = "SELECT * FROM golfnews";

myConnection.Open();
OleDbCommand myCommand = new OleDbCommand(mySelectQuery, myConnection);
myCommand.CommandTimeout = 20;
OleDbDataReader myReader;
myReader = myCommand.ExecuteReader();

while (myReader.Read())
{
Console.WriteLine(myReader.ToString());
}
myReader.Close();

myConnection.Close();
}
}

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

but i receive in the output a security error :

exception does not generated : System.Security.SecurityException: failure
from the 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>


Somebody can help me to find the error, and what more i have a login and a
pass to connect to MySQL but i don't know where i put these in the code....

Thanks
 
M

Morten Wennevik

Well, you would want to put the actual connection to the database in a
try/catch block and output error messages in a MessageBox or something as
the error messages are easier to read and more informative. Note that if
it fails, you should clean up code in a finally block.

You probably need to add User id=myuser;Password=mypass; in the
connectionstring.
 
S

Shamshins Itamar

Hi,

Username and password data can be specified in the oleDb
connection string with the "User ID" and "Password"
keywords.

Shamshins Itamar
-----Original Message-----
I want make a connection with MySQL (don't know why, i need, that's all
; ) ) in C#
but i don't know a lots the OleDbConnection, i have do that:

using System;
using System.Data.OleDb;

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

public void setConnection()
{
OleDbConnection myConnection = new OleDbConnection(
"Provider=MySQL ODBC 3.51 Driver;Data
Source=192.168.1.2;Database=golf;");
string mySelectQuery = "SELECT * FROM golfnews";

myConnection.Open();
OleDbCommand myCommand = new OleDbCommand (mySelectQuery, myConnection);
myCommand.CommandTimeout = 20;
OleDbDataReader myReader;
myReader = myCommand.ExecuteReader();

while (myReader.Read())
{
Console.WriteLine(myReader.ToString());
}
myReader.Close();

myConnection.Close();
}
}

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

but i receive in the output a security error :

exception does not generated :
Click to expand...
System.Security.SecurityException: failure
from the 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.IsolatedStorageFilePerm ission, 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
Click to expand...
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
Click to expand...
class="System.Diagnostics.EventLogPermission, System,
 
K

KaHuNa

Nothing have change!!!!!!!!


"Shamshins Itamar" <[email protected]> a écrit dans le
message de Hi,

Username and password data can be specified in the oleDb
connection string with the "User ID" and "Password"
keywords.

Shamshins Itamar
-----Original Message-----
I want make a connection with MySQL (don't know why, i need, that's all
; ) ) in C#
but i don't know a lots the OleDbConnection, i have do that:

using System;
using System.Data.OleDb;

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

public void setConnection()
{
OleDbConnection myConnection = new OleDbConnection(
"Provider=MySQL ODBC 3.51 Driver;Data
Source=192.168.1.2;Database=golf;");
string mySelectQuery = "SELECT * FROM golfnews";

myConnection.Open();
OleDbCommand myCommand = new OleDbCommand (mySelectQuery, myConnection);
myCommand.CommandTimeout = 20;
OleDbDataReader myReader;
myReader = myCommand.ExecuteReader();

while (myReader.Read())
{
Console.WriteLine(myReader.ToString());
}
myReader.Close();

myConnection.Close();
}
}

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

but i receive in the output a security error :

exception does not generated :
Click to expand...
System.Security.SecurityException: failure
from the 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.IsolatedStorageFilePerm ission, mscorlib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
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
Click to expand...
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
Click to expand...
class="System.Diagnostics.EventLogPermission, System,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help, Strange "An exception 'System.TypeInitializationException'has occurred in ... error. 3
Caspol exe issue 3
Console app and System.Security.SecurityException via network 1
System.Security.SecurityException 3
FileIO Exception and permissions 8
Embedding Windows Form Control to ASP .NET Security Problem 2
Calling Web Services from a Web Form throws CAS violation 1
Accessing com classes from c# 1

Top