Knowledgebase is a categorized collection of answers to frequently asked questions (FAQ) and articles. You can read articles in this category or select a subcategory that you are interested in.
I have a problem, with the plugin we have, SQL Database Professional fro Data Loggers. We are trying to run a stored procedure (Microsoft SQL Server 2008 R2) but we are facing some problems, with a simple INSERT works like charm, but I don't know how to run a procedure. What we are running now is:
Insert into ETK_GPSData
(DateStamp,
DataSourceName,
DataSourceFullName,
IDDevice,
Command,
GPSData,
GPSValidData,
GPSLatitude,
GPSLongitude,
IOPortStateData,
MilleMeter,
AlarmData,
ADImputData,
GPSTimeRecord,
GPSSpeed,
GPSHeading,
GPSDateRecord,
GPSLatitudeOrientation,
GPSLongitudeOrientation)
values
(:P1, :P2, :P3, :P4, :P5, :P6, :P7, :P8, :P9, :P10, :P11, :P12, :P13, :P14, :P15, :P16, :P17, :P18, :P19)
but I wish to run this procedure:
execute etk_gpsdata_spi(:P1, :P2, :P3, :P4, :P5, :P6, :P7, :P8, :P9, :P10, :P11, :P12, :P13, :P14, :P15, :P16, :P17, :P18, :P19)
but I get error message every time.
exec etk_gpsdata_spi :P1, :P2, :P3, :P4, :P5, :P6, :P7, :P8, :P9, :P10, :P11, :P12, :P13, :P14, :P15, :P16, :P17, :P18, :P19;
Article ID: 46
Category: Data Loggers
Date added: 2011-04-27 05:25:53
Views : 1450
Rating (Votes): (4)