I'm using Dharma ODBC to create a linked server to a databalse residing on
an SCO Unix box. The linked server looks good. However, when I tried to run
select statments (or creating views), the following error messages always
came up:

Server: Msg 7315, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' contains multiple tables that match the name
'bfl_ar_totals'.
OLE DB error trace [Non-interface error: OLE DB provider contains multiple
tables which match the given name: ProviderName='MSDASQL',
TableName='bfl_ar_totals'].

How can I restrict the ODBC to see only single catalogued table?
Thanks
Bill

I assume you have to provide the database name and/or the schema/owner name
as well as the table name?

--
Jacco Schalkwijk
SQL Server MVP



"Bill Nguyen" <billn_nospam_please@jaco.com> wrote in message
news:eeaylZxnDHA.2592@TK2MSFTNGP10.phx.gbl...
> I'm using Dharma ODBC to create a linked server to a databalse residing on
> an SCO Unix box. The linked server looks good. However, when I tried to
run
> select statments (or creating views), the following error messages always
> came up:
>
> Server: Msg 7315, Level 16, State 1, Line 1
> OLE DB provider 'MSDASQL' contains multiple tables that match the name
> 'bfl_ar_totals'.
> OLE DB error trace [Non-interface error: OLE DB provider contains
multiple
> tables which match the given name: ProviderName='MSDASQL',
> TableName='bfl_ar_totals'].
>
> How can I restrict the ODBC to see only single catalogued table?
> Thanks
> Bill
>
>

This is my sql syntax:

select h.*
from cpro1..dharma.bc h

CPRO1 = linked server name
dharma = catalog
bc = table

The following syntax worked with VIEWs, not tables:

Create View vw_bfl_ar_details as
SELECT bfl.*
FROM cpro1..dharma.bfl_ar_details bfl
go


Any suggestion is greatly appreciated.
Bill

"Jacco Schalkwijk" <NOSPAMjaccos@eurostop.co.uk> wrote in message
news:u%23rSTkynDHA.2772@TK2MSFTNGP12.phx.gbl...
> I assume you have to provide the database name and/or the schema/owner
name
> as well as the table name?
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
>
>
> "Bill Nguyen" <billn_nospam_please@jaco.com> wrote in message
> news:eeaylZxnDHA.2592@TK2MSFTNGP10.phx.gbl...
> > I'm using Dharma ODBC to create a linked server to a databalse residing
on
> > an SCO Unix box. The linked server looks good. However, when I tried to
> run
> > select statments (or creating views), the following error messages
always
> > came up:
> >
> > Server: Msg 7315, Level 16, State 1, Line 1
> > OLE DB provider 'MSDASQL' contains multiple tables that match the name
> > 'bfl_ar_totals'.
> > OLE DB error trace [Non-interface error: OLE DB provider contains
> multiple
> > tables which match the given name: ProviderName='MSDASQL',
> > TableName='bfl_ar_totals'].
> >
> > How can I restrict the ODBC to see only single catalogued table?
> > Thanks
> > Bill
> >
> >
>
>

Not all databases support the four part naming convention (MySQL is one of
them). You can work around this by setting up a linked server and using
OPENQUERY, for example:
Create View vw_bfl_ar_details as
SELECT <column list>
FROM OPENQUERY(<linked sevrer>, 'SELECT <column list> FROM bfl_ar_details')

If this doesn't help you have to check the documentation for the ODBC driver
and the database you are connecting to.

--
Jacco Schalkwijk
SQL Server MVP


"Bill Nguyen" <billn_nospam_please@jaco.com> wrote in message
news:ut$Ud$0nDHA.2272@tk2msftngp13.phx.gbl...
>
> This is my sql syntax:
>
> select h.*
> from cpro1..dharma.bc h
>
> CPRO1 = linked server name
> dharma = catalog
> bc = table
>
> The following syntax worked with VIEWs, not tables:
>
> Create View vw_bfl_ar_details as
> SELECT bfl.*
> FROM cpro1..dharma.bfl_ar_details bfl
> go
>
>
> Any suggestion is greatly appreciated.
> Bill
>
> "Jacco Schalkwijk" <NOSPAMjaccos@eurostop.co.uk> wrote in message
> news:u%23rSTkynDHA.2772@TK2MSFTNGP12.phx.gbl...
> > I assume you have to provide the database name and/or the schema/owner
> name
> > as well as the table name?
> >
> > --
> > Jacco Schalkwijk
> > SQL Server MVP
> >
> >
> >
> > "Bill Nguyen" <billn_nospam_please@jaco.com> wrote in message
> > news:eeaylZxnDHA.2592@TK2MSFTNGP10.phx.gbl...
> > > I'm using Dharma ODBC to create a linked server to a databalse
residing
> on
> > > an SCO Unix box. The linked server looks good. However, when I tried
to
> > run
> > > select statments (or creating views), the following error messages
> always
> > > came up:
> > >
> > > Server: Msg 7315, Level 16, State 1, Line 1
> > > OLE DB provider 'MSDASQL' contains multiple tables that match the name
> > > 'bfl_ar_totals'.
> > > OLE DB error trace [Non-interface error: OLE DB provider contains
> > multiple
> > > tables which match the given name: ProviderName='MSDASQL',
> > > TableName='bfl_ar_totals'].
> > >
> > > How can I restrict the ODBC to see only single catalogued table?
> > > Thanks
> > > Bill
> > >
> > >
> >
> >
>
>