Lars: I can't give you a definitive answer, but I may be able to open up some avenues of investigation for you.
What version of MapInfo are you running? I've not had this problem with Oracle 8i and MapBasic 5 / MapInfo 6.5. Are you using SpatialWare, or is Oracle merely storing attribute data? Are you developing with Personal Oracle, or is this a version of Oracle running on a server somewhere? (if it's Personal Oracle, that may explain the network cable thing). If it's a server version, you might consider using the Oracle GUI tools from within a Remote Desktop session to the server. As you're probably aware, when MapBasic wants to compile something, it checks to see if MapInfo is running first. If MapInfo is open and hanging, MapBasic will also hang. You probably also know that Oracle's GUI tools are written in Java. I've had problems in the past with multiple Java Virtual Machines on the same computer. The .NET Framework is a competitor to JVMs although I've not experienced any problems with it and JVMs running together. Perhaps your Oracle tool is interfering with the communication between MapInfo and MapBasic, or if MapInfo is also open, preventing MapInfo from responding to messages. Hope this helps Spencer -----Original Message----- From: Lars V. Nielsen [mailto:[EMAIL PROTECTED] Sent: Thursday, May 13, 2004 9:42 AM To: MapInfo-L Subject: MI-L Oracle woes: 9i and MapBasic together ? Hi all, Being an MS/SQL kinda guy, being thrust onto Oracle 9i is a really scary experience. It's not really a GUI based environment even nowadays. But the customer REALLY insisted so I've braced myself, and is currently doing some development on Oracle 9i (not Spatial) with MapBasic. I'm running both the Oracle server and the MapInfo/MapBasic development on a single W2K server machine. -------------------------- The problem is that whenever I use one of the (limited) GUI tools, Enterprise Manager Console or SQLPlus worksheet, MapBasic hangs indefinitely when trying to do a compile. Or at least it does until I close the afore mentioned tools ! I.e., I have to switch opening and closing the Oracle GUI tools when developing my MB app, an irritation I don't need to have added onto my "normal" development frustrations. Having MapBasic open all the time is possble, but it still hangs when trying to do a compile. Has anyone run into this kind of problem before ? And if so, is there some way to remedy this problem ?? I really hope there are some Oracle wiz's out there that can help. -------------------------- Ps! And just to add to my Oracle grievances: to have the Oracle server start normally, I have to disconnect the network cable. After it's started I can reconnect the cable and everything runs ok. Strange huh ? Pps! I'm seriously considering developing everything on MS/SQL, and port it to Oracle at the very last minute. But I guess I better not do that ..... ;-) Best regards / Med venlig hilsen Lars V. Nielsen -------------------------------------------------------- Hvenegaard & Meklenborg Rugaardsvej 55, DK-5000 Odense C Denmark http://www.hvm.dk --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11741
