Hi<div><br></div><div>Currently attempting the to use a bind parameter on RHEL x86_64 talking to TimesTen 7.0.5 x86_64 using PHP 5.2.6 and SQLrelay 39.4.</div><div><br></div><div>php --> sqlrelay -- ODBC -> Times Ten.</div>
<div><br></div><div>The unixODBC (2.2.11) odbc.ini as follows:</div><div><br></div><div><div>[CUSTACC_CACHE]</div><div>Driver=/var/oracle/TimesTen/tt70/lib/libtten.so</div><div>DataStore=/var/oracle/TimesTen/tt70/info/CACC/CACC</div>
<div>DatabaseCharacterSet=WE8ISO8859P1</div><div>ConnectionCharacterSet=WE8ISO8859P1</div><div>Authenticate=0</div><div><br></div><div><br></div><div>With ODBC tracing on we receive this error:</div><div><br></div><div><div>
[ODBC][21083][SQLPrepareW.c][300]</div><div> Exit:[SQL_SUCCESS]</div><div>[ODBC][21083][SQLBindParameter.c][193]</div><div> Entry: </div><div> Statement = 0x1d031740 </div>
<div> Param Number = 0 </div><div> Param Type = 1 </div><div> C Type = -8 SQL_C_WCHAR </div><div> SQL Type = 1 SQL_CHAR </div>
<div> Col Def = 0 </div><div> Scale = 0 </div><div> Rgb Value = 0x1d19f360 </div><div> Value Max = 10 </div>
<div> StrLen Or Ind = (nil)</div><div>[ODBC][21083][SQLBindParameter.c][204]Error: 07009</div><div>[ODBC][21083][SQLError.c][342]</div><div> Entry: </div><div> Statement = 0x1d031740 </div>
<div> SQLState = 0x7fff8d66a170 </div><div> Native = 0x7fff8d66a188 </div><div> Message Text = 0x7fff8d669f70 </div>
<div> Buffer Length = 500 </div><div> Text Len Ptr = 0x7fff8d66a18e</div><div>[ODBC][21083][SQLError.c][379]</div><div> Exit:[SQL_SUCCESS] </div>
<div> SQLState = 07009 </div><div> Native = 0x7fff8d66a188 -> 0 </div><div> Message Text = [[unixODBC][Driver Manager]Invalid parameter index]</div>
<div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div>This issue has left me a little stumped, any help would be appreciated.</div><div><br></div><div><br></div><div><br></div><div><br></div><div>
Below is the PHP code I use to attempt the bind:</div><div><br></div><div><br></div><div><br></div><div><div><?php</div><div>echo "Connecting to SQLRelay\r\n";</div><div> $con=sqlrcon_alloc("192.168.163.247",9000,"","user1","password1",0,1) or die("Cannot Connect\r\n");</div>
<div>echo "Connected\r\n";</div><div> $cur=sqlrcur_alloc($con);</div><div> sqlrcur_prepareQuery($cur,"select rs_id, rs_group from qlog.resources where rs_id = :resourceid");</div><div> sqlrcur_inputBind($cur,"resourceid",'99903');</div>
<div># sqlrcur_validateBinds($cur) or die("binds are invalid - ".sqlrcur_errorMessage($cur));</div><div> echo "Executing Query\r\n";</div><div> sqlrcur_executeQuery($cur) or die ("Query Failed - ".sqlrcur_errorMessage($cur)."\r\n");</div>
<div> for ($row=0; $row<sqlrcur_rowCount($cur); $row++) {</div><div> for ($col=0; $col<sqlrcur_colCount($cur); $col++) {</div><div> echo sqlrcur_getField($cur,$row,$col);</div>
<div> echo ",";</div><div> }</div><div> echo "\n";</div><div> }</div><div><br></div><div>print_r($cur);</div><div><br></div><div>
sqlrcur_free($cur);</div><div>sqlrcon_free($con);</div><div>?></div><div>~ </div></div><div><br></div><div><br></div></div></div>