how do I send a batch of commands w/ ODBC

S

sneaker

New Member
I'm pretty clueless about Progress, sorry. I'm not even sure if this is the right place to post this. I've been tasked with writing an application that updates a cutomer's progress database.

I'm using the MERANT 3.60 32-BIT Progress SQL92 v9.1D and am writing an application in VB.net that uses ADO.net for db access, specifically, the System.Data.Odbc library.
I can execute batched sql commands using sql explorer, using a semi-colon to separate the commands. for example:

update pub.users set lname = 'bush' where user_Id = 3;
update pub.users set lname = 'kerry' where user_Id = 5;

But when I try any tool that uses the ODBC driver, I get an error:

error message:
ERROR [42000] [DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Syntax error (7587)

source:
PGPRO915.DLL

Is "batching" of commands even something that is supported in Progress SQL92? I'm used to using sql server, where you can send multiple commands to the db server in one batch, saving you lots of network trips and handshaking.

I've tried a whole bunch of things, but nothing works. Has anyone tackled this problem already? Maybe its not even feasible with the ODBC driver I'm using. I have to send a lot of commands and if I can batch them, I think I can speed things up a great deal.

thanks very much in advance.
 
me again. I have no problems when I only try to send a single command, so there's nothing wrong with my configuration otherwise, I think.

thanks again.
 
Are you using commit statement with each of your update statement.

Pls. try this syntax in your tool.

update pub.users set lname = 'bush' where user_Id = 3;
commit;
update pub.users set lname = 'kerry' where user_Id = 5;
commit;

Rgds,
Debajyoti Mohanty.
 
You must log in or register to reply here.
Back
Top