SQL-String limited to 255 charakters?This is a discussion on SQL-String limited to 255 charakters? within the ODBC forums in Framework and Interface Programming category; 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... | ||||||||
| | ||||||||
| ||||||||
| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
02-18-2008, 12:12 PM
| |||
| |||
 SQL-String limited to 255 charakters? 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  |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
All times are GMT -5. The time now is 12:45 AM.
