System.Data.OleDb requires libgda to work. libgda only works on Linux with GNOME 2.0. Also, OleDb is not actively maintained.
I suggest using the System.Data.SqlClient or System.Data.Odbc to connect to Microsoft SQL Server. However for System.Data.Odbc, this will require ODBC and an ODBC driver for SQL Server. On Windows, this should come with MDAC. On Linux, use unixODBC and freetds or use iODBC and freetds.
Alan Zebchuk <[EMAIL PROTECTED]> wrote:
Hi,
I'm trying to get one of our .NET applications running on mono and
currently receive the following error:
System.InvalidOperationException: State != Open
in <0x00260> System.Data.OleDb.OleDbCommand:ExecuteReader
(CommandBehavior behavior)
in (wrapper remoting-invoke-with-check)
System.Data.OleDb.OleDbCommand:ExecuteReader
(System.Data.CommandBehavior)
in <0x00028>
System.Data.OleDb.OleDbCommand:System.Data.IDbCommand.ExecuteReader
(CommandBehavior behavior)
in <0x00140> System.Data.Common.DbDataAdapter:Fill
(System.Data.DataSet dataSet, Int32 startRecord, Int32 maxRecords,
System.String srcTable, IDbCommand command, CommandBehavior behavior)
in <0x00064> System.Data.Common.DbDataAdapter:Fill
(System.Data.DataSet dataSet)
The Database that's being accessed is a MS SqL server runn ing on
another machine.
The Connection string currently looks like:
provider=SQLOLEDB;Server=192.168.1.15;database=my_database;uid=my_user;p
wd=my_password
Any advice is greatly appreciated,
Thanks,
Alan
_______________________________________________
Mono-list maillist - [email protected]
http://lists.ximian.com/mailman/listinfo/mono-list
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
_______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
