make a query to the remote server in Query Analyzer. However, when updating
from a CFM page, this error occurs:
Error Executing Database Query. [Macromedia][SQLServer JDBC
Driver][SQLServer]Could not find server 'Ven_Live' in sysservers. Execute
sp_addlinkedserver to add the server to sysservers.
I ran a select statement on sysservers, and the server is in the sysservers
table in the master database. The server is MX 6.1, and the data source is
a Microsoft SQL socket. The data source verifies okay in the ColdFusion
administrator. I've get the error regardless of whether an OS DSN exists or
not. Are there any special requirements to setting up linked servers?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
