extra-picky syntax.
Select *
>From [LinkedServerName].[DatabaseName].[OwnerName].[TableName]
Where blah blah blah
Usually I use [DBO] for OwnerName.
-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Monday, June 21, 2004 12:40
To: CF-Server
Subject: RE: Linked server problem
> I set up a linked sever that connects fine in Enterprise
> Manager. I can 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?
Does the user account that CF's using for its datasource have rights to
query sysservers, or to connect to the linked database?
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
