If I remember right you can install sql server client on the machine and then it will not ask you for the name and password every time.
Dan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ramsour Mike Sent: Wednesday, March 12, 2003 7:28 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Automatic importing from SQLserver tables Good morning, I am trying to automate the importing of data from a SQLserver ODBC source into some R:Base tables. When connecting to the SQL ODBC source user input is required for the user name and password. I only have to press the enter key or click on OK for the import routine to continue. I don't actually have to type anything. Using the standard SCONNECT syntax with IDENTIFIED BY and PASSWORD syntax does not work for these data sources. What I want to do is find some way to simulate the pressing of the enter key so that the import routine can run unattended. I tried to automate the routine by creating a variable with an embedded carriage and I also tried using a playback file but neither of these seems to work. What technique can I use to have R:Base supply the carriage return? Any suggestions are always greatly appreciated. Thanks Mike Ramsour Voice: 740-829-4340
