Thanks for the advice. I got it going using "Server Link Table", and it works well.
I'm interested in the option you talk about to "use VB to connect directly to the source and provide the results to MapInfo". Since the datasource is already open in VB, this sounds like a better option. I can't find any reference to a Recordset = ... or Datasource = .... type command in the MapBasic help - would you please point me in the right direction?
Thanks,
Matt
Lars V. Nielsen wrote:
Hi Matt,--
The login/password used by MIPro to log into an RDBMS source is saved in the connect string in the very un-encrypted TAB file. I.e.
open for everybody to read. So usually one leaves out any passwords.
However, this forces MIPro to prompt for it when needing to reconnect (e.g. when refreshing). And there's no way to prevent this
prompt, so you're stuck in the way you've set it up.
But if you either use the MapBasic command "Server_Connect" to open the source and specify the connect string yourself, or use VB to
connect directly to the source and provide the results to MapInfo, you should be able to keep the password safe from prying eyes.
Best regards/Med venlig hilsen
Lars V. Nielsen
GisPro, Denmark
http://hjem.get2net.dk/lars-online/
http://www.gispro.dk/
WGS84: 10.20'40"E 55.20'20"N
----- Original Message -----
From: "Matt Bolton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, November 03, 2002 7:54 AM
Subject: MI-L Refreshing password-protected DBMS table
Hi all,
Thanks largely to this list, my learning about programming with MI is
progressing rapidly, so I'd like to say a quick "Thanks" to those who
run and contribute to it..
On to the problem ....
I have created a DBMS table which is linked to a password protected
Access database. In VB, I run the command
.do "Server Refresh [tablename]"
to refresh this link, at which time I'm prompted for a password.
I'd like for users to not see this prompt - i.e. have the password
entered via code.
I assume there is a simple way to do this , (something like .do "Server
Refresh [tablename], PWD=abcdef"
but can't find the syntax required.
TIA,
Matt
--
Matt Bolton
Mach 3 IT
Email [EMAIL PROTECTED]
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 3886
Matt Bolton
Mach 3 IT
Mobile 0412 122 416
Email [EMAIL PROTECTED]
