While reading the SAS dataset in .net core, I am getting the below exception. I have used both the providers "sas.LocalProvider" and "sas.iomprovider.1"
Sas Program:
options formchar="|----|+|---+=|-/\<>*";
proc means data=sashelp.cars; class origin; var msrp invoice; run;
.net core program using "sas.iomprovider.1":
using (OleDbConnection sas = new OleDbConnection($"provider=sas.iomprovider.1; SAS Workspace ID={sasLibrary}")) { string query = $"SELECT * FROM {sasLoadDataRequest.Data}";
System.Data.DataSet sasDs = new System.Data.DataSet();
OleDbCommand command = new OleDbCommand(query, sas); OleDbDataAdapter adapter = new OleDbDataAdapter(command); adapter.Fill(sasDs);
sas.Close(); }
While reading the dataset "sashelp.cars" getting the below error
Exception thrown at 0x00007FFCEAEBA799 in w3wp.exe: Microsoft C++ exception: _com_error at memory location 0x0000002BB63AD620. The thread 0x443c has exited with code 0 (0x0). The thread 0x5428 has exited with code 0 (0x0). Exception thrown at 0x00000000100265C7 (sasaorio0902.dll) in w3wp.exe: 0xC0000005: Access violation reading location 0x000000004CC29C40.
SAS program:
libname test "F:\SAS App\"; options ls=72; options formchar="|----|+|---+=|-/\<>*";
proc means data=sashelp.cars; class origin; var msrp invoice; output out=test.ds; run;
Finally using the same above sas program and using the below .net core program still getting the exception
.net core program using "sas.LocalProvider":
using (OleDbConnection sas = new OleDbConnection($"Provider=sas.LocalProvider; Data Source=F:\\SAS App\\")) { string query = "ds";
System.Data.DataSet sasDs = new System.Data.DataSet();
OleDbCommand sasCommand = sas.CreateCommand();
sasCommand.CommandText = query; sasCommand.CommandType = CommandType.TableDirect;
OleDbDataAdapter da = new OleDbDataAdapter(sasCommand); da.Fill(sasDs);
sas.Close(); }
Unhandled exception at 0x0000000010010B8C (sasafloc0902.dll) in w3wp.exe: 0xC0000005: Access violation reading location 0x000000005C5981D0.
The above errors are crashing the w3wp.exe process.
Kindly please help me resolve this error.
... View more