Displaying 7 results from an estimated 7 matches for "dbdata".
Did you mean:
cbdata
2009 Jul 15
1
RODBC results from stored procedure
...s to an actual
SQL Server table. Then I was able to make second call to sqlQuery with a
simple select statement for the results table and retrieve the results back
into R. My question is: can I get stored proc results directly back to R
without having to populate and query a results table?
>dbdata<-sqlQuery(conn,"sp_GetReturns,'2009-07-10','2009-07-14'")
>head(dbdata)
character(0) [....no data here....]
>dbdata<-sqlQuery(conn,"select * from returns order by Date asc")
[...success...]
>head(dbdata)
Date Asset1 Asset2....
200...
2002 Aug 20
0
RODBC/Solaris/Oracle - No Data
...xecute queries, I simply recieve a "No Data" message.
Debugging a query such as "select * from sometable", on the R side of things I receive the column names OK but when it calls down to RODBCFetchRows, the following object gets returned into erg, which in turn gets assigned to dbdata in sqlGetResults.
Browse[1]> dbdata
$data
$data[[1]]
NULL
$stat
[1] -1
I have executed the same query via unixODBC's isql using the same DSN and I receive a full result set with several rows.
Any suggestions please?
Thanks very much,
Phil
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-...
2017 Jan 12
2
Problems with bind9_dlz when rndc is reloaded
...neral: managed-keys-zone: next key refresh: 12-Jan-2017 12:12:03.317
12-Jan-2017 11:34:35.317 general: zone_settimer: managed-keys-zone : enter
12-Jan-2017 11:34:35.317 general: automatic empty zone: 10.IN-ADDR.ARPA
This is the destroy function used by bind9_dlz:
_PUBLIC_ void dlz_destroy(void *dbdata)
{
struct dlz_bind9_data *state = talloc_get_type_abort(dbdata, struct dlz_bind9_data);
state->log(ISC_LOG_INFO, "samba_dlz: shutting down");
dlz_bind9_state_ref_count--;
if (dlz_bind9_state_ref_count == 0) {
talloc_unlink(state, state-&...
2007 Apr 17
1
XEmacs on CentOS 5
Either I'm having a case of "now you see it, now you don't" or I'm
just plain stupid:
When upgrading one of my 4.4-machines I discovered, that XEmacs (my
text editor of choice; please no religious discussions) isn't part of
the distribution anymore. OK. I progressed without it (and removed the
old xemacs-packages because they were not working anymore). Then I
installed
2017 Jan 12
0
Problems with bind9_dlz when rndc is reloaded
...efresh:
> 12-Jan-2017 12:12:03.317
> 12-Jan-2017 11:34:35.317 general: zone_settimer: managed-keys-zone : enter
> 12-Jan-2017 11:34:35.317 general: automatic empty zone: 10.IN-ADDR.ARPA
>
> This is the destroy function used by bind9_dlz:
>
>
> _PUBLIC_ void dlz_destroy(void *dbdata)
> {
> struct dlz_bind9_data *state = talloc_get_type_abort(dbdata,
> struct dlz_bind9_data);
> state->log(ISC_LOG_INFO, "samba_dlz: shutting down");
>
> dlz_bind9_state_ref_count--;
> if (dlz_bind9_state_ref_count == 0) {
>...
2017 Jan 27
2
Problems with bind9_dlz when rndc is reloaded
...12:03.317
>> 12-Jan-2017 11:34:35.317 general: zone_settimer: managed-keys-zone : enter
>> 12-Jan-2017 11:34:35.317 general: automatic empty zone: 10.IN-ADDR.ARPA
>>
>> This is the destroy function used by bind9_dlz:
>>
>>
>> _PUBLIC_ void dlz_destroy(void *dbdata)
>> {
>> struct dlz_bind9_data *state = talloc_get_type_abort(dbdata,
>> struct dlz_bind9_data);
>> state->log(ISC_LOG_INFO, "samba_dlz: shutting down");
>>
>> dlz_bind9_state_ref_count--;
>> if (dlz_bind9_st...
2017 Jan 12
2
Problems with bind9_dlz when rndc is reloaded
Mathias,
Thanks for your reply.
Please, try to start your bind with some debug level and run commando "rndc reload" and see the end of the log. I saw samba source code and found the destroy dns function in dlz_bind9.c and called by turture blz_bind9.c.
When dlz_bind9.c is shutting down, I get this error when I try to update dns.
update failed: NOTAUTH Failed nsupdate: 2