| sql server 2005 error only with data:sample contents [message #51970] |
Mon, 05 January 2009 18:07  |
Eclipse User |
|
|
|
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 18:48  |
| Eclipse User |
|
|
|
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 18:48 |
| Eclipse User |
|
|
|
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?
>
>
|
|
|
Powered by
FUDForum. Page generated in 0.07261 seconds
Home