Displaying 14 results from an estimated 14 matches for "sqlrowcount".
2005 Dec 05
0
about php-ODBC , unixODBC, freetds and MSSQL server
...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...
2007 Mar 29
2
Problem while using asterisk Realtime
...|
| 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...
2011 Jul 17
1
ODBC MySql DB: sqlQuery empty
...------------------------+
| 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:...
2010 Feb 26
1
need help to resolve RODBC error
...] |
| 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...
2004 Dec 31
1
Help With Configuration From Odbc
...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...
2017 Nov 03
1
Maria 10 breaks unixodbc mysql connector
...|
>> | |
>> +---------------------------------------+
>> 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
>>
>...
2004 Jul 14
0
RODBC repeated rows problem
...;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...
2009 May 07
1
func_odbc.c: Unable to execute query
...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
2012 Sep 25
2
undefined symbols
...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
2009 Mar 25
0
IBM_DB version 1.0.5 supports ruby-1.9.1
...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...
2017 Nov 03
0
Maria 10 breaks unixodbc mysql connector
...|
> | 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
>
2017 Oct 31
4
Maria 10 breaks unixodbc mysql connector
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
2011 Dec 16
3
ODBC problem - static realtime file not loading
...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...
2013 Apr 19
1
Dynamic realtime + queues.conf Unresolved
...???????????????????????????????????????????????????????????|
| 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...