C# connection string to SAS

[deleted_user]

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

[deleted_user]

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=...

[LinusH]

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

[deleted_user]

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