Could not find server
- From: "Eibi" <ahirschp@xxxxxxxxx>
- Date: 13 Jun 2006 13:45:05 -0700
I have linked a server withinh the "SQL Server Management Studio
Express"
I also created a database where I created a view using the openquiery
statement.
The view runs perfectly within the "SQL Server Management Studio
Express"
I created a new project with "Microsoft Visual Studio 2005"
I created a shared data source to the database where I created the
views.
The data source is OK because I can see the cretaed views on the Query
Builder.
Once I created the query on the Query Builder and I try to run it, the
following message appears:
"SQL Execution Error
Error Source: .NetSqlClient Data Provider
Error Message: Could not find server 'xxx' in sysservers. Execute
sp_addlinkedserver to add the server to sysservers.
Could not use view or function 'xxx' because of binding errors"
I have looked for server 'xxx' in sysservers and it is there, so I do
not understand where the error originates.
Any help would be most appreciated.
Abraham Hirsch
Mexico City
.
- Prev by Date: Determine Bin Directory For SQL Server
- Next by Date: Is this a SQL server BUG?
- Previous by thread: Determine Bin Directory For SQL Server
- Next by thread: Is this a SQL server BUG?
- Index(es):
Relevant Pages
|
