roy barlow

roy barlow

  • NA
  • 13
  • 0

dBase connection Error

Nov 27 2007 9:55 AM

I am trying to connect to an access dBase on my c:\drive. I've got a class that creates the connection string....

class DBConnection

{

private static string DBString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\myTest_db.mdb";

public static System.Data.OleDb.OleDbConnection GetDBConnection()

{

System.Data.OleDb.OleDbConnection myConnection=new OleDbConnection();

myConnection.ConnectionString = DBString;

return myConnection;

}

Back on my form, I try to open a connection to the dB but I get the following error

Request for the permission of type 'System.Data.OleDb.OleDbPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed

on the line indicated below. Any help appreciated.

Thanks in advance.

private void btnLogin_Click(object sender, EventArgs e)

{

//Create instance of command

System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand();

string user=userTxt.Text;

string password = passwordTxt.Text;

command.CommandText = "SELECT u.userID FROM myTable AS u WHERE (((u.userName)='" + user + "') AND ((u.password)='" + password + "'));";

command.Connection = DBHelper.GetDBConnection();

command.Connection.Open(); //ERROR HERE//

 


Answers (1)