🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

ODBC Trouble

#1452
From: Steve Hurst
Date: Mon, 29 Dec 1997 00:00
31 lines
1725 bytes
Hi,

I am attempting to set up ODBC Drivers for  unix based ISAM (iCOBOL)
tables for use with vdbase 5.5.  I am able to query the database using
Access and Crystal Reports 6.0, so I know the ODBC Drivers are set up
and working correctly.  I am able to use simple commands such as browse
from the command window and view the data, but when I try anything
complicated, such as querying, vdbase just locks up.  I'm pretty
confused at this point and have a few questions I was hoping someone
would know the answer to.

1.  Can I just use SQL syntax in the command window after setting the
database to the alias created with the configuration tool?  What about
DML?  I can use simple vdbase commands (BROWSE), so apparently I am not
limited to only SQL syntax.  How do I know what commands/syntax is
legal?

2.  Is it possible to build queries with the visual designer and use
them on this alias (just crashes now)?

3.  How would I go about performing a simple query on the alias, save
the results on my local machine as a .dbf?

Any suggestions, etc. would be much appreciated, I'm pulling my hair out
trying to figure this out and the documentation isn't making much sense
to me at this point.

Thanks,
Steve Hurst
shurst@xmission.com
Technical Details
Message-ID: <34A89A74.8934A62@xmission.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,3410d9da42f14c05,start
X-Google-Attributes: gidff5a1,public
From: Steve Hurst <shurst@xmission.com>
Subject: ODBC Trouble
Date: 1997/12/29
Message-ID: <34A89A74.8934A62@xmission.com>
X-Deja-AN: 311256148
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: None
Newsgroups: borland.public.vdbase.data.sql