Bill Gibson will be presenting a paper on the new features available with Release 2.1 of SAS Add-In for Microsoft Office. Make sure you attend to learn about Microsoft PowerPoint support and all the other new features.
Date: Tuesday, March 28th
Location: Room 2018
What I am attempting to do is to determine how to connect to a SAS Data Source through Visual Studio. When using the Add Connection in Visual Studio, the options for my installation currently include: Microsoft Access, Microsoft ODBC Data Source, Microsoft SQL Server, Microsoft SQL Server Database File, Microsoft SQL Server Mobile Edition, and Oracle Database. The idea behind the question being that the Add-in would make the connection possible rather than having to manually code the linkages to a report created through Visual Studio.
We have no plans, currently, to support Visual Studio in the same way we support Excel, PowerPoint, and Word. You can use the Add Connection tool to connect to SAS data. In VS 2003 all data providers are shown on the main list, but in VS 2005 only the ones you listed are shown. You can get to the Data Link Dialog by choosing "" (which is listed under those choices for me) and choosing ".NET Framework Data Provider for OLE DB". Once you do that you get to this screen where you can pick the provider you want as well as click "Data Links…" for the Data Link Dialog. Be aware that there are some limitations. When you drag the table to your application errors are generated. For one example, since our table names are in the form 'libname.tablename' the select statement generated is:
select "libname.tablename".* from "libname.tablename"
Still, this will get you pretty far towards using the VS tools to create a connection to SAS data.