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
