Hi Bob,
Using Mono built from svn r89680 and mojoPortal from svn trunk, if I change the reference from mojoPortal.Business to use mojoPortal.Data.MySql instead of mojoPortal.Data.pgsql and then build with MonoDevelop it works fine for me with MySql.
Currently I'm having an error using pgsql but I'm not sure it might be something funky about my installation of pgsql
Npgsql.NpgsqlException:
could not load library "/usr/lib/postgresql/plpgsql.so":
/usr/lib/postgresql/plpgsql.so: undefined symbol: get_func_arg_info
Severity: ERROR
Code: 58P01
at Npgsql.NpgsqlConnector.CheckErrors () [0x00000]
at Npgsql.NpgsqlConnector.CheckErrorsAndNotifications () [0x00000]
at Npgsql.NpgsqlCommand.ExecuteCommand () [0x00000]
at Npgsql.NpgsqlCommand.ExecuteScalar () [0x00000]
at (wrapper remoting-invoke-with-check) Npgsql.NpgsqlCommand:ExecuteScalar ()
at mojoPortal.Data.NpgsqlHelper.ExecuteScalar
(Npgsql.NpgsqlConnection connection, CommandType commandType,
System.String commandText, Npgsql.NpgsqlParameter[] commandParameters)
[0x00000]
at mojoPortal.Data.NpgsqlHelper.ExecuteScalar (System.String
connectionString, CommandType commandType, System.String commandText,
Npgsql.NpgsqlParameter[] commandParameters) [0x00000]
at mojoPortal.Data.DBSiteUser.UpdateLastActivityTime (Guid userGuid,
DateTime lastUpdate) [0x00000]
at mojoPortal.Business.SiteUser.UpdateLastActivityTime () [0x00000]
at mojoPortal.Web.Global.Application_EndRequest (System.Object
sender, System.EventArgs e) [0x00000]
at (wrapper delegate-invoke)
System.MulticastDelegate:invoke_void_object_EventArgs
(object,System.EventArgs)
at System.Web.HttpApplication.PipelineDone () [0x00000]
I posted the problem to he Mono mailing list but haven't any idea whats the real cause. Runninng the same web code on windows and accessing the very same db on the linux machine it works fine.
Joe