If the ConnectionString param have the password in it will not prompt for the password when you open the table. Ex : "\DATALINK\ConnectionString" = "SRVR=myServer;UID=scott;PWD=tiger" I think mapinfo never store the password himself in that property, but you can manually change it (or programmaticly with metadata functions) Hope this help
Antoine -----Original Message----- From: Peter Horsb�ll M�ller [mailto:[EMAIL PROTECTED] Sent: November 22, 2004 2:05 PM To: [EMAIL PROTECTED] Subject: MI-L Oracle Connection String Hi, Well, I'm still strugling with Oracle ;-) When I open an Oracle table in MapInfo, and stores a tab file on disk, it look like this: ************************* !table !version 550 !charset WindowsLatin1 Definition Table Type ODBC begin_metadata "\IsReadOnly" = "FALSE" "\DATALINK" = "" "\DATALINK\Query" = "Select * From CMIS.CMIS_PARCELS Where INSTR('ORG CURR', STATUS) > 0" "\DATALINK\ConnectionString" = "SRVR=tnt;UID=drs" "\DATALINK\ToolKit" = "ORAINET" "\CACHE" = "OFF" "\MBRSEARCH" = "ON" end_metadata *********************** The thing that bugs me is that it writes the uid into the file. I would have it using the availeble connection, because when a different user opens this table afterwards he is propted for the password for the user 'drs'. This new user of course could enter his own username/password, but he already has established a connection to Oracle, so I just want MapInfo to use this connection. Any ideas how this can be established, or does every user just have to have their tables locally, in the temp folder for instance ? 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/> --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 14169
