Hello, I never post anything on this site, but I'm pretty stuck at a problem right now, so any help would be very much appreciated:) I'm trying to connect to a procedure called LL_ZD_iHist_one_coil and I don't know why I'm not getting the data from the server. I suspected it was just not having the rights to access it. I already called the server guys who added me to all usergroups available, but still not luck. The procedure I'm trying to run looks like this: proc sql;
connect to odbc(noprompt = "server=1.130.17.85 ;DRIVER=SQL Server; Trusted Connection=Yes; DATABASE=Technical;");
create table work.temp_historian as
select *
from connection to odbc
(
execute Technical.dbo.LL_ZD_iHist_one_coil
@coil_id = '10805800',
@track_no = '300',
@taglist = 'LLZPALSV.ROLL_FORCE.F_CV',
@interval = '10'
);
quit; The result is: ERROR: CLI prepare error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'NT AUTHORITY\ANONYMOUS LOGON'.
SQL statement: execute Technical.dbo.LL_ZD_iHist_one_coil @coil_id = '10805800', @track_no =
'300', @taglist = 'LLZPALSV.ROLL_FORCE.F_CV', @interval = '10'.
1349 quit; The weird thing is, if I unquote one of the parameters from the SQL statement, I get the following response: ERROR: CLI prepare error: [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function
'LL_ZD_iHist_one_coil' expects parameter '@interval', which was not supplied.
SQL statement: execute Technical.dbo.LL_ZD_iHist_one_coil @coil_id = '10805800', @track_no =
'300', @taglist = 'LLZPALSV.ROLL_FORCE.F_CV'. So SAS is able to at least communicate with the server. Combine that with the fact that I'm added to nearly any usergroup on this server and the fact that I can run other stored procedures from my SAS system leaves me out of options to try... Please let me know how to solve this problem? Thanks, Just
... View more