Linked Servers: Invalid schema

From: Malcolm (malcolmg_at_nuj.org.uk)
Date: 04/28/04 

Date: Wed, 28 Apr 2004 14:13:17 -0700

Hi

This may not be much help but.....I'm having the same
problem with MySQL. (1) Have you put a trace on the ODBC
call (do 'DBCC Traceon(7300)'in query analyser)- that gets
me some crud about 'nulls'. Do you get the same?. (2)
Anyway, as far as I am aware, catalog refers to the
database you are trying to connect to and schema refers to
the owner of the object you're trying to get at. My
question is, is the object owner in your other database
called something other than 'dbo' which is the name in
SQL2000 and are you using 'dbo' as the third part of the 4
part string?

I wouldn't normally ask questions in response to a
question but your posting seems to indicate that this is
not uncommon but no-one's posted an answer:-(

Malcolm
>-----Original Message-----
>I am having a problem referencing tables via a linked
>server in SQL queries using the
>syntax as exampled in the following simple illustration:
>
> SELECT * FROM LinkedServerName.Catalog.Schema.TableName
>
>The connection string I am using seems to be correct
>because I can see the table names when I expand the
>server in Enterprise Manager and I have also used it
>elsewhere (to generate a recordset using ADO and VBScript
>in a DTS package).
>When the above query is executed (in Query Analyser, for
>example) I get the following error message:
>
> 'OLE DB provider 'MSDASQL' returned an invalid schema
> definition. OLE DB error trace [Non-interface error:
> OLE/DB provider returned an invalid schema finition.].'
>
>The linked server is actually a Recital database
>connected using OLEDB for ODBC using the Recital ODBC
>driver. It does not have a direct equivalent of schema
>and catalogues and does not expose the interface which
>MSSQL Server seems to require.
>
>I have searched the internet (including various forums,
>e.g. dbforum) and have found quite a number of similar
>cases logged for a variety of other databases, but no one
>has replied with a solution.
>
>I really want to be able to write update queries using a
>mixture of SQL and Recital data and the linked server
>would be an attractive solution - if it worked!!!.
>
>Any suggestions.
>
>N.b. I have managed to use OPENROWSET, but not for update.
>
>.
>

Relevant Pages

  • Re: MailMerge hangs and crashes with Access on Server
    ... Since I am fairly new to working in this environment, I am not sure what you mean by an "Access group" with help to restructuring the query? ... "Peter Jamieson" wrote: ... All I know is that the performance of queries depends to a large extent on whether, for example, a join is performed on the client side, or on the server side, incurring no network traffic and potentially benefitting from caching on the server. ... There are no dialog boxes, and actually, I have now split the database, and have kept the Word templates and the Access frontend locally on my machine, and moved the backend to the server. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: fields queries and utter disaster
    ... Unfortunately the \c ODBC DATABASE field switch is not supported in Word ... Mac Word Test ... suggests that it should be possible to use query files (cf. .qry/.dqy ...
    (microsoft.public.mac.office.word)
  • Re: fields queries and utter disaster
    ... Unfortunately the \c ODBC DATABASE field switch is not supported in Word ... of course supports ODBC connections but Word ... Mac Word Test ... suggests that it should be possible to use query files (cf. .qry/.dqy ...
    (microsoft.public.mac.office.word)
  • Re: MailMerge hangs and crashes with Access on Server
    ... restructuring a complex query. ... discards 99% of them), or on the server side, incurring no network ... the database is locked and Word will not open the data source. ... have kept the Word templates and the Access frontend locally on my machine, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: MailMerge hangs and crashes with Access on Server
    ... I have mapped out the path to the final query that is used to get to the ... the database is locked and Word will not open the data source. ... have kept the Word templates and the Access frontend locally on my machine, ... and moved the backend to the server. ...
    (microsoft.public.word.mailmerge.fields)
Loading