Date:         Wed, 15 Apr 2009 11:38:47 -0600
Reply-To:     Ken Barz <Ken.Barz@CPCMED.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ken Barz <Ken.Barz@CPCMED.ORG>
Subject:      Re: SCL Libname and OLEDB connection
Comments: To: Richard <rdevenezia@WILDBLUE.NET>
In-Reply-To:  A<c7b71a0d-aac4-4ac4-9ac5-fe5ff19664ba@e7g2000vbe.googlegroups.com>
Content-Type: text/plain; charset="us-ascii"

It still gripes unless it gets a pair of empty quotes in the third
argument.  If I do that, it will at least compile, but then it says that
init_string is an invalid option (although that works in a regular
libname statement with oledb.)

Some days I really dislike programming!

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Richard
Sent: Wednesday, April 15, 2009 10:20 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: SCL Libname and OLEDB connection

Ken:

The options argument is the _fourth_ argument.  Try

rc = LIBNAME
( 'dmsapp'
, 'oledb'
,
, 'init_string="Provider=SQLOLEDB; ...yadayadayada
);

--
Richard A. DeVenezia
http://www.devenezia.com