ODBC driver does not support the requested properties.

[Fernando Espiritu]

Hello Guys,

I;m new to Mysql and we have a project on migrating SQL to MySQL and I'm not a developer guy to start with. This is a two-tier architecture running on AWS under windows 2012 64-bit platform and we are stuck in troubleshooting ODBC 5.1 version. I have successfully define the ODBC running for 32-bit. Our application comes from the 32-bit environment and just using ASP classic. Below are the steps already being done to reach this error message: ODBC driver does not support the requested properties.

1. already enabled the 32-bit application to "true" on the application pool used by the IIS

2. installed mysql-dobc-connector 5.1 version and can connect to the database successfully.

Below is the global.asa used.

Session("ConnStr") = "Provider=MSDASQL;DSN=AAAAA;server=" & session("ServerName") & ";UID=?????;pwd=?????;database=" & session("DBName")
Session("DocServerName") = "*******************amazonaws.com"
Session("DocConnStr") = "driver={MySQL ODBC 5.1 Driver};server=;port=1561;" & session("DocServerName") & ";UID=?????;pwd=?????;Option=3;"

Appreciated your help. Thanks