Home.... | log in.... | Pub my question! | Sign-up....
Java-index >> Archived Forums >> Socket Programming

MySQL 5 support

Hi,Do SJS ASP 4.0.2 support MySQL 5? If not when do you expect a new release with support for it?We need the new features in MySQL 5 and at the same time we're stucked with ASP. Tried using sjs asp 4.0.2 with mysql 5, however it gave some strange results. :(-- Knut J
[296 byte] By [Knut_J] at [2007-11-26 12:17:44]
«« Modify TictacToe server/client example from deitel "How To Program"
»» Wanna skip exact number lines while reading a file file
# 1

Mysql 5.x is not officially supported with 4.0.2 The supported mysql versions are 3.23, 4.0 and 4.1.

You should first try to create some DSN via admin console and click test - if test comes back fine - then you should be ok with all your application's asps.

Please note that starting with mysql 4.1 mysql db uses password hashing which is not supported by the drivers, so you have to use one of the workarounds described here:

see http://dev.mysql.com/doc/refman/4.1/en/password-hashing.html

I would say you should make ASP Server 4.0.2 work with mysql5 if you use the workaround for password hashing.

Sultal at 2007-7-7 14:55:40 > top of Java-index,Archived Forums,Socket Programming...
# 2

There's no problem connecting to the database. Usually I don't use DSN to connect to my databases, but the test you referred to works fine. However I抦 not sure what this test does beyond making a connection?

The problem occurs when I抦 doing a SELECT query and trying to get the fields from the recordset. In some way the fields don抰 return the expected content. Some fields return empty results, and some others returns content from the other fields. It seems to occur when at least one field are of the type DECIMAL(11,2). However, the same query works fine against mysql 4.1.

I'm executing a query with this code:

tmp.Open mySQLtmp, globalDBConn, 3, 3

Where tmp is type of ADODB.RecordSet, mySQLtmp is the query and globalDBConn is an active ADODB.Connection.

Any ideas?

Knut_J at 2007-7-7 14:55:40 > top of Java-index,Archived Forums,Socket Programming...
# 3
This could well be a bug in mysql 5.0, I just did a quick search and it came up with some mysql 5.0 bugs related to decimal data type processing, i.e: http://bugs.mysql.com/bug.php?id=16172I would recommend applying the latest mysql 5.0 patch and see if that helps.
Sultal at 2007-7-7 14:55:40 > top of Java-index,Archived Forums,Socket Programming...
Archived Forums
Socket Programming

Archived Forums New Topic

Archived Forums Hot Topic

Archived Forums

All Classified