Re: ODBC support Savepoint??

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 27 Jan 2000 22:25:27 +0800
Message-ID: <38905557.2C88@yahoo.com>

Dana Jian wrote:
>
> Hi,
>
> I'm using Oracle8 as backend for VB6 project, and the ODBC connection string
> is
> gcnn.ConnectionString = "DRIVER={Microsoft ODBC for Oracle};SERVER=......;"
>
> In the VB program, Can I use
> gcnn.Execute "SAVEPOINT pt_new"
>
> to mark the savepoint ??
>
> I got the error say save point pt_new never established when gcnn.Execute
> "ROLLBACK TO SAVEPOINT pt_new" in VB!
>
> Any idea/help would be greatly appreciated!
>
> Dana
> djian_at_trasa.com

Maybe stick the calls in a PL/SQL procedure and call them...

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Jan 27 2000 - 08:25:27 CST