Hi, Just a very simple simple question, that I'm sure every one knows the answer to - or at least those working with Oracle: What do I need to install on a computer that should be able to access a Oracle 10g Spatial database ? On my own laptop I have installed the complete Oracle 10g database with SQL Plus and TOAD etc. But these computers are supposed to use MapInfo as a client. Having just installed MapInfo - of course with the Oracle OCI support - I get the message that some drivers failed to load when I start MapInfo. This is normally caused be the fact that there is no Oracle Client installed. I then installed the Oracle Instant Client, but this didn't help. What else do I need to do ? TIA, Peter Horsb�ll M�ller GIS Developer Geographical Information & IT COWI A/S Odensevej 95 5260 Odense S. Denmark Tel + 45 6311 4900 Dir +45 6311 4908 Mob +45 5156 1045 Fax + 45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk <http://www.cowi.dk/>
________________________________ From: Robert Crossley [mailto:[EMAIL PROTECTED] Sent: Wed 17-Nov-04 23:12 To: Possberg, Hendrik Cc: MapInfo List Subject: Re: MI-L Spatialware on SQLServer - 2 More random thoughts on SQL. If you are not one yourself, make friends with a good database administrator. They are worth their weight in gold. And be careful about restricting access to various tables in the database - eg. users need to be able to see the base tables - something dbas don't like. MapInfo needs to select from those tables and fails if you try to edit them via views with triggers. We had a conference with a few seurity nazis, and their assessment was that they couldn't impose the same sort of restrictions on the database as they would like to normally (eg. only see views and only edit via triggers), and suggested creating a differnent instance of SQL Server that held only the GIS data as being the best compromise. I'll keep posting these as I think of them. It is good for my records as well. r On Wed, 17 Nov 2004 18:00:00 +0100, Possberg, Hendrik <[EMAIL PROTECTED]> wrote: > Dear List, > > I am looking for an entrance using following programs. > > - MS SQL Server 2000 > - Spatialware 4.8 > used with Mapinfo and Mapbasic 7.0 > > 1. I am looking for general informations to avoid beginner's mistakes. > > 2. I would like to implement some triggers (update). What does that mean > for > the performance? Are there any pitfalls? > > 3. I would like to get to know how to do "batch programming" e.g. > select the 5 nearest Shops for 100000 customers. > and "batch programming" for > selecting all customers inside a circle of 5 km for 1000 Shops. > This should be done with Mapbasic. > > > Any help would be greatly appreciated. > > > Mit freundlichen Gruessen > > microm > Micromarketing-Systeme und Consult GmbH > > > Hendrik Possberg > Geodaten > > Hellersbergstr. 14 > 41460 Neuss > Phone: 02131-10 97 51 > Fax: 02131-10 97 77 > mailto:[EMAIL PROTECTED] > > > *** > Aktuelles: > Abonnieren Sie kostenlos das aktuelle microMagazin. In jedem Quartal > aktuelle Informationen �ber die neuesten Entwicklungen bei microm, > unseren > Partnern und Kunden. Einfach online bestellen unter www.microm-online.de! > *** > ___________________________________________ > > Diese Nachricht wurde elektronisch versandt und ist daher auch ohne > Unterschrift rechtsgueltig. Der Inhalt dieser E-Mail enth�lt vertrauliche > Informationen. Das > Kopieren und die Weitergabe an Dritte ist nicht gestattet. Sollten Sie > diese > E-Mail irrtuemlich von uns erhalten haben, bitten wir Sie, diese zu > vernichten und uns darueber zu informieren. > Im Voraus vielen Dank. > ____________________________________________ > > > > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > Message number: 14097 > > -- ________________________________________________ Robert Crossley Agtrix P/L 9 Short St PO Box 63 New Brighton 2483 Far Southern Queensland AUSTRALIA 153.549004 E 28.517344 S P: 02 6680 1309 F: New Connection M: 0419 718 642 E: [EMAIL PROTECTED] W: www.agtrix.com W: www.wotzhere.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: 14103
