Home » Eclipse Projects » DTP » Data Soruce Explorer, No tables, only Schemas visible(Problem to see tables using JDBC Driver for MS SQL Server 2008)
Data Soruce Explorer, No tables, only Schemas visible [message #498812] |
Wed, 18 November 2009 17:15 |
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
Java JRE 1.6
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!
[Updated on: Thu, 19 November 2009 07:27] Report message to a moderator
|
|
|
Re: Data Soruce Explorer, No tables, only Schemas visible [message #499664 is a reply to message #498812] |
Mon, 23 November 2009 16:15 |
Brian Fitzpatrick Messages: 500 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!
>
>
>
|
|
| | | | | | |
Goto Forum:
Current Time: Wed Apr 24 23:54:28 GMT 2024
Powered by FUDForum. Page generated in 0.03955 seconds
|