🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Where can I find a summary of how to use Local SQL?

#596
From: Gerald Lightsey
Date: Mon, 14 Sep 1998 00:00
34 lines
2015 bytes
In article <6tie6f$mmr7@forums.borland.com>, eryk@compuserve.com says...

Eryk,

I found it.  Thanks a lot.

> >I would appreciate receiving this file. Although I have Delphi 4 I have
> >not found a help file for SQL.
> 
> 
> Look for localsql.hlp in your BDE directory ...usually ..\Program
> Files\Borland\Common Files\BDE\localsql.hlp.
> 
While I have your ear.  I have been trying to connect to an Access file 
through the BDE.  The one likely looking candidate, when I go through the 
BDE Administrator, is an alias already partially set up named "MS Access 
97 Database".  I have added the path to my Access database and saved in 
the BDE Administrator.  Whether using Delphi 4 or Visual dBASE 7.0 I can 
add a Database object to a form and change its alias to "Ms Access 97 
Database".  In Delphi I then click on Connected and it wants me to input 
a database name.  I enter "pref" (the Access database is PREF.MDB).  Then 
set Connected to true.  In Visual dBASE 7.0 I click on Active and change 
it to true.

In either case, I get a dialog asking for User Name and Password.  At 
this point I don't know what to enter as a default and with both Delphi 4 
and Visual dBASE 7.0 I am stuck.

I also think the Alias I am using is an ODBC connection rather than the 
direct connection I thought I could obtain through the BDE.

Any help you can provide is appreciated.

Gerald 
Technical Details
Message-ID: <MPG.1066fb2138c0a60d98978d@forums.borland.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <35fb74c0.2160758@forums.inprise.com> <36033307.6141763@forums.inprise.com> <MPG.10663c62ec2ea681989789@forums.borland.com> <6tie6f$mmr7@forums.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,a20027fb5686ac95
X-Google-Attributes: gidff5a1,public
From: glightsey@cari.net (Gerald Lightsey)
Subject: Re: Where can I find a summary of how to use Local SQL?
Date: 1998/09/14
Message-ID: <MPG.1066fb2138c0a60d98978d@forums.borland.com>
X-Deja-AN: 391064190
References: <35fb74c0.2160758@forums.inprise.com> <36033307.6141763@forums.inprise.com> <MPG.10663c62ec2ea681989789@forums.borland.com> <6tie6f$mmr7@forums.borland.com>
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql