Article View: borland.public.vdbase.data.sql
Article #1453Re: ODBC Trouble
From: Steve Hurst
Date: Tue, 30 Dec 1997 00:00
Date: Tue, 30 Dec 1997 00:00
45 lines
2029 bytes
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-mailReferences:
<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