2. ASPRunnerPro General questions
  3. [SOLVED]  MySQL ODBC 3.51 problem ?
This topic is locked
[SOLVED]

 MySQL ODBC 3.51 problem ?

 		3/16/2006 9:08:34 AM
ASPRunnerPro General questions
M
 magnum author

Hi,
I've buildt an application using ASPRunner4 pro and i'm having trouble opening menus, show search result etc in general. I have MySQL 5.0.18 - nt DB and using MySQL ODBC 3.51 system DSN Driver to connect

to db...
I tried different web servers and OS ( WIN200 PRO with IIS 5.0 with SP3 and SP4 / WIN XP with IIS 5.1 and SP2)
It looks like i'm getting erros all the way. I can log in and everything work great, but suddenly

i get this errors pointing at different asp files and rows int these files....
Any ideas ?
reg,

-----------------------------------------------------------------------------

Technical Information (for support personnel)
Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)

ODBC driver does not support the requested properties.

/telecom/mac_list.asp, line 795
Browser Type:

Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)
Page:

GET /telecom/mac_list.asp

----------------------------------------------------------------------------
Technical Information (for support personnel)
Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)

ODBC driver does not support the requested properties.

/telecom/utstyr_list.asp, line 804
Browser Type:

Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727)
Page:

GET /telecom/utstyr_list.asp

--------------------------------------------------------------------------

Technical Information (for support personnel)
Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)

ODBC driver does not support the requested properties.

/telecom/vlan_list.asp, line 770
Browser Type:

Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)
Page:

GET /telecom/vlan_list.asp
Sergey Kornilov admin 3/16/2006

Please zip and send generated ASP files to support@xlinesoft.com along with project file and your sample database for investigation.
M
 		magnum author 3/17/2006

[quote name='Magnum' date='Mar 16 2006, 03:08 PM' post='8590']
Hi,
Also got the following error:
Technical Information (for support personnel)
Error Type:

Microsoft VBScript runtime (0x800A01FB)

An exception occurred: 'setupRs.Open'

/telecom/utstyr_list.asp, line 804
Browser Type:

Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727)
Page:

GET /telecom/utstyr_list.asp
Time:

17. mars 2006, 08:31:33
Sergey Kornilov admin 3/17/2006

Hi,
please try the workaround descibed here:

http://www.asprunner.com/forums/index.php?showtopic=2611
M
 		magnum author 3/17/2006

Hi,

please try the workaround descibed here:

http://www.asprunner.com/forums/index.php?showtopic=2611


I have tried this one also, but i still have an unstable app. I still getting

the error's stated above. I have been running on MySQL connector 3.51.12

and i today installed the latest ODBC driver 3.51.13 with the same results...
Have you been able to check out the files i sent yesterday ?

(db, asp's and project files.....)
reg,
Sergey Kornilov admin 3/19/2006

I found the only reliable MySQL ODBC driver to be version 3.51.06.

You can find it at http://www.asprunner.com/files/MyODBC-3.51.06.exe
M
 		magnum author 3/19/2006

I found the only reliable MySQL ODBC driver to be version 3.51.06.

You can find it at http://www.asprunner.com/files/MyODBC-3.51.06.exe


Tested this older client, but this one does not support my database version (5.0.18_win32)

I get this message:

"Client does not support authentication protocol requested by server; Consider upgrading MySQL Client"........
Sergey Kornilov admin 3/20/2006

To fix this problem you need to run the following in MySQL command line:
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') WHERE Host = 'some_host' AND User = 'some_user';

mysql> FLUSH PRIVILEGES;
More info on this:

http://dev.mysql.com/doc/mysql/en/old-client.html
M
 		magnum author 4/7/2006

Hi. After installing the latest ASPRunner Build (92) things seem to work just fine ! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=8945&image=1&table=forumreplies' class='bbc_emoticon' alt='B)' />
V
 		viquar 6/13/2006

Hi. After installing the latest ASPRunner Build (92) things seem to work just fine ! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=9058&image=1&table=forumreplies' class='bbc_emoticon' alt='B)' />


Hi

I have the same problem. I have latest ASPRunner built, but the problem persists.

what all actions did you take before this problem got resolved.

Thank you
Sergey Kornilov admin 6/14/2006

Viq,
did you run the following?

mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') WHERE Host = 'some_host' AND User = 'some_user';

mysql> FLUSH PRIVILEGES;