topic Re: I am trying to access SAS dataset in C# and keep getting a error. in Developers

I am trying to access SAS dataset in C# and keep getting a error.

muungo60 — Thu, 29 Sep 2022 14:28:42 GMT

A server error has occurred: ERROR: Unexpected ERROR from SHRWTSK5 detected by TERMINATE WORK TASK in "ERREB"(0): ERROR: Generic critical error.; fn =yhelasg; context =sase9lib.dll.

using (OleDbConnection conn = new OleDbConnection(GlobalConfig.SASConn()))
{
conn.Open();

OleDbCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "libname survlib '" + pSASSurveyFolder3 + "'";

cmd.ExecuteNonQuery();

cmd.CommandType = CommandType.TableDirect;
cmd.CommandText = "vstatps";

//other option is to use the cmd.ExecuteReader();
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
da.Fill(sasDs);

}

Re: I am trying to access SAS dataset in C# and keep getting a error.

ChrisHemedinger — Thu, 29 Sep 2022 14:36:16 GMT

For a test, try the project I've shared here to connect a .NET application to a SAS Workspace and data. There are some tricks, including the ObjectKeeper mechanism to reference the SAS connection during your session.

Re: I am trying to access SAS dataset in C# and keep getting a error.

muungo60 — Thu, 29 Sep 2022 14:41:58 GMT

Thanks Chris..Will check it out.

Re: I am trying to access SAS dataset in C# and keep getting a error.

muungo60 — Thu, 29 Sep 2022 14:51:30 GMT

Chris, I checked out your project and your connection string looks different than mine. Mine looks like this.

return @"Provider = sas.shareprovider.1; data source = xxxx; location = xxxx; SAS Server Access Password =xxxx";

Re: I am trying to access SAS dataset in C# and keep getting a error.

ChrisHemedinger — Thu, 29 Sep 2022 15:12:41 GMT

It looks like you are trying to connect to a SAS/SHARE server. Is that correct? You aren't connecting to a SAS Workspace via SAS Integration Technologies?

Basic example for SAS/SHARE (and I mean really basic) is in this doc.

We also have an ODBC driver for SAS/SHARE, might be worth testing if that's your case.

Re: I am trying to access SAS dataset in C# and keep getting a error.

muungo60 — Thu, 29 Sep 2022 15:36:36 GMT

Yes, you are correct. The Basic example for SAS/SHARE you linked is exactly what my connection string looks like. My issue is what to do next. Using the connection, I connect to the libraries like this.

cmd.Connection = conn;
cmd.CommandText = "libname survlib '" + pSASSurveyFolder + "'";
cmd.ExecuteNonQuery();

At this point, no errors. It's when I try to retrieve data from the datasets using a sql statement that I get an error. It's here that I need some guidance. Thanks for the help!!!

Re: I am trying to access SAS dataset in C# and keep getting a error.

ChrisHemedinger — Thu, 29 Sep 2022 16:21:39 GMT

I think your CommandText should be an SQL command. Ex:

select * from SURVLIB.VSTATPS

Re: I am trying to access SAS dataset in C# and keep getting a error.

muungo60 — Thu, 29 Sep 2022 16:34:45 GMT

Ok. I just tried that and now it says that "SURVLIB" is not assigned. Don't we define the library first and then execute sql?

Re: I am trying to access SAS dataset in C# and keep getting a error.

ChrisHemedinger — Thu, 29 Sep 2022 16:50:08 GMT

Usually with SAS/SHARE the library is already defined. That's the point of SAS/SHARE -- to enable other applications to connect to curated data sources that are maintained in a SAS environment, served up by a SAS/SHARE server. It's not a place to run SAS code (like a LIBNAME statement) -- that's a SAS Workspace.

Re: I am trying to access SAS dataset in C# and keep getting a error.

ChrisHemedinger — Thu, 29 Sep 2022 16:56:50 GMT

You could try something like this.

cmd.Connection = conn;
cmd.CommandText = "libname survlib '" + pSASSurveyFolder + "';";
cmd.ExecuteNonQuery();
cmd.CommandType = CommandType.TableDirect;
cmd.CommandText = "survlib.vstatps";
OleDbDataReader myReader = cmd.ExecuteReader();

Re: I am trying to access SAS dataset in C# and keep getting a error.

muungo60 — Thu, 29 Sep 2022 18:07:26 GMT

Thanks Chris. Will try it...

Re: I am trying to access SAS dataset in C# and keep getting a error.

muungo60 — Thu, 29 Sep 2022 18:26:05 GMT

Everything works fine until I try to execute the reader and I get this:

Error A server error has occurred: ERROR: Unexpected ERROR from SHRWTSK8 detected by TERMINATE WORK TASK in "ERREB"(0): ERROR:

Generic critical error.; fn =yhelasg; context =sase9lib.dll.

Re: I am trying to access SAS dataset in C# and keep getting a error.

ChrisHemedinger — Fri, 30 Sep 2022 12:43:07 GMT

I searched internal information here and found a documented problem that has been addressed in a SAS/SHARE hotfix:

https://support.sas.com/kb/62/346.html

I don't know if you have any control/influence on this SAS/SHARE server to request that all hotfixes get applied. If not, I'm not sure how to address. You might try using the SAS/SHARE ODBC driver instead, which might follow a different code path.

Re: I am trying to access SAS dataset in C# and keep getting a error.

muungo60 — Mon, 03 Oct 2022 12:45:45 GMT

Thanks Chris..Will read the article and see what can be done.