Paul, The test machine and the users machines have Oracle Client installed on them. Oracle software like SQL Plus and the Oracle ODBC Test program all work correctly on these client machines looking at the database on the server that has the Oracle Spatial tables. MapInfo Pro also works correctly on these machines and can open and display the Oracle Spatial tables with no prblems at all. The client computers all have the right TNSNAMES.
The problem is that any MapX application on these same computers, either crashes or fails to load the same Oracle Spatial tables. Our MapX installation includes all of the Oracle required Dll's that are listed in the MapX manual. Regards, Chris CHRISTOPHER PRESCOTT -----Original Message----- From: CRISP, Paul -Syntegra UK [mailto:[EMAIL PROTECTED] Sent: Thursday, 29 May 2003 6:30 PM To: 'Chris Prescott'; [EMAIL PROTECTED] Subject: RE: MI-L Distribution of MapX for Oracle Spatial support Chris Is the Oracle client installed on the other machines? The MI DLLs etc talk to that, not the database, thats the way Oracle license the software I believe. Have you put the right TNSNAMES on the other machines? 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: 29 May 2003 01:19 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. The application works correctly on non-development computers, except when trying to load the Oracle Spatial tables (it crashes). 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. 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.' MapInfo Pro will open the same Tab file correctly. 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] ******************************************************************** 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 ******************************************************************** --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7073