Chris You could try using the MapX geoset manager on a user machine to open an Oracle spatial table and see what happens on the problem machines, ie outside the code altogether.
You mention "On computers where MapX has been installed from the CD the application works perfectly". Whats different about the installation on the user machines? Have you tried a CD install on one of them to see what happens? Are the spatial tables such as the MAP_CATALOG visible to the user logins carried in your code? Also - Oracle spatial support is an installation option - if you're doing this install with a package or similar its possible that the spatial support has been omitted. This happened to me some time ago with raster support having been left off - MapX did its best but we didn't see any raster data at all. Then I realised what was going on. HTH Paul Crisp Syntegra Innovation Place Delta Bank Road Newcastle NE11 9DJ Tel 0191 461 4522 Fax 0191 460 1987 -----Original Message----- From: Chris Prescott [mailto:[EMAIL PROTECTED] Sent: 30 May 2003 01:40 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: MI-L Distribution of MapX for Oracle Spatial support Guy, On the users computer we have Oracle Client and my MapX application installed. When I try to open an Oracle Spatial table in my application the application crashes when I try to add the LayerInfo object to the map, ie at the following statement.. Set mLyr = mMap.Layers.Add(LayerInfoObject) I have put debug statements in and this is where it fails. But it only fails on the non development computers where the application has been installed. On computers where MapX has been installed from the CD the application works perfectly. This is not a code problem! When I run the GeosetManager on the users computers this also fails to load the Oracle Spatial table but it at leasts gives the following message... 'Database Drivers could not be loaded.' As for passwords, the password in the tab file is certainly correct. The same table can be opened correctly on the users computers using MapInfo Pro, but fails when using a MapX application. There are no ODBC drivers to check since MapInfo opens an Oracle Spatial table using ORAINET not ODBC. All Oracle connections on the users computers are correct as any other application we have that access the Oracle database works prerfectly. My Mapx application accesses all of its textual data from the same Oracle database. The only problem we have is it failing when an attempt is made to add an Oracle Spatial table to the map. Thanks, Chris CHRISTOPHER PRESCOTT -----Original Message----- From: Guy Groves [mailto:[EMAIL PROTECTED] Sent: Friday, 30 May 2003 1:20 AM To: 'Chris Prescott'; [EMAIL PROTECTED] Subject: RE: MI-L Distribution of MapX for Oracle Spatial support ******* Some quick thoughts ******** -----Original Message----- From: Chris Prescott [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 06:19 PM To: [EMAIL PROTECTED] Subject: MI-L Distribution of MapX for Oracle Spatial support Hi, I've developed a MapX 4.5 application and have generated an InstalledShield setup.exe to install this application and MapX on to different computers. The application is developed in MS Access 97 using MapX Version 4.51.106 and accessing Oracle Spatial 8.1.7 data. The application loads Oracle Spatial tables using LayerInfo. On the development computer, with Oracle Server installed, Oracle Spatial tables are loaded and displayed correctly in both the application and the GeosetManager. However on our test computer (and others) where the application and MapX has been installed from the setup.exe, and Oracle Client is installed, the Oracle Spatial tables will not load. *********** Do you get an error, what is it? *********** The application works correctly on non-development computers, except when trying to load the Oracle Spatial tables (it crashes). *********** What crashes - The application or Oracle on the server? If your application is crashing here I would: Check the connection being used Put some debug statements in to determine where in your code the crash occurs and work from there. *********** The Tab files that I am selecting were created by MapInfo Pro, are cached and has had the password added to them. MapInfo Pro can open and display the Oracle tables correctly, but the same tables opening in MapX fail. There are no problems when running with normal MapInfo tables. ********** Are you sure you are using the correct password (long shot, but check)? Sounds like there is some confusion as to what is being "opened", A TAB file containing data or a TAB file that queries Oracle? ********** In our installation for MapX we have included the mioci.dll, mirdb.dll, mirdbspatialres.dll & odbc32.dll as is stated in the MapX manual. When we run the GeosetManager on the test machine and try to load an Oracle Spatial table from the tab file, we get the following error: 'Database Drivers could not be loaded.' ********** The connection is not defined, or could not be found. Check the connection name and parameters. ********** MapInfo Pro will open the same Tab file correctly. ********** Using the same ODBC connection? If so this points back to something wrong in MapX configuration Check logon and PERMISSIONS to Oracle? ********** Are there any other files that are required for Oracle Spatial support when distributing a MapX application? If not any clues as to why we can't open Oracle Spatial files on our non-development computers? Thanks, Chris Christopher Prescott Conquest Solutions Pty. Ltd. GIS Specialist Suite 3, Level 2 187 Rundle Street, Adeleide South Australia 5000 Phone +61 8 8223 3377 Fax +61 8 8223 3600 email [EMAIL PROTECTED] --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7076 ******************************************************************** This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person Thank you Check us out at http://www.syntegra.com ********************************************************************