Displaying 5 results from an estimated 5 matches for "hstmt".
Did you mean:
stmt
2007 Apr 18
1
How to call stored procedure on iodbc
...So it uses 5 IN parameters as values for inserting a row in database
and returns its max id as out parameter.
Code Snippet is given below :--
SWORD returnCode = 0;
SDWORD bindReturnCode = 0;
RETCODE returnVal;
char sqlString[500];
memset(sqlString,0,sizeof(sqlString));
HSTMT hstmt = ptrDB->GetHSTMT();
returnVal = SQLAllocStmt(ptrDB->GetHDBC(), &hstmt);
if (returnVal == SQL_SUCCESS)
{
returnVal = SQLBindParameter(hstmt, 1, SQL_PARAM_OUTPUT,
SQL_C_SLONG, SQL_INTEGER,
0,0, &returnCode,0, &bindReturnCode);...
2005 Dec 05
0
about php-ODBC , unixODBC, freetds and MSSQL server
...---+-----------+---------------------------------------+
SQLRowCount returns 2516
2516 rows fetched
SQL>
then I look forward in the source files and I found
that both clients (php module and isql) use the same
function to get the number of rows:
from isql.c :
static void
WriteFooterNormal( SQLHSTMT hStmt, SQLCHAR
*szSepLine,
SQLLEN nRows )
{
SQLLEN nRowsAffected = -1;
printf( (char*)szSepLine );
SQLRowCount( hStmt, &nRowsAffected );
printf( "SQLRowCount returns %d\n", nRowsAffected
);
if ( nRows )
{
printf( "%d rows fetched\n", nRows );...
2008 Jan 10
1
Asterisk Realtime unixODBC timeout?
...DBC is using.) However, it doesn't seem to work. It takes over 3
minutes to timeout a connection and queries never seem to timeout, so
a channel waiting on a query never terminates.
I did notice that res_odbc.c never sets a timeout on the query using
something like this:
SQLSetStmtAttr( hstmt, SQL_ATTR_QUERY_TIMEOUT, (SQLPOINTER)10, 0 );
Has anyone tested this? Is it just failing for FreeTDS connections?
(I don't have anything else.)
Norman Franke
ASD, Inc.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk...
2010 Apr 28
0
asterisk core dumps after cdr database writes using odbc
...0x0044619f in tds_process_tokens (tds=0xb7938c90, result_type=0x2abb360,
done_flags=0x2abb364, flag=26900) at token.c:509
#5 0x00432e7d in odbc_process_tokens (stmt=0xa3f3658, flag=26900) at
odbc.c:3268
#6 0x0043736c in _SQLExecute (stmt=0xa3f3658) at odbc.c:3118
#7 0x00439561 in SQLExecDirect (hstmt=0xa3f3658,
szSqlStr=0x2abb640 "INSERT INTO cdr
(calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield)
VALUES ({ts '2010-04-28 10:01:26'},?,?,?,?,?,?"..., cbSqlStr=-3) at
odbc.c:3227
#8 0x00fa42...
2006 Feb 27
4
prepared query with RODBC ?
Dear List,
Would anyone know how to perform prepared queries with ROBC ?
I had a shot with some of the internal (non-exported) functions of the package
but ended up with a segfault, so I prefer asking around before
experimenting further...
Thanks,
Laurent