Re: VDB 5.5, MS SQL Server

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

Article #711

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

#711

From: Christopher F. Neumann
Date: Tue, 18 Aug 1998 00:00

19 lines
1049 bytes

In addition to Keith's reply, I've previously set up VdB 5.6 & VdB 7.01 to
access tables from a SQL Server 6.5 database.

OPEN DATABASE MYDATA
SET DATABASE TO MYDATA
select * from mytable

at this point you should be able to browse the table, it will probably name
the alias SQL1 (or something like that)

You can also try

select * from :MYDATA:mytable


>> 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.

Technical Details

Message-ID: <6rdddb$q1l5@forums.borland.com>

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

References: <6r0vrt$at84@forums.borland.com> <35D9E3F6.D14F1FA0@DELETE_THIS.hit.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,4a7518fb5adb5140
X-Google-Attributes: gidff5a1,public
From: "Christopher F. Neumann" <CFNeumann@AOL.com>
Subject: Re: VDB 5.5, MS SQL Server
Date: 1998/08/18
Message-ID: <6rdddb$q1l5@forums.borland.com>
X-Deja-AN: 382499505
References: <6r0vrt$at84@forums.borland.com> <35D9E3F6.D14F1FA0@DELETE_THIS.hit.net>
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.0518.4
Organization: GoogolByte
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message