[Mono-devel-list] Using OleDB / Access database with Asp.Net
danielmorgan at verizon.net
Tue Jul 13 19:41:01 EDT 2004
See http://www.go-mono.com/ado-net.html ADO.NET stuff with Mono.
See http://www.go-mono.com/oledb.html about OleDb.
System.Data.OleDb requires libgda which can be found at
You need to look at the System.Data.OleDb source code to see how to get
it to work.
An alternative to OleDb is GDA# found in GTK#, but it requires libgda
If you're connecting to SQL Server 7/2000/2005, your best bet is
Otherwise, I would use System.Data.Odbc with unixODBC and FreeTDS.
From: mono-devel-list-admin at lists.ximian.com
[mailto:mono-devel-list-admin at lists.ximian.com] On Behalf Of Tizio
Sent: Tuesday, July 13, 2004 12:43 PM
To: Mono Develop List
Subject: [Mono-devel-list] Using OleDB / Access database with Asp.Net
in the end I'm having a running version of mono on my linux box. I'm
very interested on Asp.Net porting, 'cause I'd like to share my windows
webapps also under linux.
I use the XSP server. I got a simple asp.net page with some buttons and
First: are there problems with that? Maybe is better to use Apache and
mod_mono? 'Cause if it's the same thing, then I'll keep on using XSP.
As you can understand, I think I'll never develop an app without a
database on the backside. So, I first tried (just because I was curious)
a OleDB connection to a remote MSSQL, but that didn't, as specified in
So I tried a simpler OleDB connection to an access database file.. but
also this one doesn't works.
Following are a few lines on my page:
private void Page_Load(object sender, System.EventArgs e)
// Put user code to initialize the page here
OleDbConnection cn = new OleDbConnection();
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=" + Server.MapPath("db.mdb");
OleDbCommand cmd = new OleDbCommand("SELECT * FROM
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
this.DataGrid1.DataSource = ds;
Probably the provider is completely wrong: I refer, under VS/win to a
Jet provider.. what do I have to use? If anyone have working samples...
Mono-devel-list mailing list
Mono-devel-list at lists.ximian.com
More information about the Mono-devel-list