Interesting that it compiles the code on the fly... Can you add new assembly references somehow? If you can add a reference to the MySQL DLL, you should be able to replace your usage of System.Data.Odbc.OdbcConnection with MySql.Data.MySqlClient.MySqlConnection. Otherwise, another option is to use a DbProviderFactory. You should be able to edit the application config file (I think it's called something like appname.exe.config) to add the MySQL factory to it. See http://msdn.microsoft.com/en-us/library/dd0w4a2z%28v=vs.100%29.aspx
In any case, you'd have to change all your ODBC clases to the corresponding generic class (eg. OdbcCommand to DbCommand) On Thu, Sep 13, 2012 at 12:34 AM, BadRobot <[email protected]> wrote: > The software is limited to odbc I believe, although, as a layman, don't > take > my word on that... > > I've uploaded the source for the plugin, remember that its compiled on the > fly at launch by the Procon application itself, and I am unable to supply > any build flags (unless I'm overlooking something) for the plugin as > suggested in > http://dev.mysql.com/doc/refman/5.1/en/connector-net-installation-unix.html > > http://paste2.org/p/2215522 > the Connection strings are around line 2791 > http://paste2.org/p/2215522#line-2791 > > I am unsure if anything can be modified to adapt to using the .net > connector > & the developer is unwilling to supply any support due to the unnatural > environment I assume. > Daniel Lo Nigro wrote > > > > Since you mentioned unixodbc, I assume you're using the ODBC MySQL > > connector. Is there any particular reason for this? Is it a limitation of > > the software you're using (does it only support ODBC)? > > > > Have you tried the native .NET connector instead? It's a fully-managed > > ADO.NET driver which doesn't require ODBC, and works with Mono. If you > can > > set the ADO.NET database provider the application uses, you should be > able > > to use it. See http://dev.mysql.com/downloads/connector/net/#downloads > > > > On Wed, Sep 12, 2012 at 10:34 AM, BadRobot <robster400@> wrote: > > > >> Ok, firstly, forgive me, as I'm far from experienced with these kind of > >> things :) > >> > >> I've got a Procon gameserver controller > >> (http://phogue.net/procon-frostbite/) running on mono 2.6.7 on Debian 6 > >> squeeze. > >> Procon has a player stats & chat logger, via a plugin, which sends > player > >> data to a mysql (5.1.63) db. with unixodbc 2.2.14, & MySQL connector > >> 5.1.11, > >> I have also tried MySQL connector 5.1.9 > >> It should be noted however, that the issue persists with Unbuntu 12.04, > >> Mono > >> 2.10.8.1 & unixodbc 2.2.14 > >> > >> I've moved the Procon setup from a Windows machine, where its been > >> working > >> great for months, & apart from the this logging problem, seems to be > fine > >> on > >> top of mono. > >> > >> So, what is happening? Instead of filling the db with playernames & chat > >> log > >> entries, its filling it with invalid chars. All data to be logged is > >> English > >> with no unusual characters. > >> Previous db entries while running on Windows display correctly on the > >> stats > >> website, new entries while running on Mono do not. > >> > >> When the procon plugin & sql db were all at default Latin1, it filled > the > >> db > >> with just questionmarks, so I assumed a charset issue, changed all > >> references of Latin1 to UTF8 in the Procon plugin source (its compiled > on > >> the fly at launch), and set MySQL to UTF8, and now it fills the db with > >> Asian/Chinese characters.... > >> > >> I've spent a long time with Google, and come to the conclusion somewhere > >> the > >> correct encoding or line endings are not being translated somehow either > >> by > >> Mono, or the unixodbc driver, but its a little above my head & I could > be > >> miles off the mark. > >> > >> Can anyone give me some suggestions on how to fix this? > >> Thanks. > >> > >> > >> > >> > >> > >> -- > >> View this message in context: > >> > http://mono.1490590.n4.nabble.com/Mono-odbc-passing-invalid-chars-to-MySQL-DB-tp4656587.html > >> Sent from the Mono - General mailing list archive at Nabble.com. > >> _______________________________________________ > >> Mono-list maillist - [email protected] > >> http://lists.ximian.com/mailman/listinfo/mono-list > >> > > > > _______________________________________________ > > Mono-list maillist - [email protected] > > http://lists.ximian.com/mailman/listinfo/mono-list > > > > > > > -- > View this message in context: > http://mono.1490590.n4.nabble.com/Mono-odbc-passing-invalid-chars-to-MySQL-DB-tp4656587p4656598.html > Sent from the Mono - General mailing list archive at Nabble.com. > _______________________________________________ > Mono-list maillist - [email protected] > http://lists.ximian.com/mailman/listinfo/mono-list >
_______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
