Can not connect to some tables with seagate crystal report

Seagate crystal reports:
When i am trying to attach a table to seagate crystal report i am getting
this error:
Database Error: [Microsoft][ODBC SQL Server Driver][SQL
Server][DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.
I can connect to other tables in same database. One thing that is different
in the tables which i can not connect is that its name is like (Application
Name.dbo.samplecounty-etp.etp.Emp_Qualifications). Can naming syntex of table
cause connection issue or its a permission issue?
ontario, canada
SQL server 2000 enterprise edition. The problem is with the table name.
Somehow crystal report does not accept table name with "."
Does anyone know a wayaround.
ontario, canada
"db" wrote:

> Seagate crystal reports:
> When i am trying to attach a table to seagate crystal report i am getting
> this error:
> Database Error: [Microsoft][ODBC SQL Server Driver][SQL
> Server][DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
> access denied.
> I can connect to other tables in same database. One thing that is different
> in the tables which i can not connect is that its name is like (Application
> Name.dbo.samplecounty-etp.etp.Emp_Qualifications). Can naming syntex of table
> cause connection issue or its a permission issue?
>
> --
> ontario, canada
|||"db" <db@.discussions.microsoft.com> wrote in message
news:6013B66D-ECA6-4B76-8480-B72E5ED7DC47@.microsoft.com...
> SQL server 2000 enterprise edition. The problem is with the table name.
> Somehow crystal report does not accept table name with "."
> Does anyone know a wayaround.
> --
> ontario, canada
Rename the table? Create/use a view with a name that Crystal likes? Or
perhaps post on a newsgroup that is specific to crystal reports. You do
know that Seagate is no longer involved with Crystal Reports and hasn't been
for some years - that would indicate you are using an old (and perhaps
unsupported) version.
|||Views works.
Thanks
"Scott Morris" wrote:

> "db" <db@.discussions.microsoft.com> wrote in message
> news:6013B66D-ECA6-4B76-8480-B72E5ED7DC47@.microsoft.com...
> Rename the table? Create/use a view with a name that Crystal likes? Or
> perhaps post on a newsgroup that is specific to crystal reports. You do
> know that Seagate is no longer involved with Crystal Reports and hasn't been
> for some years - that would indicate you are using an old (and perhaps
> unsupported) version.
>
>