Re: Problem about Bytea and SQL_C_CHAR

Hiroshi Inoue,

    Hi! I checked the crashing code and abstracted this:

    int data=1;
    int cb;
    rc = SQLPrepare(hstmt, "insert into test1(a) values(?)", SQL_NTS);
    rc = SQLBindParameter(hstmt, 1,
                        SQL_PARAM_INPUT,
                        SQL_C_TCHAR, SQL_INTEGER,
                        4, 0,
                        &data, MAX_STRING_SIZE,
                        &cb);
    rc = SQLExecute(hstmt);
    rc = SQLFreeStmt(hstmt, SQL_RESET_PARAMS);
    rc = SQLExecDirect(hstmt, "select * from test1", SQL_NTS);

    Table test1 has just one int column a.
    The SQLExecDirect crashed! Replace it with SQLBindParameter after that SQLFreeStmt will lead to crash! Please try
it.


>Han wrote:
>> The previous version I've been using was psqlodbc30.dll(driver name is "PostgreSQL + (Beta)", and I never changed
it.I just replaced the new 7.02.0006 dll, and the version number in the ODBC Data Source Administrator is right. 
>
>A simple test case passed here.
>Hmm could you send me the sample code if it's simple ?
>
>regards,
>Hiroshi Inoue
>    http://w2422.nsk.ne.jp/~inoue/

    regards,

　　　　　　　　Han
　　　　　　　　zhouhanok@vip.sina.com
　　　　　　　　　　2002-11-28