SQL-String limited to 255 charakters?

[tsd]

Hello,

I try to create a connection via visual basic 6 to a MySQL-Database (ODBC
Version 3.51, Visual Basic Version 6, Word-Version 2000):

Set cnTest = New adodb.Connection
Set rsTest = New adodb.Recordset
strConnect = "DSN=xy"
cnTest.Open (strConnect)

This works very well.
Also the following lines:

rsTest.ActiveConnection = cnTest
rsTest.Open "Select * from kunden where nummer like '444%'"

But if the SQL-String-lenght is more than 255 charakters, the String will be
cutted.

Can someone help to bypass the problem?

Thanks.
Tom