sas oledb connection with c# in iom provider 9.3 is working and not working in webapplication?

Reply
N/A
Posts: 1

sas oledb connection with c# in iom provider 9.3 is working and not working in webapplication?

i am trying to connect the sas with oledb and the code is working when i am connecting in console application in.net.but the same code not working in webapplication(mvc2.0).why ? i am using sas.iomprovider 9.3?The error is "sas.iomprovider.9.3 not registered in local machine?

Please help me out on this?

My Code:

SASObjectManager.ObjectFactoryClass objFactory = new SASObjectManager.ObjectFactoryClass();

                SASObjectManager.ServerDefClass serverDef = new SASObjectManager.ServerDefClass();

                serverDef.BridgeEncryptionAlgorithm = "SASProprietary";

                serverDef.BridgeEncryptionLevel = SASObjectManager.EncryptionLevels.EncryptUserAndPassword;

                serverDef.MachineDNSName = "sas01.xyz.net";

                serverDef.Port = 8591;

                serverDef.Protocol = SASObjectManager.Protocols.ProtocolBridge;

                serverDef.Name = "SASApp - Workspace Server";

                SAS.Workspace sasWorkspace = null;

                sasWorkspace =

                    (SAS.Workspace)

                    objFactory.CreateObjectByServer("BridgeConnection", true, serverDef, "username", "password");

                //string i = sasWorkspace.Name;

                string wsId = sasWorkspace.UniqueIdentifier;

                connection = new System.Data.OleDb.OleDbConnection("Provider=sas.iomprovider.9.3; DatasourceSAS Workspace ID=" + wsId);

Ask a Question
Discussion stats
  • 0 replies
  • 367 views
  • 0 likes
  • 1 in conversation