I've such problem. I've Microsoft SQL Server and PI OLEDB Enterprise as linked server to it. We've develop a stored procedure that extract some data from AF using OLEDB Enterprise, combines it with data in SQL Server and return as result. All's working fine when I use Windows authorization to connect to SQL and execute this procedure.
But our application (based on IBM ILOG ODM) cannot use Windows authorization to connect to SQL Server, only SQL authorization can be used. I've executed my procedure under SQL authorization, and error message appear (I'll post the detail a bit later)
My question is: in case SQL authorization is used, which settings should be made on OLEDB Enterprise as Linked Server in SQL? Thank you in advance!