Re: ODBC support Savepoint??

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 2000/01/30
Message-ID: <871l33$684$4@news.seed.net.tw>#1/1

Dana Jian <djian_at_trasa.com> wrote in message news:388f53c5$0$1379_at_news.choice.net...
> 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!

You should issue a BeginTrans command fitst to turn off the autocommit feature. Received on Sun Jan 30 2000 - 00:00:00 CST