[freetds] Connection Pool - cant do multiple statements in one query?

Shaun Craig s.craig at andronics.com
Wed Aug 24 05:19:04 EDT 2005


Hi all,

I have a connection pool running with plenty of connections, i can run 
my single insert/update etc statements through the pool no problem.

Here's my problem, I am now trying to send a string through the pool 
that contains more than one statement in it (insert and an update), 
below is an example of the string.

INSERT INTO Inbound 
VehicleID,Address,DT,Latitude,Longitude,Speed,NSEW,CustomerID,Direction,Mileage,MaxSpeed,Odometer,AlertStatus) 
VALUES ('1110','350389833169207',CONVERT(DateTime,'24 August 2005 
09:42:04'),CONVERT(float,'54.605217'),CONVERT(float,'-6.165408'),CONVERT(float,'0.0'),'Ignition 
On','114',CONVERT(float,'0.0'),'0.00',0,CONVERT(int,'2401306'),'0') 
UPDATE VehicleStatus SET Latitude = CONVERT(float,'54.605217'), 
Longitude = CONVERT(float,'-6.165408'), Speed = CONVERT(float,'0.0'), 
Direction = CONVERT(float,'0.0'), AlertStatus = '0', NSEW = 'Ignition 
On', DT = CONVERT(DateTime,'24 August 200509:42:04'), Odometer = 
CONVERT(int,'2401306') WHERE VehicleID = '1110'

It wont let me do this, has anyone else had this problem?

I can run the above string through a single connection no problem, i can 
also put the string into tsql and it will insert it, so the problem must 
be with the pool.  Can it not handle 2 statements in the one string?

Any help would be great, thanks

Shaun.


-- 
Shaun Craig
Andronics Ltd. 
Tel: 02871273118
Web: http://www.andronics.co.uk



More information about the FreeTDS mailing list