"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
> >
> >
>
>

"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
>
>

"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
> > >
> > >
> >
> >
>
>