MySQL Connector for .Net

[Tanzy]

Any one come across this issue. The MySQL connector will not work in Medium Trust. There are 2 issues one that can be worked around by recompiling the connector and the second due to trust issues. Below is a link to some info that I found on the web

http://www.riversprint.com/rs/articl...QLWithNET.aspx

If anyone has any ideas on the best way to use MySQL with ASP.net please shout.

Ken

[RFH Reseller: askjim]

Can I ask why would you not want to use sql server in conjuntion with asp.net?

[Staff: Warren Ashcroft]

Interesting... I can make those changes to our custom .NET trust config if necessary?

[RFH Reseller: Sol]

I for one am up for having the SockPermission added since a custom component I use for email would then work

However, it might be better to put the mySql Connector in the GAC depending on how many users are using it.

Personally I feel anyone seriously using .Net would look at using MS SQL especially as the developer edition is freely available.

Before finishing, I will agree that there are times you would want to use mySql or even Oracle over MS SQL which mostly would be due to locking issues.

[Tanzy]

Can I ask why would you not want to use sql server in conjuntion with asp.net?

The simple reason is that I'm wanting to hook into my vBulliten database for the user info, and it means that I don't need to use 2 different databases for the domain.

[Tanzy]

Interesting... I can make those changes to our custom .NET trust config if necessary?

The sample that they provide in the link that I placed is too open for you to use I think. However, I have emailed you details on how it can be done and locked down more. Basically, what I have emailed you is a method that you can lockdown so that socket permissions are only granted that enable you to connect to MySql. I have done some testing, but you would need to make sure that you are happy with the security.

Ken

[Staff: Warren Ashcroft]

The sample that they provide in the link that I placed is too open for you to use I think. However, I have emailed you details on how it can be done and locked down more. Basically, what I have emailed you is a method that you can lockdown so that socket permissions are only granted that enable you to connect to MySql. I have done some testing, but you would need to make sure that you are happy with the security.

Ken

Thanks - I will look into this and hopefully should be able to get it added asap.