VS2012 MySQL ODBC - Parameters not passed to Dataset

• Ludo-ZX7R

  SSCrazy

  Points: 2882

  More actions

  October 22, 2013 at 3:29 am

  #300307

  Hi

  I have installed VS2012 and managed to get it connected to a MySQL Database. If anybody is interested, you have to download the 32 bits driver and create an ODBC User DSN.

  I can create a Data Source pointing to MySQL in my Report and create a Dataset to retrieve some data. So far so good.

  Now, when I want to include Parameters in my query, it looks like nothing is passed to the query.

  For example, the following query returns the string when used with a local SQL Database connection but returns nothing when using my MySQL Database connection.

  SELECT @Param AS Param

  I display the result in a textbox for test purposes.

  Any help welcome.

  Cheers

  Ludo

• Ludo-ZX7R

  SSCrazy

  Points: 2882

  More actions

  October 22, 2013 at 8:04 am

  #1660536

  Hi

  Sorry to reply to my own post but I have found a solution.

  In my query, instead of using the usual @Param, replace any variable by ? and map them in order.

  This solved my problem and I can now connect to MySQL from my Data Source.

  Cheers

  Ludo

  PS:Now going to open a new thread with a different problem. 🙁