cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ReidarDMidtun
‎10-27-2021
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 1 Likes Received

Re: How to deploy a windows .NET app using SAS Integration technologie...

by Fluorite | Level 6 in SAS Programming
‎10-27-2021 09:58 AM
‎10-27-2021 09:58 AM
Thanks for pointing me in the right direction!   The problem was solved by making the clients installing the "SAS Providers for OLE DB". ... View more

How to deploy a windows .NET app using SAS Integration technologies

by Fluorite | Level 6 in SAS Programming
‎10-25-2021 09:30 AM
‎10-25-2021 09:30 AM
I have developed a .NET app using the ADODB.dll and the SAS.dll, SASIOMCommon.dll and SASObjectManager.dll. After building the app, I have copied the exe file and all the referenced dll's to a shared drive. From my computer I can run the app on the shared drive, but other users on other computers can not run it, they get this error message:   Retrieving the COM class factory for component with CLSID {868CEB5F-4D78-43FC-96B4-F5B6C0341151} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).   It probably works for me who developed it, because I have installed the SAS Integration Technologies on my computer. So, my question is, how do I deploy an app that is build using the .NET dll's? Do I need a way to register types on the client computers?     ... View more

Re: How to use IOM provider to read Date values into a .NET applicati...

by Fluorite | Level 6 in SAS Programming
‎05-25-2021 05:38 AM
1 Like
‎05-25-2021 05:38 AM
1 Like
Once I got the recipe, making a transform from a SAS date value was easy.    A SAS datetime value is: The number of seconds since 12:00 midnight on January 1, 1960. This value has to be mapped to a .NET DateTime value. This value is the number of ticks since 12:00 midnight, January 1, 0001 A.D. (C.E.) in the Gregorian Calendar. A tick is 100 nanoseconds.   Here is the transform function written in C#:   private DateTime SASBaseDate = new DateTime(1960, 01, 01); private const long TicksInASecond = 10000000; private DateTime ToDate(object sasTics) { if (sasTics == null || sasTics is DBNull) return DateTime.MinValue; var lTicks = Convert.ToInt64(sasTics); return new DateTime(SASBaseDate.Ticks + (lTicks * TicksInASecond)); }   ... View more

How to use IOM provider to read Date values into a .NET application i...

by Fluorite | Level 6 in SAS Programming
‎05-19-2021 05:06 AM
‎05-19-2021 05:06 AM
I am using the IOM provider to read data from a SAS Base library into a .NET C# application. The problem arises when reading columns defined as Date values. When reading unformatted objects, the date values are returned as double floating point numbers. I need a function to transform the number to a .NET DateTime object.   I know I can instrument the IOM provider to return formatted string objects by setting       ADODB.Recordset.Properties["SAS Formats"] = "_ALL_"; If I use this to have formatted objects returned, there is a performance degrade, it runs 100 times slower. Due to this I was hoping I could used unformatted objects and transform the number to DateTime objects in the .NET world. Is there a .NET library with SAS date functions that can do this?   See case [SAS 7613337300] for more info.   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-27-2021 01:20 PM
Likes from
View All
Quick links