James, I think the problem might be that the the owner (dbo ??) of the table is missing.
"Select * from dbo.property_GIS_data_check_out" Peter Horsbøll Møller GIS Developer, MTM Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James M. Kelly Sent: Friday, January 27, 2006 5:45 AM To: [email protected] Subject: [MI-L] Linking table from Spatialware Hi all I am running into a peculiar problem using Spatialware 4.8 (for SQL Server) MapInfo 8.0 and MapBasic 7.8, which seems to only be occurring on one machine. I have a table in SQLserver which I want to link into MapInfo, but using code through a MBX file. On 3 machines I have set up, it works fine using the code Dim hdbc As Integer hdbc = Server_Connect("ODBC", "DSN=Land_Acquisition;DATABASE=Land_Acquisition;Network=DBMSSOCN;Trusted _Connection=Yes") server hdbc link table "Select * from property_GIS_data_check_out" into property_GIS_data_check_out When I link it this way, I have no idea where the property_GIS_data_check_out temporary files are stored, and I don't particularly care as long as they disappear when I close the table. Now the problem occurs on one machine which is more recent than the others. The only difference I can figure out is that it has the My Documents folder linked to a folder on an external drive, which is where most of the default MapInfo settings point to (like tables, workspaces, etc). When I use the above code on the problem machine, it comes up with the error "DBMS table or View PROPERTY_GIS_DATA_CHECK_OUT not found in Database. No columns in table property_gis_data_check_out." I have checked the ODBC connection, it is working fine. I can open the table interactively through MapInfo, so why can't I do it through code that works on all other machines? Any help would be most appreciated. Cheers James Kelly Spatial Information Officer Midway Pty Ltd 150 Corio Quay Road North Shore Victoria 3215 Tel. +61 3 5277 9255 Fax +61 3 5277 0667 Mob +61 4 3834 5760 (0438 345 760) -- Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering. http://www.mailguard.com.au/tt _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
