Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Newcomers » Newcomers » Creating Connection Profile for SQL Server 2008(How to configure a connection profile for SQL Server 2008)
Creating Connection Profile for SQL Server 2008 [message #665277] Thu, 14 April 2011 04:19 Go to next message
MickeyBob  is currently offline MickeyBob
Messages: 4
Registered: April 2011
Junior Member
Please excuse me if this has been asked and answered but I'm an extreme noob and can't find a direct answer via Google.

I want to set up a connection profile to a SQL Server 2008 database using Eclipse JEE Europa. I have done this with MySQL so I'm somewhat familiar with the process.

I select File>New>Other from the menus, expand Connection Profiles, and select Connection Profile. I then click Next, select Generic JDBC Connection and click Next again. I type in a name for the connection profile (e.g., localhost.DBName) and click Next. I then click on the ellipses button to display the Available Driver Definitions dialog. In the tree on the left, I see nodes for SQL Server 2000 and 2005 but not for 2008.

Now that I've set the background, here are my questions:

1) Can one add a new node to Available Driver Definitions tree?
2) If so, how?
3) If not, can I use the 2005 JDBC driver with SQL Server 2008?
4) If not, can I use the 2008 JDBC driver under the SQL Server>2005 node? (I've downloaded and installed the latest MS JDBC driver for SQL Server 2008.)

I know these questions might be simplistic or naive but I'm just starting out and can really use the help.

Re: Creating Connection Profile for SQL Server 2008 [message #665379 is a reply to message #665277] Thu, 14 April 2011 13:42 Go to previous messageGo to next message
Russell Bateman is currently offline Russell Bateman
Messages: 3221
Registered: July 2009
Location: Provo, Utah, USA
Senior Member

On 13-Apr-11 22:20, MickeyBob wrote:
> Please excuse me if this has been asked and answered but I'm an extreme
> noob and can't find a direct answer via Google.
>
> I want to set up a connection profile to a SQL Server 2008 database
> using Eclipse JEE Europa. I have done this with MySQL so I'm somewhat
> familiar with the process.
>
> I select File>New>Other from the menus, expand Connection Profiles, and
> select Connection Profile. I then click Next, select Generic JDBC
> Connection and click Next again. I type in a name for the connection
> profile (e.g., localhost.DBName) and click Next. I then click on the
> ellipses button to display the Available Driver Definitions dialog. In
> the tree on the left, I see nodes for SQL Server 2000 and 2005 but not
> for 2008.
>
> Now that I've set the background, here are my questions:
>
> 1) Can one add a new node to Available Driver Definitions tree?
> 2) If so, how?
> 3) If not, can I use the 2005 JDBC driver with SQL Server 2008?
> 4) If not, can I use the 2008 JDBC driver under the SQL Server>2005
> node? (I've downloaded and installed the latest MS JDBC driver for SQL
> Server 2008.)
>
> I know these questions might be simplistic or naive but I'm just
> starting out and can really use the help.

I can tell you that you're doing the right thing in terms of how to
install the MS SQL JDBC driver.

Far be it from me to tell you that you can't use Europa any more. I used
it until a couple of years ago, but there have been 3 other solid
releases of Eclipse since then and we're on the cusp of yet a fourth.
The point is, I can't remember the exact steps and surrounding
complications of JDBC driver definition in Europa and I don't have a
copy any more to try it out on. The upshot of what I'm saying is that if
you upgrade to Helios, which is a very stable and well behaved version
of Eclipse, you're likely to get better and quicker answers.

There is at least a chance that this problem will go away with an
installation of Galileo or Helios. To try (just that much) would
probably only cost you half an hour while you're waiting for the right
person to come along.

Cheers
Re: Creating Connection Profile for SQL Server 2008 [message #666455 is a reply to message #665379] Wed, 20 April 2011 13:53 Go to previous messageGo to next message
MickeyBob  is currently offline MickeyBob
Messages: 4
Registered: April 2011
Junior Member
Thanks for the response.

I'm so new to Eclipse that I am not up to speed on all the versions. I thought I had downloaded the latest and greatest but apparently not.

I'll gladly move up to Helios since it appears to be the latest. Hopefully, it'll work better for me.
Re: Creating Connection Profile for SQL Server 2008 [message #666482 is a reply to message #666455] Wed, 20 April 2011 14:43 Go to previous messageGo to next message
Russell Bateman is currently offline Russell Bateman
Messages: 3221
Registered: July 2009
Location: Provo, Utah, USA
Senior Member

On 20-Apr-11 07:53, MickeyBob wrote:
> Thanks for the response.
>
> I'm so new to Eclipse that I am not up to speed on all the versions. I
> thought I had downloaded the latest and greatest but apparently not.
> I'll gladly move up to Helios since it appears to be the latest.
> Hopefully, it'll work better for me.

http://www.javahotchocolate.com/tutorials/eclipse-summary.ht ml might
help guide you if you're bewildered.
Re: Creating Connection Profile for SQL Server 2008 [message #666556 is a reply to message #665379] Wed, 20 April 2011 23:31 Go to previous message
MickeyBob  is currently offline MickeyBob
Messages: 4
Registered: April 2011
Junior Member
I've updated Eclipse to Helios SR2 and the MS SQL Server JDBC driver to version 4.0 CTP but I'm still having trouble getting the SQL Server hierarchy to show correctly. I'm thinking at this point that my issue is likely an incompatibility with SQL Server 2008 and DTP. I've posted a new topic in the DTP forum to see what comes of that. However, I really appreciate your response.

Best Regards.
Previous Topic:Structure Intent is undefined
Next Topic:Eclipse in Italian?
Goto Forum:
  


Current Time: Thu Oct 23 04:08:44 GMT 2014

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

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