[Mono-list] mdb problem on Linux

A Rafael D Teixeira rafael.teixeirabr@terra.com.br
Wed, 17 Nov 2004 10:13:43 -0200


Do you have libgda, and mdb-tools (http://mdbtools.sourceforge.net/)
installed? 

Our OLEDB ADO.NET implementation links to libgda and uses its configured
providers.

Also see the FAQ to know the limitations of mdbtools (
http://mdbtools.sourceforge.net/faq.html), being the most important that
it gives readonly access to mdb files.

It is well advised to migrate your data to some *real* database, like
PostgreSQL, instead of keeping it in a undocumented and limited file
format.

Good luck,

On Wed, 2004-11-17 at 06:31, mdb teszt wrote:
> Hi, 
> 
> I'm trying to get an OleDbConnection to my mdb database file. 
> I get an error message when I try use DataReader: 
> 
> Stack Trace: System.InvalidOperationException: State != Open 
> in <0x0008f> System.Data.OleDb.OleDbCommand:ExecuteReader 
> (System.Data.CommandBehavior) 
> in <0x00054> (wrapper remoting-invoke-with-check) 
> System.Data.OleDb.OleDbCommand:ExecuteReader 
> (System.Data.CommandBehavior) 
> in <0x00016> System.Data.OleDb.OleDbCommand:ExecuteReader () 
> in <0x00050> (wrapper remoting-invoke-with-check) 
> System.Data.OleDb.OleDbCommand:ExecuteReader () 
> in <0x000ad> ASP.monomdb_aspx:btnLekerdezes_Click 
> (object,System.EventArgs) 
> in <0x00069> (wrapper delegate-invoke) 
> System.MulticastDelegate:invoke_void_object_EventArgs 
> (object,System.EventArgs) 
> in <0x0009e> System.Web.UI.WebControls.Button:OnClick 
> (System.EventArgs) 
> in <0x00058> 
> System.Web.UI.WebControls.Button:System.Web.UI.IPostBackEventHa
> ndler.RaisePostBackEvent (string) 
> in <0x00016> System.Web.UI.Page:RaisePostBackEvent 
> (System.Web.UI.IPostBackEventHandler,string) 
> in <0x0003e> System.Web.UI.Page:RaisePostBackEvents () 
> in <0x002c3> System.Web.UI.Page:InternalProcessRequest () 
> in <0x000c2> System.Web.UI.Page:ProcessRequest 
> (System.Web.HttpContext) 
> in <0x002eb> ExecuteHandlerState:Execute () 
> in <0x00084> StateMachine:ExecuteState 
> (System.Web.HttpApplication/IStateHandler,bool&)
> 
> 
> What do I doing wrong? What is the right connect string?
> 
> Thanks!
> 
> werd
> 
> 
> _______________________________________________
> Mono-list maillist  -  Mono-list@lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
> 
> Esta mensagem foi verificada pelo E-mail Protegido Terra.
> Scan engine: VirusScan / Atualizado em 10/11/2004 / Versão: 1.5.2
> Proteja o seu e-mail Terra: http://www.emailprotegido.terra.com.br/
> 
> E-mail classificado pelo Identificador de Spam Inteligente Terra.
> Para alterar a categoria classificada, visite
> http://www.terra.com.br/centralunificada/emailprotegido/imail/imail.cgi?+_u=rafael.teixeirabr&_l=1100680338.995854.9781.corinto.terra.com.br
-- 
Rafael "Monoman" Teixeira 
Mono Hacker since 16 Jul 2001 - http://www.go-mono.org/
Mono Brasil Founding Member - http://monobrasil.redesolbrasil.org/
English Blog: http://monoblog.blogspot.com/
Brazilian Portuguese Blog: http://monoblog.weblogger.terra.com.br/