for( int index=0 ; index<(4*1024) ; ++index ){
SQLRETURN sqlres2 = SQLPutData(
sqlhStatement//SQLHSTMT StatementHandle,
, (SQLPOINTER)parameter2//SQLPOINTER DataPtr,
, 256//SQLLEN StrLen_or_Ind););
);
if( sqlres2==SQL_ERROR ) throw sqlres2;
printf( "=" );
}

// OdbcTest.cpp : Defines the entry point for the console application.
//

#include "mystdincludes.h"
using namespace std;

//#include <sql.h>
#include <sqlext.h>

#include "stdafx.h"

void showSqlReturn( SQLRETURN sqlres )
{
switch( sqlres ){
case SQL_SUCCESS: printf( "SQL_SUCCESS\n" ); break;
case SQL_SUCCESS_WITH_INFO: printf( "SQL_SUCCESS_WITH_INFO\n" ); break;
case SQL_NO_DATA: printf( "SQL_NO_DATA\n" ); break;
case SQL_NEED_DATA: printf( "SQL_NEED_DATA\n" ); break;
case SQL_ERROR: printf( "SQL_ERROR\n" ); break;
case SQL_INVALID_HANDLE: printf( "SQL_INVALID_HANDLE\n" ); break;
default: printf( "Unknown SQLRETURN code 0x%x (%d)\n",sqlres,sqlres); break;

}
}


int main( int argc, const char** args )
{
SQLRETURN sqlres = 0;
SQLHANDLE sqlhEnvironment = SQL_NULL_HENV;
SQLHANDLE sqlhConnection = SQL_NULL_HDBC;
SQLHANDLE sqlhStatement = SQL_NULL_HSTMT;
try{
sqlres = SQLAllocHandle( SQL_HANDLE_ENV, SQL_NULL_HANDLE, &sqlhEnvironment );
showSqlReturn( sqlres );
if( sqlres!=SQL_SUCCESS ) throw sqlres;


sqlres = SQLSetEnvAttr( sqlhEnvironment, SQL_ATTR_ODBC_VERSION
, (SQLPOINTER)SQL_OV_ODBC3, SQL_IS_INTEGER );
showSqlReturn( sqlres );
if( sqlres!=SQL_SUCCESS ) throw sqlres;


sqlres = SQLAllocHandle( SQL_HANDLE_DBC, sqlhEnvironment, &sqlhConnection );
showSqlReturn( sqlres );
if( sqlres!=SQL_SUCCESS ) throw sqlres;

SQLCHAR* connStrIn = new SQLCHAR[SQL_MAX_OPTION_STRING_LENGTH];
strcpy( (char*)connStrIn, "\
DRIVER={MySQL ODBC 5.1 Driver};\
UID=fr;PWD=vinda;server=192.168.73.1;database=fromfr;option=8\
" );
SQLSMALLINT connStrOutLength = SQL_MAX_OPTION_STRING_LENGTH;
SQLCHAR* connStrOut = new SQLCHAR[connStrOutLength];
sqlres = SQLDriverConnectA(
sqlhConnection//SQLHDBC ConnectionHandle, /* hdbc */
, NULL//SQLHWND WindowHandle, /* hwnd */
, connStrIn//SQLCHAR *InConnectionString, /* szConnStrIn */
, strlen((char*)connStrIn)//SQLSMALLINT InConnectionStringLength, /* cbConnStrIn */
, connStrOut//SQLCHAR *OutConnectionString, /* szConnStrOut */
, connStrOutLength//SQLSMALLINT OutConnectionStringCapacity, /* cbConnStrOutMax */
, &connStrOutLength//SQLSMALLINT *OutConnectionStringLengthPtr, /* pcbConnStrOut */
, SQL_DRIVER_NOPROMPT//SQLUSMALLINT DriverCompletion /* fDriverCompletion */
);
showSqlReturn( sqlres );
if( sqlres==SQL_ERROR ) throw sqlres;
connStrOut[ connStrOutLength ]=0;
printf( "Connection string returned: \"%s\"", connStrOut );


sqlres = SQLAllocHandle( SQL_HANDLE_STMT, sqlhConnection, &sqlhStatement );
showSqlReturn( sqlres );
if( sqlres==SQL_ERROR ) throw sqlres;


SQLCHAR* statementText = new SQLCHAR[1024];
strcpy( (char*)statementText, "insert into test(`101`,`102`,`PAGE_IMAGES`) values( 1,?,?)" );
sqlres = SQLPrepareA(
sqlhStatement//SQLHSTMT StatementHandle, /* hstmt */
, statementText//SQLCHAR *StatementText, /* szSqlStr */
, strlen((char*)statementText)//SQLINTEGER TextLength /* cbSqlStr */
);
showSqlReturn( sqlres );
if( sqlres==SQL_ERROR ) throw sqlres;

long parameter1 = 0;
SQLLEN parameter1Length = sizeof parameter1;
sqlres = SQLBindParameter(
sqlhStatement//SQLHSTMT StatementHandle,
, 1//SQLUSMALLINT ParameterNumber,
, SQL_PARAM_INPUT//SQLSMALLINT InputOutputType,
, SQL_C_SLONG//SQLSMALLINT ValueType,
, SQL_BIT//SQLSMALLINT ParameterType,
, 0//SQLULEN ColumnSize,
, 0//SQLSMALLINT DecimalDigits,
, (SQLPOINTER)&parameter1//SQLPOINTER ParameterValuePtr,
, 0//SQLINTEGER BufferLength,
, &parameter1Length//SQLLEN * StrLen_or_IndPtr);
);
showSqlReturn( sqlres );
if( sqlres==SQL_ERROR ) throw sqlres;

char* parameter2 = new char[1024];
for( int index=0 ; index<1024 ; ++index ) parameter2[index]='A'+index%26;
SQLLEN parameter2Indicator = SQL_DATA_AT_EXEC;

sqlres = SQLBindParameter(
sqlhStatement//SQLHSTMT StatementHandle,
, 2//SQLUSMALLINT ParameterNumber,
, SQL_PARAM_INPUT//SQLSMALLINT InputOutputType,
, SQL_C_BINARY//SQLSMALLINT ValueType,
, SQL_VARBINARY//SQLSMALLINT ParameterType,
, 10*1024*1024//SQLULEN ColumnSize,
, 0//SQLSMALLINT DecimalDigits,
, (SQLPOINTER)222//SQLPOINTER ParameterValuePtr,
, 3*1024*1024//SQLINTEGER BufferLength,
, &parameter2Indicator//SQLLEN * StrLen_or_IndPtr);
);
showSqlReturn( sqlres );
if( sqlres==SQL_ERROR ) throw sqlres;


sqlres = SQLExecute( sqlhStatement );

if( sqlres==SQL_NEED_DATA ){
SQLPOINTER sqlp = 0;
sqlres = SQLParamData(
sqlhStatement//SQLHSTMT StatementHandle,
, &sqlp//SQLPOINTER * ValuePtrPtr
);
showSqlReturn( sqlres );
if( sqlres==SQL_ERROR ) throw sqlres;
if( sqlres==SQL_NEED_DATA && sqlp==(SQLPOINTER)222 ){
for( int index=0 ; index<(4*1024) ; ++index ){
SQLRETURN sqlres2 = SQLPutData(
sqlhStatement//SQLHSTMT StatementHandle,
, (SQLPOINTER)parameter2//SQLPOINTER DataPtr,
, 256//SQLLEN StrLen_or_Ind););
);
if( sqlres2==SQL_ERROR ) throw sqlres2;
printf( "=" );
}
}
}
SQLPOINTER sqlp = 0;
sqlres = SQLParamData(
sqlhStatement//SQLHSTMT StatementHandle,
, &sqlp//SQLPOINTER * ValuePtrPtr
);
showSqlReturn( sqlres );
if( sqlres==SQL_ERROR ) throw sqlres;

}catch( const char* E ){
printf( "Error: %s\n", E );
return 1;
}catch( const string& E ){
printf( "Error: %s\n", E.c_str() );
return 2;
}catch( const wchar_t* E ){
printf( "Error: %S\n", E );
return 3;
}catch( SQLRETURN E ){
printf( "Exception handling...\nSql Error: 0x%x (%ld)\n", E, E );
SQLRETURN sqlres2 = SQL_SUCCESS;
SQLCHAR* sqlstate = new SQLCHAR[ 16 ];
SQLINTEGER nativeError = 0;
SQLSMALLINT bufferLength = 1024;
SQLCHAR* message = new SQLCHAR[ bufferLength ];
SQLSMALLINT textLength = 0;

sqlres2 = SQLGetDiagRecA
( SQL_HANDLE_DBC//SQL_HANDLE_ENV//SQLSMALLINT HandleType,
, sqlhConnection//sqlhEnvironment//SQLHANDLE Handle,
, 1//SQLSMALLINT RecNumber,
, sqlstate//SQLCHAR * SQLState,
, &nativeError//SQLINTEGER * NativeErrorPtr,
, message//SQLCHAR * MessageText,
, bufferLength//SQLSMALLINT BufferLength,
, &textLength//SQLSMALLINT * TextLengthPtr
);
showSqlReturn( sqlres2 );
if( sqlres2!=SQL_SUCCESS ) return 3;
printf( "SQL State is: %s\n", &sqlstate );
printf( "Message is: %s\n", message );

return 3;
}catch( ... ){
printf( "Error: Unknown.\n" );
return 10;
}

return 0;
}

set-variable = max_allowed_packet=16M