This topic is locked

ASP and MySQL 5 issues

5/27/2008 12:57:37 PM
ASPRunnerPro General questions
K
kbss731 author

Hello everyone,

I am having issues with ASP and MySQL 5.0. I have MySQL 5.1 driver. I am not able to login into that application. It was working fine with MySQL 3.51 ODBC. It is giving me this error
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)

ODBC driver does not support the requested properties.
THis is the code where it is erroring out ...

[indent]sql_get="select userid,password from connect"

get_ids.open sql_get, InitConn, 3, 3[/indent]
I have a DSN based connection. I tried DSN-Less and it throwing more errors.
Pls help.. My service provider is moving for 3.51 to 5.1 ODBC.
Thanks

KBSS <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=8606&image=1&table=forumtopics' class='bbc_emoticon' alt=':unsure:' />

Alexey admin 5/28/2008

Hi,
I'm not really sure how your question is related to ASPRunner.
Play with recordset.Open method parameters to find a combination that would work.

I.e.

get_ids.open sql_get, InitConn, 1, 2

get_ids.open sql_get, InitConn, 2, 2