Subject: | |
From: | |
Reply To: | |
Date: | Wed, 31 May 1995 13:06:44 PST8PDT |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
Jeff Kell says:
> I'm trying to get started with Image/SQL and ODBC, but can't get off the
> ground on the 3000. Trying to start a new DBE, logged in as the creator
> of the TurboImage database I'd like to eventually attach, and logged into
> the group with the database. ISQL gives:
Are you planning on creating and attaching to a new DBE?
If so, the easiest way is with IMAGESQL. It will create the DBE for
you if does not exist.
IMAGESQL
>>set turbodb mydb
>>set dbe mydbe // if it doesn't exist you will be prompted to
create it
>>attach
>>disp users // show users who have access(just the creator)
At this point the database and DBE are in the same group.acct. Good.
As well, the Image DB creator and the DBA are the same person. This
is easiest as well.
Next try to access your data from ISQL.
isql=>connect to 'mydbe';
isql=>info 'mydb.someset'; // gives a schema like listing of a set
isql=>select * from mydb.someset;
view data, then exit viewer, then VERY IMPORTANT.
isql=>commit work; // other wise that data is still locked by you
Good luck
Bob
--=--=--
Bob Walker, Computer Centre -- [log in to unmask]
Capilano College, North Vancouver, BC, CANADA.
-- Windows '95 - making your PC work like a Mac.
|
|
|