search for: sqlrowcount

...C driver, but, my surprise came when I use the isql command (came with the unixODBC package) and the number of rows is returned correctly in the same machine and with the same query. the following is the output from isql command: +--------------+-----------+---------------------------------------+ 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 nRowsA...

...| | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> +------------+ | ?column? | +------------+ | 1 | +------------+ SQLRowCount returns 1 1 rows fetched Here are the details of the stuff I am using OS :- fedora core 6 kernel 2798 (Was able to build asterisk on it) asterisk-1.4.1 libpri-1.4.0 zaptel-1.4.0 asterisk-addons-1.4.0 (Also tried with or without) Can someone please help, I am very new to asterisk. Regards, Sanja...

...------------------------+ | Database | +-----------------------------------------------------------------+ | information_schema | | +-----------------------------------------------------------------+ SQLRowCount returns 2 2 rows fetched ---4: GNU R TEST > library(RODBC) > odbcDataSources() MySQL-data "/home/me/opt/mysql-connector-odbc/lib/libmyodbc5.so" > t.con<-odbcConnect("MySQL-data") > t.con RODBC Connection 1 Details:...

...] | | quit | | | +---------------------------------------+ SQL> select sysdate from dual; +--------------------+ | SYSDATE | +--------------------+ | 2010-02-26 13:57:00| +--------------------+ SQLRowCount returns -1 1 rows fetched SQL> quit; However, when I started up R console on the machine and test the RODBC connectivity to oracle, I got following error: [oracle@ROracleTest R]$ R R version 2.9.2 (2009-08-24) Copyright (C) 2009 The R Foundation for Statistical Computing ISBN 3-900051-07-0 R...

...etup=/usr/lib/odbc/libodbcpsqlS.so Debug = 1 CommLog = 1 root@pbx:# echo "select * from ast_config where filename='iax.conf' and commented=0 order by filename,cat_metric desc,var_metric asc,category,var_name,var_val,id" | isql Asterisk <lot of output from table> SQLRowCount returns 39 39 rows fetched So the odbc thingy works! root@pbx:# cat res_config_odbc.conf [settings] table = ast_config connection = myconn root@pbx:# cat res_odbc.conf [myconn] dsn=Asterisk username=XXXXX password=XXXXX preconnect=yes root@pbx:# cat extconfig.conf [settings] age...

...| >> | | >> +---------------------------------------+ >> SQL> SELECT e_extnum FROM ext LIMIT 1; >> +---------+ >> | e_extnum| >> +---------+ >> | 6011 | >> +---------+ >> SQLRowCount returns 1 >> 1 rows fetched >> SQL> quit >> >> >> I going to sed & diff... these files to see what I find. If anyone has >> any suggestions of tools for this type of investigation, I would love to >> hear about it. >> >> John >> &gt...

...;m reading a unixODBC ODBC driver. When I run from isql and try the same query, I get, as I might expect, a bunch of blanks. SQL> select top 5 NULL from product +------------+ | | +------------+ | | | | | | | | | | +------------+ SQLRowCount returns 5 5 rows fetched It shouldn't be relevant, but the ODBC is powered by a FreeTDS driver hooked to an MS SQL Server 2000 Professional. I noticed a previous note from Professor Ripley reporting that this problem had been fixed with a version of RODBC from long ago. I am running RODBC ver...

...tablename] | | quit | | | +---------------------------------------+ SQL> select bloqueada from funciones where extension='750' +-----------+ | bloqueada | +-----------+ | 0 | +-----------+ SQLRowCount returns 1 1 rows fetched SQL> Thanks in advance, -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090507/e5918e22/attachment.htm

...mgcp.so: undefined symbol: ast_pktccops_gate_alloc loader.c: Error loading module 'cdr_adaptive_odbc.so': /usr/lib/asterisk/modules/cdr_adaptive_odbc.so: undefined symbol: SQLFetch loader.c: Error loading module 'cdr_odbc.so': /usr/lib/asterisk/modules/cdr_odbc.so: undefined symbol: SQLRowCount loader.c: Error loading module 'cel_odbc.so': /usr/lib/asterisk/modules/cel_odbc.so: undefined symbol Any ideas? Thanks, Vieri

...on (1.0.5) of ibm_db Rails Adapter/driver for IBM dataservers is now available. This release of gem provides support for ruby-1.9.1. With this support for 1.9.1 the ibm_db gem works fine as a ASCII driver, with unicode support to follow in the coming releases. This release also provides support for SQLRowcount feature in the driver. This release contains fix for the bugs raised, whose details can be found in the change log. Go through the section below for selecting the right packages for your respective environments. Selection of packages: - Unix/Linux/MacOS platforms: - ibm_db-1.0.5.gem...

...| > | quit | > | | > +---------------------------------------+ > SQL> SELECT e_extnum FROM ext LIMIT 1; > +---------+ > | e_extnum| > +---------+ > | 6011 | > +---------+ > SQLRowCount returns 1 > 1 rows fetched > SQL> quit > > > I going to sed & diff... these files to see what I find. If anyone has any > suggestions of tools for this type of investigation, I would love to hear > about it. > > John >

Thanks for each of your inputs. It was not a configuration issue as odbcinst.ini does not reference the mysql subdirectory. Rather than use Alexander's url, I ran: yum -y install centos-release-openstack-ocata yum -y install mariadb-server ...the cloud repository provides the properly pathed file. # repoquery -l mariadb-server mariadb-libs | grep lib64 | grep libmysqlclient

...p [tablename] | | quit | | | +---------------------------------------+ SQL> select 1 +---------------------+ | 1 | +---------------------+ | 1 | +---------------------+ SQLRowCount returns 1 1 rows fetched The extconfig.conf file gets parsed, and looks like this: [settings] musiconhold.conf => odbc,asterisk_development,asterisk_files The modules.conf contains only: [modules] preload => res_odbc.so preload => res_config_odbc.so autoload=yes On starting Asterisk w...

...???????????????????????????????????????????????????????????| | queue_log???????????????????????????????????????????????????????????????????????????? | | queue_member_table?????????????????????????????????????????????????????????? | +-----------------------------------------------------------------+ SQLRowCount returns 4 4 rows fetched Each table has?all of the required fields, some people suggested that queue_name is missing but it's not. I am getting the following errors from the asterisk console: ? node1*CLI> queue show support support has 0 calls (max unlimited) in 'rrmemory' strateg...