odbc column 32 characters

odbc SQLBindCol $StatementHandle 2 SQL_TEXT “email”  10 pcbValue1

Try updating the buffer size to a larger value. You should be only getting 10 bytes with this value. I would say to set it to 2000. or use SQLDescribeCol to get the size of the field.

Check the parameters for the initialisation as well. I think you will need SQL_NTS if you dont want to see data from another buffer in your variable.

Have to also be carefull not to select a null value. put something in your select to change it to a space or something, otherwise it will error.

There are a couple of modes for the sql to be performed.

I can’t remember the exact details, but for one case it will put whatever is in the buffer in the variable, as seen in your case where there is garbage data at the end.

You can use SQL_NTS to overcome this, but you have to make sure the data is not NULL, otherwise it will fail.

Most of what I have is something along the lines of the following:

set mySql “select nvl( field,’ ‘) from table”

odbc SQLExecDirect $HSTMT $mySql SQL_NTS

nvl sets the result to a space if it is null.

For the initialisation, I’m using an oracle database, and have something along the lines of:

odbc SQLAllocHandle SQL_HANDLE_ENV SQL_NULL_HANDLE HENV

odbc SQLSetEnvAttr $HENV SQL_ATTR_ODBC_VERSION  SQL_OV_ODBC3 0

odbc SQLAllocHandle SQL_HANDLE_DBC $HENV HDBC

odbc SQLDriverConnect $HDBC NULL

       “DSN=Oracle Wire Protocol; HostName=$aHost; PortNumber=$aPort; LogonID=$aLogin; Password=$aPasswd; SID=$aSid;” SQL_NTS

       OutConnectionString 246 StringLengthPtr SQL_DRIVER_NOPROMPT

I think your bind is wrong.  Here is one of mine

odbc SQLBindCol $hstmt $cnt SQL_C_CHAR data($cnt) 500000 SQL_NTS