topic Re: SAS OLE DB error in ODS and Base Reporting

SAS OLE DB error

danr — Wed, 16 Sep 2009 21:10:56 GMT

Sorry if this in the wrong forum, I don't actually know anything about SAS but I have a SAS file (.sas7bdat) that I need to load into SQL Server 2008. While trying to use the "SAS Local Data Provider 9.2" I get these errors:

Error Description: A Server error has occured: ;fn=ydedopn; context =sasej9lib0902.dll; fn=ydedopn; context =sasej9lib0902.dll.

and

Error Description: A provider specific error occured (SASUPDataSet::OpenFile() : Data Set Name (cTableByteLen) too long. Not a Valid SAS Name).

The errors occurs as soon as you set the file to be a data source.

The file can be loaded into SQL Server 2000 using ODBC (SAS Universal ODBC Driver) so it is a valid file, despite what the second error seems to suggest.

Any help that can be provided would be appreciated.

Re: SAS OLE DB error

NullPointer — Thu, 05 Nov 2015 08:59:03 GMT

Just in case anybody else comes here and there is no solution..

According to the documentation, the data source should be set to the folder where the sas7bdat file(s) reside.

The provider treats the folder as the “database” and each file is a “table” in the “database”

"Provider=sas.LocalProvider; Data Source=C:\SASInputFiles\"

Each file is then treated as a table..

Hope this helps!