From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Han <zhouhanok(at)vip(dot)sina(dot)com> |
Cc: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Problem with SQL_LONGVARBINAY |
Date: | 2003-03-21 05:18:31 |
Message-ID: | 3E7AA0A7.C6DB2B90@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Sorry for the delay.
Please try the snapshot dll at
http://www.geocities.jp/inocchichichi/psqlodbc/.
regards,
Hiroshi Inoue
http://www.geocities.jp/inocchichichi/psqlodbc/
Han wrote:
>
> Hi,
> There's a problem when insert a SQL_LONGVARBINARY(lo) column in the following way:
> Use SQLBindParameter(...SQL_DATA_AT_EXEC)
> and SQLParamData, SQLPutData.
> The last time SQLParamData revoke a crash!
> This is the sample code:
> for (...)
> {
> sdw = SQL_DATA_AT_EXEC;
> rc = SQLBindParameter(hstmt, w, SQL_PARAM_INPUT,
> SQL_C_TCHAR, rgFields[ind].wSQLType,
> rgFields[ind].precision, rgFields[ind].scale,
> (LPTSTR)(((UDWORD)ind)+BIND_PARM_OFFSET), 0, &sdw);
> }
> rc = SQLExecDirect(hstmt, lpqt->sz, SQL_NTS);
> if (SQL_NEED_DATA != rc)
> return;
> for(ind = 0; ind <= cTypes; ind++)
> {
> rc = SQLParamData(hstmt, &ptr);
> if(rc != SQL_NEED_DATA)
> break;
>
> pch = qtMakeData(...);
>
> if(*pch) {
> rc = SQLPutData(hstmt, pch, SQL_NTS);
> } else {
> rc = SQLPutData(hstmt, (LPTSTR)IGNORED, SQL_NULL_DATA);
> }
> }
>
> please check, thanks and regards!
From | Date | Subject | |
---|---|---|---|
Next Message | pg | 2003-03-21 05:48:47 | Re: password leak in mylog thru win odbc |
Previous Message | Hiroshi Inoue | 2003-03-21 05:13:17 | Re: password leak in mylog thru win odbc |