Mailing List Archive


Back to the month index Back to the list index
ak (aka@pair.com)
Tue, 7 Jan 1997 10:21:52 -0500 

Message-Id: <01BBFC84.EC2D6060@alan.dialup.westnet.com>
From: ak <aka@pair.com>
Subject: RE: [mSQL] [msql] Gorta32 No Update of database possible...
Date: Tue, 7 Jan 1997 10:21:52 -0500

Hi
The answer lies in the database structure as ODBC perceives it, ODBC
requires that a table structure have a primary key to use as an index .
You also should (to make your life easier) make it the first field in the table,
this way you can make use of the table structure while using DAO

Alan Kroeger

I will be providing a few example programs at my ftp site in a day or two
you can try them out and read the code that makes it work

http://www.aka.pair.com/ftp/
or
ftp.aka.pair.com

----------
From: Fernando Lozano[SMTP:bl@riosoft.softex.br]
Sent: Tuesday, January 07, 1997 11:50 AM
To: msql-list@bunyip.com
Subject: Re: [mSQL] [msql] Gorta32 No Update of database possible...

Hi, Mark!

> I4ve Gorta32 2.10..0.6 and msql 1.0.16 running.
> Clients Msql User Interface or Access 7.0 / OS Win95.
> Theres no problem to connect via ODBC to the msql-database and read,
> but if i try to delete or update a record i get only the error-msg "database
> read only".
>
> There4s *no* ACL file.
>
> It looks like a user problem. :-))

So, I have also a user problem.

Running mSQL 1.0.16 under OS/2 (patch levels C, D and E), if I try msql
console or w3-msql under OS/2 everything works fine. If I use msqlwin7
under Windows for Workgroups (connecting to the same mSQL server), so
good.

But If I try msqlui under Windows for Workgroups (that is, using the
16-bit ODBC driver gorta), I also can't update any thing: no inserts and
no deletes also.

[]s, Fernando Lozano
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!