Hi, MSSQL freaks,

I've found the reason why sending data from MSSQl to SYBASE with help of selfmade C++ program as xp_.... could not bring the right results if we use MSSQL Management Jobs.

Pls be sure for checking / ev. correcting the following values:

a) select uid from msdb where name = 'name used for connection
between MSSQL and SYBASE'

b) on SYBASE DB, to which we are sending data, that connection user
MUST have the following conditions:

select suid, uid from msdb where name = 'name used for connection
between MSSQL and SYBASE'

c) suid and uid from b) SHOULD BE the SAME as from a) !!!!!!!!!!!!!!!!!!

d) if NO, pls change the configuration on SYBASE! (sp_configure 'allow...',1 then update sysusers set suid=..., uid=...
and so on - every DBA should know it)


Zbig