ASP.NET 2 connection to MySQL

[captain]

Hi,

I've just signed up to RFH and so far I'm very impressed. I've just hit a bit of a problem with connecting to a MySQL database from ASP.NET 2.0

I've created the MySQL database and user with no problems, copied the data across successfully, but get the following error when trying to access the data with ASP.NET 2 code :

Security Exception : That assembly does not allow partially trusted callers.

Having tried to set the trusted level to medium in my web.config, which didn't work, I'm now a bit stuck....

Can anyone please help ? Is there a best practice to be followed when connecting to MySQL from ASP.NET 2.0 ? Do I need to use MSSQL instead ?

Thanks.

[Staff: Warren Ashcroft]

Can you post your connection code?

[captain]

Here is my connection code :


Dim cmdSelect AsNew MySqlCommand
Dim conContent AsNew MySqlConnection
Dim dadContent As MySqlDataAdapter
Dim dstContent As Data.DataSet
conContent = New MySqlConnection(ConfigurationManager.ConnectionStr ings("dbname").ConnectionString)
dadContent = New MySqlDataAdapter("SELECT content.Title,content.Summary,content.ID,content.I mage,types.title AS title2 FROM content JOIN types ON content.type = types.id ORDER BY content.ID DESC LIMIT 10", conContent)
conContent.Open()
dstContent = New Data.DataSet
dadContent.Fill(dstContent)
dgrdContent.DataSource = dstContent
dgrdContent.DataBind()
conContent.Close()

My connection string is stored in the web.config file as follows (with ip address,id and password changed for the purpose of this reply):

<connectionStrings>
<addname="dbname"connectionString="Server=myipaddress; user id=myid; password=mypassword; database=prcontent;Allow Zero Datetime=true;"
providerName="MySql.Data.MySqlClient" />

</connectionStrings>


Thanks for your help. This way of connecting may not be the most efficient or up to date - but it works fine on localhost during testing.

[captain]

Good news - I've solved my problem.

I approached it from another angle by doing the following :

1. Created a new ODBC dsn using Helm.
2. Created a new SqlDataSource using ASP.NET 2.0 and this new dsn (to MySQL database)
3. Used a GridView to access the data using the new SqlDataSource

This all works perfectly now.

Thanks anyway - I should have tried this first.....

[Staff: Warren Ashcroft]

No problem, glad you got it working with ODBC