Hello list,

I am trying to open a SQL Server 2000 View in MapInfo Pro 6.5 via Open DBMS Table.  On 
step 4 of 'Open DBMS Table', I uncheck the 'Download data (Linked Table)' option, 
click finish, and get error message:

'Cannot open table for live access.  A single numeric Key Column is required
on the table. Unable to open table ...'

All the tables joined in the view have numeric primary keys, and one of these primary 
keys provides a unique key for the view.

I have tried creating a view on a single table (SELECT * FROM ...), but get the same 
error message.  I can open any of the individual base tables without any problems.

Is it possible to open a SQL Server 2000 View in MapInfo Pro, & if so, where am I 
going wrong?

Regards

Mike



********************************************************************************
Note: We are a Microsoft Office site.  Our base version is 4.3.  Please make sure
that files you send can be read in this format.

Any form of reproduction, dissemination, copying, disclosure,
modification, distribution and/or publication of this e-mail is strictly
prohibited save unless expressly authorised by the sender.

The information contained in this message is intended for the named
recipients only. It may contain privileged and confidential information and if you
are not the addressee or the person responsible for delivering this to the addressee,
you may not copy, distribute or take action in reliance on it.
If you have received this message in error, please notify the sender(s)
immediately by telephone. Please also destroy and delete as soon as possible
the message from your computer.
*****************************************************************************************************************************************************



_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.

Reply via email to