topic Error in log in SAS Procedures

Error in log

sassharp — Fri, 02 Mar 2012 18:31:43 GMT

proc sql;

connect to sqlsvr(dsn=xxx user=yyy pwd='zzz');

execute (truncate table base.monthlydata) by sqlsvr;

disconnect from sqlsvr;

quit;

error in log

ERROR: CLI execute error: [DataDirect][ODBC SQL Server Driver][SQL Server]Cannot find the object "monthlydata" because it does not

exist or you do not have permissions.

when I check the sqlsvr side the monthlydata table exists.

Error in log

Hima — Mon, 05 Mar 2012 17:37:59 GMT

Did you check if you have the permissions to truncate the table and have you checked if you can query on that table?

Error in log

sassharp — Mon, 05 Mar 2012 19:20:46 GMT

I checked the table is there. I queried the table also Hima.

Error in log

andreas_lds — Tue, 06 Mar 2012 09:08:25 GMT

sassharp wrote:

I checked the table is there. I queried the table also Hima.

And you have the required permissions to perform a truncate on the table?

Error in log

Learner_SAS — Tue, 06 Mar 2012 11:16:00 GMT

This is the problem with permission . I beleive this user in coonection does not have that permission for DDL. (truncate).

Error in log

sassharp — Tue, 06 Mar 2012 15:15:20 GMT

I can delete table, drop table from SAS side. Why not truncate?

Error in log

Vish33 — Tue, 06 Mar 2012 16:10:35 GMT

yeah..u will be having access to delete or drop a table from SAS side, but when u r trying to connect to external data base (sqlserver). you might not be having access to truncate a table or delete a table. only DBA's or database developers will be having access to truncate or delete the table.

Regards,

vishnu