Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » MSSQL Connectivity
MSSQL Connectivity [message #23517] Tue, 28 November 2006 15:36 Go to next message
Karim Fateem is currently offline Karim FateemFriend
Messages: 6
Registered: July 2009
Junior Member
Hi,

I'm trying to use the MSSQL support in DTP 1.0 RC 0.
Does anyone know if MSSQL DSE tree-viewer support is fully implemented?
Nothing appears below "schemas" in the tree-viewer.

Has anyone had more luck?

Really appreciate your help,
Karim
Re: MSSQL Connectivity [message #23901 is a reply to message #23517] Mon, 04 December 2006 17:20 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: john.graham.sybase.com

Karim Fateem wrote:

> Hi,

> I'm trying to use the MSSQL support in DTP 1.0 RC 0.
> Does anyone know if MSSQL DSE tree-viewer support is fully implemented?
> Nothing appears below "schemas" in the tree-viewer.

> Has anyone had more luck?

> Really appreciate your help,
> Karim

Hi Karim,

I was able to get a DSE tree for MySQL 5.0 using the latest (12/1) DTP
build. The following link from our Wiki might help too:

http://wiki.eclipse.org/index.php/Connecting_to_MySQL_4.x_an d_5.x

I suspect that MySQL is not fully supported (in the sense that the tree
shows all the expected db objects and properties), but perhaps it is
enough for basic SQL query building and testing using our editor. In
general, DTP provides this base support for a number of data sources, and
looks to the community to flesh out the offering through our Enablement
project.

Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
Re: MSSQL Connectivity [message #23941 is a reply to message #23901] Tue, 05 December 2006 21:34 Go to previous messageGo to next message
Karim Fateem is currently offline Karim FateemFriend
Messages: 6
Registered: July 2009
Junior Member
Hi John - Looking for MS SQL Server 2000/2005 support.

Thank you for your help,
Karim
Re: MSSQL Connectivity [message #23978 is a reply to message #23901] Tue, 05 December 2006 21:46 Go to previous messageGo to next message
Karim Fateem is currently offline Karim FateemFriend
Messages: 6
Registered: July 2009
Junior Member
Hi John - Would there happen to be DSE support for MS SQL Server 2000 &
2005?

Thank you for your help,
Karim
Re: MSSQL Connectivity [message #28206 is a reply to message #23978] Mon, 26 March 2007 21:15 Go to previous messageGo to next message
Charles Doucette is currently offline Charles DoucetteFriend
Messages: 125
Registered: July 2009
Senior Member
I would also like to know the answer to this question.

I've installed DTP 1.5M5 on top of Eclipse 3.3M5eh (Europa).

I defined a connection profile to view the standard Northwind database. When
I connect to the database in the Data Source Explorer window, I don't see
any schema information.

Thanks,
Chuck

"Karim Fateem" <karim.fateem@hotmail.com> wrote in message
news:962b464fce76b71a7361c311fcd53487$1@www.eclipse.org...
> Hi John - Would there happen to be DSE support for MS SQL Server 2000 &
> 2005?
>
> Thank you for your help,
> Karim
>
>
Re: MSSQL Connectivity [message #28972 is a reply to message #28206] Fri, 06 April 2007 19:42 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: john.graham.sybase.com

Chuck Doucette wrote:

> I would also like to know the answer to this question.

> I've installed DTP 1.5M5 on top of Eclipse 3.3M5eh (Europa).

> I defined a connection profile to view the standard Northwind database. When
> I connect to the database in the Data Source Explorer window, I don't see
> any schema information.

> Thanks,
> Chuck

> "Karim Fateem" <karim.fateem@hotmail.com> wrote in message
> news:962b464fce76b71a7361c311fcd53487$1@www.eclipse.org...
>> Hi John - Would there happen to be DSE support for MS SQL Server 2000 &
>> 2005?
>>
>> Thank you for your help,
>> Karim
>>
>>

Chuck, Karim:

We do have a database definition for SQL Server, but apparently it is not
working with the later versions. We'll take a look at this for anything
obvious, but it is likely to require DTP specialization by some one (or
group) that knows this server well.

-- John Graham
Eclipse Data Tools Platform PMC Chair
Re: MSSQL Connectivity [message #29163 is a reply to message #28972] Tue, 10 April 2007 15:29 Go to previous messageGo to next message
Charles Doucette is currently offline Charles DoucetteFriend
Messages: 125
Registered: July 2009
Senior Member
But - I am using SQL 2000, not SQL 2005.

What versions of MS SQL Server do you support?

Chuck

"John Graham" <john.graham@sybase.com> wrote in message
news:8ba2915488891f75f591c14c8e61f34e$1@www.eclipse.org...
> Chuck Doucette wrote:
>
>> I would also like to know the answer to this question.
>
>> I've installed DTP 1.5M5 on top of Eclipse 3.3M5eh (Europa).
>
>> I defined a connection profile to view the standard Northwind database.
>> When I connect to the database in the Data Source Explorer window, I
>> don't see any schema information.
>
>> Thanks,
>> Chuck
>
>> "Karim Fateem" <karim.fateem@hotmail.com> wrote in message
>> news:962b464fce76b71a7361c311fcd53487$1@www.eclipse.org...
>>> Hi John - Would there happen to be DSE support for MS SQL Server 2000 &
>>> 2005?
>>>
>>> Thank you for your help,
>>> Karim
>>>
>>>
>
> Chuck, Karim:
>
> We do have a database definition for SQL Server, but apparently it is not
> working with the later versions. We'll take a look at this for anything
> obvious, but it is likely to require DTP specialization by some one (or
> group) that knows this server well.
> -- John Graham
> Eclipse Data Tools Platform PMC Chair
>
Re: MSSQL Connectivity [message #29201 is a reply to message #28206] Tue, 10 April 2007 22:12 Go to previous message
Eclipse UserFriend
Originally posted by: unineurone.gmail.com

What drivers are you using ?

I have the same issue (nothing under any schema, even when logged as "sa")
using jtds1.2 + 3.3M6/Europa

Note that I do see the schemas when using the quantumdb plugin.
Re: MSSQL Connectivity [message #583337 is a reply to message #23517] Mon, 04 December 2006 17:20 Go to previous message
John Graham is currently offline John GrahamFriend
Messages: 183
Registered: July 2009
Senior Member
Karim Fateem wrote:

> Hi,

> I'm trying to use the MSSQL support in DTP 1.0 RC 0.
> Does anyone know if MSSQL DSE tree-viewer support is fully implemented?
> Nothing appears below "schemas" in the tree-viewer.

> Has anyone had more luck?

> Really appreciate your help,
> Karim

Hi Karim,

I was able to get a DSE tree for MySQL 5.0 using the latest (12/1) DTP
build. The following link from our Wiki might help too:

http://wiki.eclipse.org/index.php/Connecting_to_MySQL_4.x_an d_5.x

I suspect that MySQL is not fully supported (in the sense that the tree
shows all the expected db objects and properties), but perhaps it is
enough for basic SQL query building and testing using our editor. In
general, DTP provides this base support for a number of data sources, and
looks to the community to flesh out the offering through our Enablement
project.

Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
Re: MSSQL Connectivity [message #583349 is a reply to message #23901] Tue, 05 December 2006 21:34 Go to previous message
Karim Fateem is currently offline Karim FateemFriend
Messages: 6
Registered: July 2009
Junior Member
Hi John - Looking for MS SQL Server 2000/2005 support.

Thank you for your help,
Karim
Re: MSSQL Connectivity [message #583365 is a reply to message #23901] Tue, 05 December 2006 21:46 Go to previous message
Karim Fateem is currently offline Karim FateemFriend
Messages: 6
Registered: July 2009
Junior Member
Hi John - Would there happen to be DSE support for MS SQL Server 2000 &
2005?

Thank you for your help,
Karim
Re: MSSQL Connectivity [message #584937 is a reply to message #23978] Mon, 26 March 2007 21:15 Go to previous message
Charles Doucette is currently offline Charles DoucetteFriend
Messages: 125
Registered: July 2009
Senior Member
I would also like to know the answer to this question.

I've installed DTP 1.5M5 on top of Eclipse 3.3M5eh (Europa).

I defined a connection profile to view the standard Northwind database. When
I connect to the database in the Data Source Explorer window, I don't see
any schema information.

Thanks,
Chuck

"Karim Fateem" <karim.fateem@hotmail.com> wrote in message
news:962b464fce76b71a7361c311fcd53487$1@www.eclipse.org...
> Hi John - Would there happen to be DSE support for MS SQL Server 2000 &
> 2005?
>
> Thank you for your help,
> Karim
>
>
Re: MSSQL Connectivity [message #585086 is a reply to message #28206] Fri, 06 April 2007 19:42 Go to previous message
John Graham is currently offline John GrahamFriend
Messages: 183
Registered: July 2009
Senior Member
Chuck Doucette wrote:

> I would also like to know the answer to this question.

> I've installed DTP 1.5M5 on top of Eclipse 3.3M5eh (Europa).

> I defined a connection profile to view the standard Northwind database. When
> I connect to the database in the Data Source Explorer window, I don't see
> any schema information.

> Thanks,
> Chuck

> "Karim Fateem" <karim.fateem@hotmail.com> wrote in message
> news:962b464fce76b71a7361c311fcd53487$1@www.eclipse.org...
>> Hi John - Would there happen to be DSE support for MS SQL Server 2000 &
>> 2005?
>>
>> Thank you for your help,
>> Karim
>>
>>

Chuck, Karim:

We do have a database definition for SQL Server, but apparently it is not
working with the later versions. We'll take a look at this for anything
obvious, but it is likely to require DTP specialization by some one (or
group) that knows this server well.

-- John Graham
Eclipse Data Tools Platform PMC Chair
Re: MSSQL Connectivity [message #585152 is a reply to message #28972] Tue, 10 April 2007 15:29 Go to previous message
Charles Doucette is currently offline Charles DoucetteFriend
Messages: 125
Registered: July 2009
Senior Member
But - I am using SQL 2000, not SQL 2005.

What versions of MS SQL Server do you support?

Chuck

"John Graham" <john.graham@sybase.com> wrote in message
news:8ba2915488891f75f591c14c8e61f34e$1@www.eclipse.org...
> Chuck Doucette wrote:
>
>> I would also like to know the answer to this question.
>
>> I've installed DTP 1.5M5 on top of Eclipse 3.3M5eh (Europa).
>
>> I defined a connection profile to view the standard Northwind database.
>> When I connect to the database in the Data Source Explorer window, I
>> don't see any schema information.
>
>> Thanks,
>> Chuck
>
>> "Karim Fateem" <karim.fateem@hotmail.com> wrote in message
>> news:962b464fce76b71a7361c311fcd53487$1@www.eclipse.org...
>>> Hi John - Would there happen to be DSE support for MS SQL Server 2000 &
>>> 2005?
>>>
>>> Thank you for your help,
>>> Karim
>>>
>>>
>
> Chuck, Karim:
>
> We do have a database definition for SQL Server, but apparently it is not
> working with the later versions. We'll take a look at this for anything
> obvious, but it is likely to require DTP specialization by some one (or
> group) that knows this server well.
> -- John Graham
> Eclipse Data Tools Platform PMC Chair
>
Re: MSSQL Connectivity [message #585164 is a reply to message #28206] Tue, 10 April 2007 22:12 Go to previous message
Olivier is currently offline OlivierFriend
Messages: 24
Registered: July 2009
Junior Member
What drivers are you using ?

I have the same issue (nothing under any schema, even when logged as "sa")
using jtds1.2 + 3.3M6/Europa

Note that I do see the schemas when using the quantumdb plugin.
Previous Topic:ODA driver for EJB access
Next Topic:ODA driver for EJB access
Goto Forum:
  


Current Time: Thu Jan 02 13:18:59 GMT 2025

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

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

Back to the top