conecting to a SQL Server 2005 using ODBC drivers

[Matthew Rodriguez DSD staff <MKRodriguez@lbl.gov>]

Greetings,

I am using
version: S-plus version 7.06
client machine: Windows XP
DBMS and Server OS: SQL Server 2005, Windows Server 2003

I've been trying to connect to a database using a ODBC driver I have been
unable to do this through the GUI. Has anyone else had success Importing 
Data through the GUI?
The funny thing is when I'm going through the creating a Data Source, 
and building an ODBC
connection, I am able to connect to SQL Server, but in the end after 
configuring the Data Source
it is not created. I suspect there is a bug in the GUI code.


Here are the arguments to the importData call, the call is successful it 
returns the contents of a datumtype
table.

importData(file="data.txt", type="ODBC", server="pod.lbl.gov", 
database="ORNL", table="datumtype",
               odbcConnection="Driver={SQL Native Client}; 
Server=pod.lbl.gov;Database=ORNL;UID=mkr;PWD=mypwd")

This is not quite ideal because I want to be able to do this without 
putting my password in the script. I'd like it to
prompt for my password, but I don't know if this is possible.

If anybody has had any experience with this, please let me know.


Thanks,
Matt Rodriguez

--
---------------------------------------------------------- 

Matt Rodriguez                        
email: MKRodriguez@lbl.gov
phone: (510) 486-4183
URL: http://dsd.lbl.gov/~mateo

Distributed Systems Department
Lawrence Berkeley National Laboratory