> I think you should omit the word "RELEASE" after the > "ROLLBACK". Will this still result in the closed DB connection that the "ROLLBACK RELEASE" used to give me? Jason Alburger HID/NAS/LAN Engineer L3/ATO-E En Route Peripheral Systems Support 609-485-7225 ----- Forwarded by Jason CTR Alburger/ACT/CNTR/FAA on 02/22/2006 10:20 AM ----- Ludwig Isaac Lim <ludz_lim@xxxxxxx om> To Jason CTR Alburger/ACT/CNTR/FAA@FAA 02/22/2006 10:15 cc AM Subject Re: [GENERAL] ecpg error --> DbPg_cre_sect_buf.pgc:1334: ERROR: syntax error at or near "RELEASE" Hi: I think you should omit the word "RELEASE" after the "ROLLBACK". Ludwig Lim --- jason.ctr.alburger@xxxxxxx wrote: > > > > > I'm relatively new to database programming & I've > inherited a system to > maintain that contains lots of embedded SQL. I'm > attempting to port my C > source code from RH 7.2 (with ecpg 2.8.0) to Mandrake > 10.0 (with ecpg > 4.1.1). ecpg 4.1.1 is generating an error which I did > not get on the > RH7.2 system with ecpg 2.8.0....It's telling me I have a > syntax error with > a "ROLLBACK RELEASE" (DbPg_cre_sect_buf.pgc:1334: ERROR: > syntax error at or > near "RELEASE"). Here's a snippet of the code in > error... > . > . > . __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com