topic Re: C# connection string to SAS in SAS Procedures

C# connection string to SAS

deleted_user — Wed, 10 Dec 2008 18:08:38 GMT

I'm very very new to SAS so i'm sorry if I posted this in the incorrect place.

I'm trying to connect to SAS from a C#.net web app. I can't find a good tutorial on how to do this and with what objects.

Do I have to use some SAS objects or can I use the .net OLE DB connection object?

Thank You for any help

Jerry

Re: C# connection string to SAS

deleted_user — Thu, 11 Dec 2008 00:12:57 GMT

you may choose the SAS integration technologies

some examples
http://support.sas.com/rnd/itech/doc9/dev_guide/dist-obj/winclnt/windotnet.html
http://support.sas.com/kb/26/056.html
http://support.sas.com/kb/25/276.html

software required
http://www.sas.com/apps/demosdownloads/inttechclientwn_PROD_9.1_sysdep.jsp?packageID=000301&jmpflag=N

Re: C# connection string to SAS

LinusH — Thu, 11 Dec 2008 10:30:37 GMT

If you just want to retrieve data, other possibilities might exist (and requirements for licensed software). See on-line doc for OLE DB processing with SAS:

http://support.sas.com/documentation/tools/oledb/

/Linus

Re: C# connection string to SAS

deleted_user — Thu, 11 Dec 2008 18:35:11 GMT

Thank you both for your tips.
I have it going now but I keep getting errors with the Com components.
How can I get the workspacemanager component to show up in dcomcnfg?

I keep getting an error on this line of code:
Workspace ws = (Workspace)wsm.Workspaces.CreateWorkspaceByServer("",
SASWorkspaceManager.Visibility.VisibilityProcess, null, "", "", out
errorMessage);

Error
System.Runtime.InteropServices.COMException:

0

0x80080005
Server execution failed

Thank you
Jerry