Darren,
The first thing you need to know is that connections to Oracle from MapInfo are
done via a language/protocol called ODBC. Setting up an ODBC driver
(distributed with MapInfo) will be part of the solution. There is an issue with
connecting MI 4.1, which is a "back" version, to Oracle 8.04xyz12345, which is
more current. I'll put that aside for a moment.
The next question, regarding MapBasic: Yes you can send SQL using MapBasic, in
fact, you'll have a few more tools. It still goes through ODBC.
Thirdly, I have seen solutions that stored network information in vanilla
Oracle tables, to be reconstituted by either MapBasic or MS VB/VC++ (issuing
MapBasic commands to MapInfo via OLE, sorry, too much info.) However, this is
dinosaur stuff, thanks to SpatialWare. The justification for using SpatialWare
is essentially the same as for using Oracle: Lots of data, and/or lots of
users, and/or SQL horsepower.
Finally, the best and essential reference is MapInfo Corp., which I'm sure will
perk up it's ears when anyone hears "Oracle", "SpatialWare", etc. You'll
probably want someone inside to think about that MI/Oracle version issue I
alluded to.
I don't know who your contact would be in the UK (London, is it?), but you can
find out at:
http://www.mapinfo.com/corporate_info/contact_mapinfo/europe.html
I'll bet you a nickel that Mr. Dressel or Mr. Wemple of MapInfo has seen your
message, and forwarded it to the appropriate person(s).
Naturally, I'm available for any expenses paid trips across the pond, if the
occasion arises.
Helps? Hurts?
[EMAIL PROTECTED] wrote:
> **** ORIGINATOR M2640087 KISNER D 21/01/99
> CONSULTANT, TCI EUSTON 5:05 pm
>
> Hello all,
>
> I need to connect Mapinfo 4.1 (windows 3.1) as a client to Oracle 8.04
> (Unix), and I hope someone can answer a few initial questions..
>
> First and most important how do I go about this?
>
> Second..clients will use mapinfo through a mapbasic application, can I send
> SQL to the Oracle server using mapbasic?
>
> third..I would like to store network information (arc and node tables) on
> the database. Is this possible? Do I need spatialware, spatial data
> cartridge?
>
> In addition if you could point me to any references that'd be great,
>
> Thanks in advance
>
> Darren Kisner
> ----------------------------------------------------------------------
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
--
Sam Kome
5341 Three Waters Lane
Graham, NC 27253
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
