"TB" <tbpostbox-googlegroups@yahoo.com> wrote in message
news:OXoWaoVFFHA.3376@TK2MSFTNGP12.phx.gbl...
>I am in the process of migrating from Access to MySQL
>
> I have already exported the data and the structure of the database and
> changed the connection string to:
>
> <%
> set Conn = server.CreateObject("ADODB.connection")
> Conn.open "driver={MySQL ODBC 3.51
> Driver};server=mysql.domain.com;uid=user;pwd=pw;database=database"
> %>
>
> However I have found that the following code, which works perfectly with
> Access, produces an error with MySQL:
>
> <%
> RS.Open strSQL, Conn, 1,3
> %>
>
> The error message is:
>
> "Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
> ODBC driver does not support the requested properties. "
>
> Any advice would be greatly appreciated.
>
> Thanks
>
> TB
>
>
>

<tbpostbox-googlegroups@yahoo.com> wrote:

>I am in the process of migrating from Access to MySQL
>
>I have already exported the data and the structure of the database and
>changed the connection string to:
>
><%
>set Conn = server.CreateObject("ADODB.connection")
>Conn.open "driver={MySQL ODBC 3.51
>Driver};server=mysql.domain.com;uid=user;pwd=pw;database=database"
>%>
>
>However I have found that the following code, which works perfectly with
>Access, produces an error with MySQL:
>
><%
>RS.Open strSQL, Conn, 1,3
>%>
>
>The error message is:
>
>"Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
>ODBC driver does not support the requested properties. "
>
>Any advice would be greatly appreciated.

wrote in message news:OZZ9DJYFFHA.2700@TK2MSFTNGP14.phx.gbl...
> You should try to find a more recent driver for MySQL - like an OLEDB
> provider - than an ODBC Driver 3.51. This is very old stuff.
>
> Otherwise, you may try with other parameters than 1 & 3. Your SQL query
> might also be in cause here.
>
> Finally, this has more to do with MySQL than with ASP; you should ask your
> question to a more appropriate newsgroup if you want to receive some good
> answers.
>
> S. L.
>
> "TB" <tbpostbox-googlegroups@yahoo.com> wrote in message
> news:OXoWaoVFFHA.3376@TK2MSFTNGP12.phx.gbl...
>>I am in the process of migrating from Access to MySQL
>>
>> I have already exported the data and the structure of the database and
>> changed the connection string to:
>>
>> <%
>> set Conn = server.CreateObject("ADODB.connection")
>> Conn.open "driver={MySQL ODBC 3.51
>> Driver};server=mysql.domain.com;uid=user;pwd=pw;database=database"
>> %>
>>
>> However I have found that the following code, which works perfectly with
>> Access, produces an error with MySQL:
>>
>> <%
>> RS.Open strSQL, Conn, 1,3
>> %>
>>
>> The error message is:
>>
>> "Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
>> ODBC driver does not support the requested properties. "
>>
>> Any advice would be greatly appreciated.
>>
>> Thanks
>>
>> TB
>>
>>
>>
>
>

"Jeff Cochran" <jeff.nospam@zina.com> wrote in message
news:4215d7ce.292195625@msnews.microsoft.com...
>
> Stop using ODBC:
>
> http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForMySQL
>
> Jeff