System Administrator wrote:
> I am using Solaris 2.7 with ColdFusion 4.0 and Myodbc-2.50.22a and
> I am trying to insert a very large file into a table and I am getting
> the following message:
> Error Diagnostic Information
> ODBC Error Code = S1090 (Invalid string or buffer length)
> [TCX][MyODBC]SQLBindParameter not used for all parameters
> Does anyone know how to rectify this? Also I have tried changing some
> parameters, for examples I boot up mysql with the following arguments:
> nohup $ledir/mysqld -O net_buffer_length=16M -O max_allowed_packet=512M
> -O max_sort_length=2048 --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR
> "$@" >> $err_log 2>&1
> and I still get the same error above... Is there an way to change the
> MYODBC buffer length?
> Thank you very much.
> Edward Valentini
Yes, you can specify it in the my.cnf configuration file on the client site:
set-variable = max_allowed_packet=512M
If you enable the option "Read options from my.cnf" in the DSN.