Hi Roger, We've run SpatialWare (4.5) on MS/SQL 2000 from both MIPro and MapXtreme 3.0 (MapX 5.0) without too many problems. And we're definitely not using "sa" to access MS/SQL from MXT either.
It may be a security/privilege problem you're dealing with. If the tables are owned by "dbo", sa will have access to them, but other users may not have adequate privilegies to do so. Older versions of SpW had a hardcoded need for some tables to be dbo owned, but newer versions may not have this deficiency (can't remember the exact specs). It may also be concerned with the MapX "unique primary index" problem, especially if you're accessing views. Renaming the primary index field to MI_PRINX in views may help you out. Remember that both tables and views alike need to be registered in MAPINFO_MAPCATALOG to be openable in MapX(treme). Best regards / Med venlig hilsen Lars V. Nielsen -------------------------------------------------------- Hvenegaard & Meklenborg Rugaardsvej 55, DK-5000 Odense C Denmark http://www.hvm.dk ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <MapInfo-L@lists.directionsmag.com> Sent: Friday, May 27, 2005 8:56 AM Subject: MI-L SQL Server and Spatialware Hi, Has anyone out there used SQL Server and Spatialware together? If so have you have ever tried to access tables from the database using connection strings within MapXtreme, MapX applications. My problem is that I cannot get MXT to load tables unless the logon account is "sa". In a web environment that is a big no no (it is the administrator account). Both old and recent versions of MXT seem to have problems when loading SQL Server DBMS tables. Thanks --------------------------------------------- Roger Ling Technical Officer (MapInfo) Parks & Wildlife Service Department of Tourism, Parks, Heritage & the Arts GPO Box 1751 Hobart Tasmania 7001 Australia Phone: (03) 6233 3199 Fax: (03) 6223 8308 Web: www.parks.tas.gov.au Intranet: http://tracks.parks.tas.gov.au FTP: ftp://tracks.parks.tas.gov.au Location: 2nd Floor - Lands Building CONFIDENTIALITY NOTICE AND DISCLAIMER The information in this transmission may be confidential and/or protected by legal professional privilege, and is intended only for the person or persons to whom it is addressed. If you are not such a person, you are warned that any disclosure, copying or dissemination of the information is unauthorised. If you have received the transmission in error, please immediately contact this office by telephone, fax or email, to inform us of the error and to enable arrangements to be made for the destruction of the transmission, or its return at our cost. No liability is accepted for any unauthorised use of the information contained in this transmission. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 16588