Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » sql server 2005 error only with data:sample contents
sql server 2005 error only with data:sample contents [message #51970] Mon, 05 January 2009 23:07 Go to next message
zooman is currently offline zoomanFriend
Messages: 2
Registered: July 2009
Junior Member
Hello, i successfully connected using eclipse 3.4 and DTP 1.6 to my SQL
SERVER 2005 machine. I can view tables, and via SQL scrapbook query
databases. However, when I right click on my table, then select DATA and
SAMPLE CONTENTS, i always get this error:

Starting run
SELECT * FROM "healthcore"."ihg_database"
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name
'healthcore.ihg_database'.

Invalid object name?

in sql scrapbook i type

select * from ihg_database

and I can successfully get a result set back. How do i properly configure
SAMPLE CONTENTS so it works?
Re: sql server 2005 error only with data:sample contents [message #52258 is a reply to message #51970] Mon, 12 January 2009 23:48 Go to previous message
Brian Payton is currently offline Brian PaytonFriend
Messages: 152
Registered: July 2009
Senior Member
We aren't able to reproduce this error on our SQL Server database.

A few things to check and try:
1) Do you have a schema named "healthcore"? Is it defined as all lower
case?
2) If you type
select * from "healthcore"."ihg_database"
in SQL Scrapbook, do you get the same error? What about
select * from healthcore.ihg_database
(that is, without quotes)?

zooman wrote:
> Hello, i successfully connected using eclipse 3.4 and DTP 1.6 to my SQL
> SERVER 2005 machine. I can view tables, and via SQL scrapbook query
> databases. However, when I right click on my table, then select DATA
> and SAMPLE CONTENTS, i always get this error:
>
> Starting run
> SELECT * FROM "healthcore"."ihg_database"
> com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name
> 'healthcore.ihg_database'.
>
> Invalid object name?
> in sql scrapbook i type
>
> select * from ihg_database
>
> and I can successfully get a result set back. How do i properly
> configure SAMPLE CONTENTS so it works?
>
>
Re: sql server 2005 error only with data:sample contents [message #594213 is a reply to message #51970] Mon, 12 January 2009 23:48 Go to previous message
Brian Payton is currently offline Brian PaytonFriend
Messages: 152
Registered: July 2009
Senior Member
We aren't able to reproduce this error on our SQL Server database.

A few things to check and try:
1) Do you have a schema named "healthcore"? Is it defined as all lower
case?
2) If you type
select * from "healthcore"."ihg_database"
in SQL Scrapbook, do you get the same error? What about
select * from healthcore.ihg_database
(that is, without quotes)?

zooman wrote:
> Hello, i successfully connected using eclipse 3.4 and DTP 1.6 to my SQL
> SERVER 2005 machine. I can view tables, and via SQL scrapbook query
> databases. However, when I right click on my table, then select DATA
> and SAMPLE CONTENTS, i always get this error:
>
> Starting run
> SELECT * FROM "healthcore"."ihg_database"
> com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name
> 'healthcore.ihg_database'.
>
> Invalid object name?
> in sql scrapbook i type
>
> select * from ihg_database
>
> and I can successfully get a result set back. How do i properly
> configure SAMPLE CONTENTS so it works?
>
>
Previous Topic:How to go about a DDL parser
Next Topic:Removing some obsolete directories for DTP Galileo
Goto Forum:
  


Current Time: Sun Dec 21 19:37:57 GMT 2014

Powered by FUDForum. Page generated in 0.02233 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software