Re: VDB 5.5, MS SQL Server

Article View: borland.public.vdbase.data.sql

Article #709

Back to borland.public.vdbase.data.sql Previous Next

#709

From: Keith G. Chuvala (TeamB)
Date: Tue, 18 Aug 1998 00:00

16 lines
1169 bytes

> We have successfully set up SQL server driver through ODBC and BDECFG so
> that we can see SQL databases in VDB, but cannot get transaction processing
> to work.

What does SQLMessage() return when it failes?  That might give us a good clue.

I've not used MS SQL Server, so this might not all apply to your situation,
but it's worth a shot.
Make sure you're passing the database name to BeginTrans()or have an explicit
SET DATABASE TO in effect, otherwise it assumes local tables.  Also pay mind
to the isolation level argument.

If worse comes to worse, use SQLExec to run transactional commands
explicitly.  

kgc

Technical Details

Message-ID: <35D9E3F6.D14F1FA0@DELETE_THIS.hit.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <6r0vrt$at84@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,4a7518fb5adb5140
X-Google-Attributes: gidff5a1,public
From: "Keith G. Chuvala (TeamB)" <kgc@DELETE_THIS.hit.net>
Subject: Re: VDB 5.5, MS SQL Server
Date: 1998/08/18
Message-ID: <35D9E3F6.D14F1FA0@DELETE_THIS.hit.net>
X-Deja-AN: 382400991
Content-Transfer-Encoding: 7bit
References: <6r0vrt$at84@forums.borland.com>
Content-Type: text/plain; charset=us-ascii
Organization: First Intermark Corp.
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message