04-20-2016 11:32 AM
Did not work.
Here is a code snippet
libname LumenDB OLEDB init_string="................" schema=dbo;
create table Lumen1 as
select EntryID, UserID, ServerID
Neither of these worked. Got the ActivityLog.Entry is not a valid SAS name.
04-21-2016 08:59 AM
I did try 'ActivityLog.Entry'n. It let me assign the value to a variable with no problem. However, I still got the error "table name not recognized" when I used the variable in either a SET or a "Select..." statement.
04-21-2016 09:52 AM
I am using OLEDB instead of ODBC. However, i tried these option in the init_string, in provider_string, etc. They gave no errors, but I still get the error "ActivityEntry.Entry is an invalid table name......."
04-21-2016 09:07 PM
04-26-2016 07:34 AM
Actually found the issue was not related to how I tried to access the table. The instances actually has two database owners. i put in the correct owner in the "schema'" of the libname and all worked. Thanks for all the suggestions.