[Mono-list] Looking for advice on accessing MySQL database

[Luciano _]

Hi:
I'm using MySql 5.2.0 and it works.
The only difference with your connection String is that i use "Server" instead of "Data Source". 
You could try an alternative connections string like "server=myServerHost;user id=myUser;pwd=pass;database=myDB" (To test the connection, if it works, try the other parameters too after that)
If it doesn't help, a code or a Exception Message could help.Lucian0



> Date: Thu, 30 Oct 2008 14:27:30 -0700> From: louis at traglobal.com> To: mono-list at lists.ximian.com> Subject: [Mono-list] Looking for advice on accessing MySQL database> > > I have just started working with Mono using the 2.0.1 VMWare openSUSE 11.0> Image. I have gone through the basics and now want to try one of my> applications on Mono. It's a simple console app and when I run it through> Moma everything checks out.> > I copied the executable and MySQL.Data.dll over to openSuse and set up the> shell script as recommended. When I launch my app everything works right up> until Open() is called on the MySQLConnection object. It then throws an> exception and states that it could not connect to any of the MySQL> databases.> > I have tried with MySQL.Data.dll versions 5.1.7 and 5.2.3. My connection> string looks like the following:> > Database=dbname;Data Source=hostIp;User> ID=user;Password=password;Pooling=false;Connection Timeout=10;> > I tried also adding Protocol=socket;Port=3306; as recommended on someone's> blog but no luck there.> > The MySQL database is on my dev machine that the VM is running on. I can> ping from the VM to the host with no issues and I can access MySQL remotely> from my application on another Windows machine using the same credentials.> > I'm sure that a ton of people must be using MySQL so I'm hoping that I'm> just missing something simple.> -- > View this message in context: http://www.nabble.com/Looking-for-advice-on-accessing-MySQL-database-tp20255843p20255843.html> Sent from the Mono - General mailing list archive at Nabble.com.> > _______________________________________________> Mono-list maillist - Mono-list at lists.ximian.com> http://lists.ximian.com/mailman/listinfo/mono-list
_________________________________________________________________
Get more from your digital life.  Find out how.
http://www.windowslive.com/default.html?ocid=TXT_TAGLM_WL_Home2_082008
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-list/attachments/20081103/a9fb3eea/attachment.html