Hi !
I'm not sure that I understand your problem very well...
But, if your problem is that you have to login when you open a Oracle 8i
Table (via a ODBC .tab file), you can modify the line=20
"\DATALINK\ConnectionString" =3D "SRVR=3DMYSERVEUR;UID=3DMYUSER"
of the .tab file and add a PWD clause :
"\DATALINK\ConnectionString" =3D
"SRVR=3DMYSERVEUR;UID=3DMYUSER;PWD=3DMYPASSWORD"
With that modification, end users will not have to enter any login
information when they open this .tab file.
Hope this help.
Best regards.
> -----------------------------------------------------
> Herv=E9 DORIER - Ing=E9nieur d'=E9tudes
P=F4le Ing=E9nierie documentaire et Syst=E8me d'Information
G=E9ographique =20
> SWORD
> 9, av. Charles de Gaulle
> 69 370 ST DIDIER AU MT D'OR CEDEX FRANCE
> T=E9l. : 04 72 85 37 50
> Fax : 04 72 85 37 67
> Email : [EMAIL PROTECTED]=20
>=20
-----Message d'origine-----
De: David Andrews [mailto:[EMAIL PROTECTED]]
Date: lundi 21 mai 2001 21:47
=C0: Anitra Robertson; MapInfo Users
Objet: RE: MI-L GIS Oracle Login Issue
Anitra,
I know your frustration have experienced the same problem. Its not
really
your contractors fault though.
This is a fault in the MapInfo/Oracle implementation and one of the many
things that MapInfo have not thought about or tested in its connection
to
Oracle. I assume that they thought no-one would ever try to open a table
that was not in that persons schema. MapInfo were no help at all to us
in
solving this, and I am still awaiting a reply from over 5 weeks ago.
Even
Oracle do not have a solution to this.
We ended up writing a small MapBasic application that is ran from the
startup.wor. The application forces the user to login to Oracle on
startup,
also with an option not to. Then the login name, "UID=3D????" is passed =
to
a
variable also declared in the startup.wor, i.e. not part of the mapbasic
app.
I then had to create a modified version of every TAB file that was
required.
The tab file consisted of MapBasic lines that would firstly open and
register the required Oracle view/table as a new live table in a
separate
directory. The connection string to the Oracle view would be built each
time
using the UID supplied from the initial login and stored in the Global
variable. This newly created TAB file will now contain the connection
string
for that user, then the last part of the TAB file will open the newly
created TAB file, no login will be required as the UID is in the
connection
string.
Every time the file is opened from the dummy TAB file the TAB file in
the
other directory will be overwritten.
I hope this makes some sense.
I would be very interested in hearing your experiences with opening
Oracle
views, and in general with MapInfo and Oracle. Are you opening the views
as
live tables/views? Do the views have a spatial element? We have had and
still are having many problems in this area.
Regards
Dave Andrews
London Borough of Enfield
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Anitra
Robertson
Sent: 21 May 2001 02:26
To: MapInfo Users
Subject: MI-L GIS Oracle Login Issue
Hi List,
I have a problem relating to: logging in to our GIS via Oracle.
We are in the process of implementing our GIS, which has been scripted
by contractors.
The end user will open MapInfo V6, and then open the required workspace
(sitting on our LAN), but during this process, the workspace calls to
three end views located on our Oracle server. This is the point where
the user has to login.
As there are three views, the contractors have scripted it so that each
end user will have to login for each table, i.e. 3 times! The owner of
the tables only has to login once (this is why the contractors didn't
know there was an issue, until I got my own login and discovered the
problem).
Our issues:
1. The Contractors don't think this is a problem!! Although we do! For
example, what happens if we want to create more views??? When does it
become unacceptable? at 5 times, 6 times etc....... (I believe this is
because they don't know how to solve it)
2.We want to have the users only logging in once to the database.
We have numerous integrated systems in our company, and not one of them
requires the users to login more than once. This is NOT a precedent we
would like to start.
Can anyone offer any advice as to how we may solve this problem.
Thanks for any help you can give.
--
Anitra Robertson
GIS Analyst
Tattersall's
(Gaming and Lotteries)
Melbourne, Australia
CONFIDENTIALITY NOTE:
This e-mail is intended only for the use of the individual or entity
named above and may contain information that is confidential and
privileged. If you are not the intended recipient, you are hereby
notified that any distribution, copying or dissemination of this
e-mail is strictly prohibited. If you have received this e-mail in
error or are not the named recipient, please notify us immediately
by return e-mail <[EMAIL PROTECTED]> or telephone
613-8517-7405 and destroy the original message. Thank you.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.