Hi Matt, I was thinking more or less along the lines of using VB to open the db and extract the requested recordset, and then save the recordset in some MapInfo compatible format (csv, dbf, access), build a tab file for it, and open that in MIPro.
Unfortunately MIPro cannot accept/open an ADODB recordset directly. Only MapX can do that, but that's a different ball game. Best regards / Med venlig hilsen Lars V. Nielsen Odense, Denmark ----- Original Message ----- From: Matt Bolton To: Lars V. Nielsen ; [EMAIL PROTECTED] Sent: Tuesday, November 05, 2002 5:55 AM Subject: Re: MI-L Refreshing password-protected DBMS table Lars, 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]
