Re: How to call talbe/SP from Linked server with out database and

On Thu, 15 Sep 2005 22:05:01 -0700, Rajesha wrote:

>As you told with out user there is chance to work but , I tryed that I
>getting error.
>
>select * from [linkedserver].[database]..[TableName]
>
>gives below error.
>
>Server: Msg 7313, Level 16, State 1, Line 1
>Invalid schema or catalog specified for provider 'MSDASQL'.
>OLE DB error trace [Non-interface error: Invalid schema or catalog
>specified for the provider.].

Hi Rajesh,

Thanks for testing this, and posting back with the results.

So I guess that the answer to your original question is that this can't
be done - you must specify all four parts if you reference objects on a
linked server.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)
.

Relevant Pages

  • Re: loading tab-delimited files...
    ... error msg: Test connection failed because of an error initializing ... I went through and looked at every provider which might allow ... You should only specify the path. ... The filename is specified in the SQL statement as in the example I posted. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Java v/s ImageMagick
    ... ask for any information, rather than specify ... chance that the effort required is below those people's laziness-threshhold ... cheese", "42", etc. ... I agree with Andrew's request for more specifics. ...
    (comp.lang.java.programmer)
  • Re: This Membership Provider has not been configured to support password retrieval.
    ... "You must specify a non-autogenerated machine key to store passwords in the ... i think i need to define a custom provider for membership and i tried ... "This Membership Provider has not been configured to support password ...
    (microsoft.public.dotnet.framework.aspnet)
  • Event 5603 on sbs 2003
    ... "A provider, PerfProv, has been registered in the WMI namespace, ... but did not specify the ... Connection-specific DNS Suffix. ...
    (microsoft.public.windows.server.sbs)
  • Re: Unique ID added to a result set
    ... thank you for the response. ... That is pretty slick and works for ... my example however i did not specify that there is a chance that there ...
    (comp.databases.ms-sqlserver)