Hi,

Recently switched from native Sybase driver to ODBC. When a stored procedure is executed, sqlPreview in SQLCA shows "?" (question marks) in place of variable values. (I am connecting to database with DisableBind=1,StaticBind=0 in dbParm.)

Declaration/execution is as follows (all variables have non-null values):

declare updateThis procedure for update_this
@suser_id = :ll_sUserID,
@spid = :ll_spid,
@history_date = :adt_historyDate ;

execute updateThis ;

SQL generated is:

execute update_this @suser_id =? , @spid =? , @history_date =?

This worked perfectly under native driver.

Thanks,

Russell Harvey