Richard
I've had these types of messages with SQL Server. You need to make sure
that your using the MapInfo supplied ODBC drivers to avoid the Connection
busy message. When I used it all records seemed to have return OK and I had
an error handler and for that specific message I ignored it.
The Live Access error is (I think) due to not having a single numeric
primary key in your table.
Regards
Mike Saunt
Aligned Assets
Kingfishers House
East Shalford Lane
Guildford
Surrey GU4 8AS
United Kingdom
Tel: +44 (0)1483 306210
Fax: +44 (0)1483 306211
Web: http://www.aligned-assets.co.uk/
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
On Behalf Of Richard Greenwood
Sent: Wednesday, April 26, 2000 12:22 AM
To: [EMAIL PROTECTED]
Subject: MI Live ODBC access woes
I can't get live odbc access working with MI. Generally I get a "Cannot
Open Table for Live Access. A single numeric key column is required on the
table" error message. I sometimes get an ODBC error "Connection is busy
with results of another hstmt" from SQL Server.
I've been trying SQL Server 7.0 and MySQL. I've tried the suggestion I
found in the MapInfo-L archives without success.
Any suggestins will be greatly appreciated.
Rich
Richard W. Greenwood, PLS
Greenwood Mapping, Inc.
[EMAIL PROTECTED]
(307) 733-0203 fax: 733-4018
http://www.GreenwoodMap.com
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
