Article View: borland.public.vdbase.data.sql
Article #1452ODBC Trouble
From: Steve Hurst
Date: Mon, 29 Dec 1997 00:00
Date: Mon, 29 Dec 1997 00:00
31 lines
1725 bytes
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-mailShow 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