Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Data Soruce Explorer, No tables, only Schemas visible
Data Soruce Explorer, No tables, only Schemas visible [message #596810] Wed, 18 November 2009 17:15 Go to next message
mr. burns is currently offline mr. burns
Messages: 402
Registered: July 2009
Senior Member
Hi all,

I tried whole day to get a connection from Eclispe to MS SQL Server 2008 using DTP, but without success.

My Eclispe version:
3.5.1
Build id: M20090917-0800

My DTP version:
Version: 1.7.0.v200908280400-7J8i2BWwQJOaz-Gi2C5seJM2FX2f
Build id: 1.7.1.v20090904-0500

Microsoft SQL Server 2008 on Windows Server 2003 R2, Standard x64 Edition


I set up connection under Data Source Explorer, using Generic JDBC and also another one using SQL Server.
I used sqljdbc4.jar.

The ping to my database server succeeded.
In Data Source Explorer I can see also the databases. But if I click the + sign to open a certain database I only see a folder called Schemas, but no tables, no views, etc..

I looked up internet to find a solution, but no success.

What I am doing wrong?

Thanks for any help!
Re: Data Soruce Explorer, No tables, only Schemas visible [message #596844 is a reply to message #596810] Mon, 23 November 2009 16:15 Go to previous message
Brian Fitzpatrick is currently offline Brian Fitzpatrick
Messages: 495
Registered: July 2009
Senior Member
Hi Mr. Burns...

There are some issues with SQL Server support in Galileo at the moment.
Sounds like you're fighting this one:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=287587

And there's another one as well...
https://bugs.eclipse.org/bugs/show_bug.cgi?id=284104

The resources we've had working on MSSQL haven't had a chance to resolve
this in the 1.7.x maintenance stream yet, but I'm still hopeful it will
get resolved.

Our issue right now is a lack of bodies helping out on Enablement
support. We love people who provide patches to fix issues. :)

Sorry I don't have better news than that at the moment.

--Fitz

mr. burns wrote:
> Hi all,
>
> I tried whole day to get a connection from Eclispe to MS SQL Server 2008
> using DTP, but without success.
>
> My Eclispe version:
> 3.5.1
> Build id: M20090917-0800
>
> My DTP version:
> Version: 1.7.0.v200908280400-7J8i2BWwQJOaz-Gi2C5seJM2FX2f
> Build id: 1.7.1.v20090904-0500
>
> Microsoft SQL Server 2008 on Windows Server 2003 R2, Standard x64 Edition
>
>
> I set up connection under Data Source Explorer, using Generic JDBC and
> also another one using SQL Server.
> I used sqljdbc4.jar.
>
> The ping to my database server succeeded.
> In Data Source Explorer I can see also the databases. But if I click the
> + sign to open a certain database I only see a folder called Schemas,
> but no tables, no views, etc..
>
> I looked up internet to find a solution, but no success.
>
> What I am doing wrong?
>
> Thanks for any help!
>
>
>
Previous Topic:erroneous repeating row values in SQL Results view
Next Topic:Can DTP/ODA be used outside Eclipse
Goto Forum:
  


Current Time: Thu Oct 23 14:40:56 GMT 2014

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

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