The SAS Output Delivery System and reporting techniques

SAS to ASP

Reply
N/A
Posts: 0

SAS to ASP

We are trying to connect to a SAS dataset using an ASP(Active Server
Pages) page with VBScript as the scripting language. We are on windows
2003 server running IIS. We use the SAS version 9.1.3. We have Base SAS on the IIS server and also have added the ODBC SAS driver.

I have tried using the SAS Local Provider and the SAS Share Provider. To make sure the web server was set up correctly, I successfully connected to an Access database, but when I change the provider to SAS, I get the following error:


In this case Line 31 is the following:

cn.Open ("Provider=sas.ShareProvider.1;DATA SOURCE=" &
server.MapPath("SLA_Customer_Survey_100606.sas7bdat"))

**************************************************
Does anyone have a possible solution?
Thanks!

Brad
SAS Super FREQ
Posts: 8,743

Re: SAS to ASP

Hi:
This is really not an ODS question or BASE Reporting question. While some folks on the forum may have ASP experience if you really need to resolve this issue quickly, you probably should contact Tech Support. They can gather all your installation and operating system information and get you on the right track.

To contact Tech Support, refer to:
http://support.sas.com/techsup/contact/index.html

cynthia
Ask a Question
Discussion stats
  • 1 reply
  • 118 views
  • 0 likes
  • 2 in conversation