Re: [S] OdbcConnection parameter in function.

Norm Olsen (
Wed, 22 Jul 1998 09:40:56 -0700

Thanks to Frank Biedermann for providing an answer to my question about the
OdbcConnection parameter of the function. His connect string
works nicely except that, when I connect to Microsoft SQL Server, I must
also supply the data source name in the connect string. I don't know if
this is also true for other types of ODBC connections. Anyway, here is an
example of a complete "" call that works using an ODBC connection
to Microsoft SQL Server:"Observer",

OdbcSqlQuery="Select * from slope_rockfish_1998")

As Frank points out, it would be nice to know how to provide the encrypted
string in order to conceal user ids and passwords.


-----Original Message-----
From: Frank Biedermann <>
To: 's-news' <>
Date: Tuesday, July 21, 1998 10:17 PM
Subject: RE: [S] OdbcConnection parameter in function.

>On Wednesday, July 22, 1998 3:27 AM, Norm Olsen
>[] wrote:
>> Hi all,
>> Does anyone know how to use the "OdbcConnection" parameter of the
>> "" function when connecting to ODBC data sources? The S-PLUS
>> Programmer's Guide states that this is an encrypted character string
>> (presumably specifying the server, user id, password, etc.) but no clue
>> offered as to how to obtain this encryption.
>I had the same question a few months ago, however I did not get any
>The password string does not need to be encrypted - I've tried it and it
>seem to mind, however, it would be nice if someone who knows how to
>encrypt it would share the secret.
>BTW, in case you didn't know, the connect string should be of the form:
>Frank Biedermann
>Research Officer (Statistics)
>Senior Secondary Assessment Board of South Australia
>ph: (+61) 8 8372 7439
>fax: (+61) 8 8372 7438

This message was distributed by To unsubscribe
send e-mail to with the BODY of the
message: unsubscribe s-news