******* 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: 7047