🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: ODBC Trouble

#1453
From: Steve Hurst
Date: Tue, 30 Dec 1997 00:00
45 lines
2029 bytes
Steve Hurst wrote:

> 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


Oh, yeah...one more thing.  SQL-links....where do I get them, will they
work over a TCP/IP network, and will it support weird stuff like ISAM?

Thanks again.
Technical Details
Message-ID: <34A89BF9.A34260FA@xmission.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <34A89A74.8934A62@xmission.com>

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