Hello, I can installed SAS on my local windows machine (server 2019) and am trying to parse a sas7bdat file though c# using the following commands: var connection = new OleDbConnection($"Provider=sas.LocalProvider; Data Source={folder}");
connection.Open();
var cmd = connection.CreateCommand();
cmd.CommandType = CommandType.TableDirect;
cmd.CommandText = filename;
var reader = cmd.ExecuteReader(); This produces the following error: System.Data.OleDb.OleDbException (0x80010105): 'sas.LocalProvider' failed with no error message available, result
code: -2147417851(0x80010105).
at System.Data.OleDb.OleDbCommand.ProcessResults(OleDbHResult hr)
at System.Data.OleDb.OleDbCommand.ExecuteTableDirect(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.OleDb.OleDbCommand.ExecuteReader()
at Program.<Main>$(String[] args) in C:\ImageBuild\InstallSas\Program.cs:line 56 I have tried everything I can think of and nothing really works. Does anyone have a direction on how to fix this?
... View more
