Versions Compared
Version | Old Version 7 | New Version 8 |
---|---|---|
Changes made by | ||
Saved on |
Key
- This line was added.
- This line was removed.
- Formatting was changed.
...
DCOM Settings (NLINK Server and SQL Server on different machines)
Testing Old-Style Stored Procedures
With old-style stored procedure use the Test sp_NLINK.sql script which is available from Junot Systems.
Look at values returned in @ErrorMsg, to debug issues.
Testing
New-StyleTrigger Stored Procedures
With new-style stored procedure use Use the Test sp_NLINK new.sql script which is available from Junot Systems.
Look at values returned in @ErrorMsg, to debug issues.
...
If the NLINK Server and Microsoft SQL Server are on different computers, then DCOM security settings have to be properly configured for the trigger to work. The instructions assume that you are familiar with, and have the appropriate privileges to be able to perform systems administration tasks on your Windows system.
Configure DCOM the Computer running the NLINK Server:
Windows Firewall (or any similar application) may also cause issues. Please contact your on-site systems administration professionals for help regarding Firewalls.
Configure DCOM on the SQL Server computer: