Showing posts with label 91microsoft91odbc. Show all posts
Showing posts with label 91microsoft91odbc. Show all posts

Thursday, March 22, 2012

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 ex
ist 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 tabl
e
cause connection issue or its a permission issue?
ontario, canadaSQL 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 differen
t
> in the tables which i can not connect is that its name is like (Applicatio
n
> Name.dbo.samplecounty-etp.etp.Emp_Qualifications). Can naming syntex of ta
ble
> 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 be
en
> for some years - that would indicate you are using an old (and perhaps
> unsupported) version.
>
>