error when changing from Access to MySQL

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=dat abase"
%>

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

Re: error when changing from Access to MySQL

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" 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=dat abase"
> %>
>
> 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
>
>
>

Re: error when changing from Access to MySQL

On Fri, 18 Feb 2005 02:35:23 +0100, "TB"
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=da tabase"
>%>
>
>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.

Stop using ODBC:

http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Pro viders.htm#OLEDBProviderForMySQL

Jeff

Re: error when changing from Access to MySQL

I only agree with you half of the way: My question does not have a lot to
with ASP - but I couldn't know that beforehand. Secondly, the name of this
newsgroup terminates en "db", which means that we should be able discuss any
ASP-database related question, not just those related to Access or SQL
server.

TB

"Sylvain Lafontaine"
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" 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=dat abase"
>> %>
>>
>> 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
>>
>>
>>
>
>

Re: error when changing from Access to MySQL

I have followed your advice:
<%
set Conn=server.createobject("ADODB.connection")
Conn.open "Provider=MySQLProv;Location=mysql.domain.com;Data
Source=database;UserId=user;Password=pw;"
%>

And it now it works. Thanks.

TB

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