Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Microsoft Sql Server Connection
Microsoft Sql Server Connection [message #10616] Thu, 13 April 2006 11:53 Go to next message
Eclipse UserFriend
Originally posted by: franceschiello1979.libero.it

Hi all,
I am having problem to connect a Microsoft SQL Server Database with
eclipse. Is it possible to do it? And could someone explain me how,
please? When I want to create a connection from the data source explorer,
I have in the list of connection only derby and jdbc. Is anything else
that I have to download?
Thank you in advance for your help.
Re: Microsoft Sql Server Connection [message #10650 is a reply to message #10616] Thu, 13 April 2006 21:38 Go to previous message
Eclipse UserFriend
Originally posted by: brianf.sybase.com

Hi Francesco...

You would need to create a Generic JDBC driver and then use the SQL
Model-JDBC Connection to create a profile for MSSQL...

Follow these steps:
1. In the Preferences (Window->Preferences), go to the Driver Definitions
preference page (Connectivity/Driver Definitions).
2. Select the Database node in the tree and click Add.
3. Choose the Generic JDBC Driver, but name it something different like
"MSSQL JDBC Driver" and click OK.
4. On the Edit Driver Entry page, add the jar files to the Driver File(s)
list (Add Jar/Zip and browse for each). For MSSQL 2K, this includes
msbase.jar, mssqlserver.jar, and msutil.jar I believe.
5. In the Connection URL property, make it something generic like:
jdbc:microsoft:sqlserver://MyServer:1433
6. The driver class (at least for MS SQL 2K) is
com.microsoft.jdbc.sqlserver.SQLServerDriver.
7. Click OK. You should see your new driver entry in the list.
8. Click OK to close the preferences dialog.
9. In the Data Source Explorer, right-click on the Databases node and select
New... to bring up the New Connection Profile wizard.
10. Select SQL Model-JDBC Connection. Click Next.
11. Give the profile a name.
12. Choose your MSSQL driver entry and modify the URL, user name, and
password to fit your database instance. Test the connection to verify that
everything is ok.
13. Click Finish.
14. Right-click on your new profile and click Connect... You should see the
contents of the SQL model for the connection and be able to drill in.

A few things to note... Since this is a generic JDBC profile, it may not get
any SQL Server-specific things. Someone may need to customize the DB and SQL
models for SQL Server to pick up any unique items that might be there.

But hopefully that'll get you going anyway.

--Brian Fitzpatrick
Sybase, Inc./DTP-Connectivity Committer
brianf@sybase.com

"Francesco" <franceschiello1979@libero.it> wrote in message
news:c14dd3029d577b25a2f63c7c8a6b8d99$1@www.eclipse.org...
> Hi all,
> I am having problem to connect a Microsoft SQL Server Database with
> eclipse. Is it possible to do it? And could someone explain me how,
> please? When I want to create a connection from the data source explorer,
> I have in the list of connection only derby and jdbc. Is anything else
> that I have to download?
> Thank you in advance for your help.
>
Re: Microsoft Sql Server Connection [message #572381 is a reply to message #10616] Thu, 13 April 2006 21:38 Go to previous message
Brian Fitzpatrick is currently offline Brian FitzpatrickFriend
Messages: 495
Registered: July 2009
Senior Member
Hi Francesco...

You would need to create a Generic JDBC driver and then use the SQL
Model-JDBC Connection to create a profile for MSSQL...

Follow these steps:
1. In the Preferences (Window->Preferences), go to the Driver Definitions
preference page (Connectivity/Driver Definitions).
2. Select the Database node in the tree and click Add.
3. Choose the Generic JDBC Driver, but name it something different like
"MSSQL JDBC Driver" and click OK.
4. On the Edit Driver Entry page, add the jar files to the Driver File(s)
list (Add Jar/Zip and browse for each). For MSSQL 2K, this includes
msbase.jar, mssqlserver.jar, and msutil.jar I believe.
5. In the Connection URL property, make it something generic like:
jdbc:microsoft:sqlserver://MyServer:1433
6. The driver class (at least for MS SQL 2K) is
com.microsoft.jdbc.sqlserver.SQLServerDriver.
7. Click OK. You should see your new driver entry in the list.
8. Click OK to close the preferences dialog.
9. In the Data Source Explorer, right-click on the Databases node and select
New... to bring up the New Connection Profile wizard.
10. Select SQL Model-JDBC Connection. Click Next.
11. Give the profile a name.
12. Choose your MSSQL driver entry and modify the URL, user name, and
password to fit your database instance. Test the connection to verify that
everything is ok.
13. Click Finish.
14. Right-click on your new profile and click Connect... You should see the
contents of the SQL model for the connection and be able to drill in.

A few things to note... Since this is a generic JDBC profile, it may not get
any SQL Server-specific things. Someone may need to customize the DB and SQL
models for SQL Server to pick up any unique items that might be there.

But hopefully that'll get you going anyway.

--Brian Fitzpatrick
Sybase, Inc./DTP-Connectivity Committer
brianf@sybase.com

"Francesco" <franceschiello1979@libero.it> wrote in message
news:c14dd3029d577b25a2f63c7c8a6b8d99$1@www.eclipse.org...
> Hi all,
> I am having problem to connect a Microsoft SQL Server Database with
> eclipse. Is it possible to do it? And could someone explain me how,
> please? When I want to create a connection from the data source explorer,
> I have in the list of connection only derby and jdbc. Is anything else
> that I have to download?
> Thank you in advance for your help.
>
Previous Topic:Microsoft Sql Server Connection
Next Topic:What's new page?
Goto Forum:
  


Current Time: Sun Dec 21 02:52:11 GMT 2014

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

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