| Microsoft Sql Server Connection [message #10616] |
Thu, 13 April 2006 11:53  |
Eclipse User |
|
|
|
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  |
| Eclipse User |
|
|
|
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 |
 Brian Fitzpatrick
Messages: 500
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.
>
|
|
|
Powered by
FUDForum. Page generated in 0.03202 seconds
] 
Search
Help
Register
Login
Home
