Displaying 2 results from an estimated 2 matches for "sp_prepare".
Did you mean:
si_prepare
2001 Nov 13
1
RODBC
...e table, I get:
> test <- sqlQuery(channel,"select datetime, value from analoghistory where
tagname = 'a055-re-0020_ph_pv_flt' and datetime >= 'nov 1, 2001 2:00pm'")
> test
test
[1] "37000 201 [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure
'sp_prepare' expects parameter '@stmt', which was not supplied."
[2] "[RODBC]ERROR: Could not SQLPrepare"
Any thoughts?
Shawn Way
Tanox, Inc.
-------------- next part --------------
An HTML attachment wa...
2001 Nov 14
0
RODBC: Minor problem, I hope.
...get:
> test <- sqlQuery(channel,"select DateTime, value from AnalogHistory
> where Tagname = 'a055-re-0020_ph_pv_flt' and DateTime >= 'nov 1, 2001
> 2:00pm'")
> test
test
[1] "37000 201 [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure
'sp_prepare' expects parameter '@stmt', which was not supplied."
[2] "[RODBC]ERROR: Could not SQLPrepare"
Any thoughts?
Shawn Way
Tanox, Inc.
-------------- next part --------------
An HTML attachment was s...