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