Hi all,

I am writing a VB program on a pc that does not have local SAS
installed but can run SAS thru a network.  I got a "provider not
found" error when trying to access the SAS.LocalProvider.  I figure I
probably need to tell it where the provider is.  How do I do that?

Thanks in advance,
W.


    cn.Provider = "SAS.LocalProvider"
    cn.Properties("Data Source") = "c:\mydata"
    cn.Open
    rs.Open "test", cn, adOpenForwardOnly, adLockReadOnly,
adCmdTableDirect

From Archives:









Has SAS data provider has been installed?.

Look at this info at SI web site.

http://support.sas.com/rnd/eai/oledb/gs_testing.htm



Prasad Ravi






                         wh
                         <haungw1@YAHOO.COM>    To:    SAS-L@LISTSERV.UGA.EDU
                         Sent by: "SAS(r)       cc:
                         Discussion"            Subject: Unable to use the SAS Data provider
                         <SAS-L@LISTSERV.UGA.E
                         DU>


                         07/03/2003 08:30 AM
                         Please respond to wh






Hi all,

I am writing a VB program on a pc that does not have local SAS
installed but can run SAS thru a network.  I got a "provider not
found" error when trying to access the SAS.LocalProvider.  I figure I
probably need to tell it where the provider is.  How do I do that?

Thanks in advance,
W.


    cn.Provider = "SAS.LocalProvider"
    cn.Properties("Data Source") = "c:\mydata"
    cn.Open
    rs.Open "test", cn, adOpenForwardOnly, adLockReadOnly,
adCmdTableDirect