Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » connection with sql server 2000 using DTP(sql server 2000 using DTP)
connection with sql server 2000 using DTP [message #546655] Tue, 13 July 2010 12:35 Go to next message
karthik  is currently offline karthik
Messages: 2
Registered: July 2010
Junior Member
Hai,

Please give me step by step procedure to connect the sql server 2000 using DTP. I tried to connect but i ended with connection error.

Thanks in Advance
Smile karthik
Re: connection with sql server 2000 using DTP [message #546715 is a reply to message #546655] Tue, 13 July 2010 18:11 Go to previous message
Brian Fitzpatrick is currently offline Brian Fitzpatrick
Messages: 495
Registered: July 2009
Senior Member
Karthik...

I'm guessing you don't have the JDBC driver installed in DTP, but that's
kind of the first step.

First, figure out what database type you're going against and download
the correct JDBC driver for it.

Second, in Eclipse, open the Preferences dialog (Window->Preferences).
Drill down to Data Management->Connectivity->Driver Definitions.

Third, click Add. In the Vendor Filter drop-down, select "SQL Server".
In the list below, look for Microsoft SQL Server 2000 Driver for JDBC.
Select it.

Click on the Jar List tab. You should see three jars listed -
msbase.jar, mssqlserver.jar, msutil.jar. Select one, click Edit
JAR/Zip... In the file dialog, find the jdbc driver jar in your file
system. Click OK. You should see a message pop up asking if you want to
update all jars to use the same path. Click Yes.

If all is well and good here, you should be able to click OK on the New
Driver Definition dialog. Click OK on the Preferences dialog to close
that as well.

Now open the Database Development perspective (Window->Open
Perspective->Other) or open the Data Source Explorer view (Window->Open
View->Other - search for Data Source Explorer).

At the top is a toolbar. Mouse over each button until you find the one
that's labeled "New Connection Profile." Find SQL Server in the list and
click Next. Select the driver you created in the preferences here (if
it's not already selected) and provide the data it asks for. Click Finish.

Try to connect to your database. If it doesn't work, there's something
wrong with the connection information you provided.

Hope that helps
--Fitz

karthik wrote:
> Hai,
>
> Please give me step by step procedure to connect the sql server
> 2000 using DTP. I tried to connect but i ended with connection error.
>
> Thanks in Advance
> :) karthik
Re: connection with sql server 2000 using DTP [message #597631 is a reply to message #546655] Tue, 13 July 2010 18:11 Go to previous message
Brian Fitzpatrick is currently offline Brian Fitzpatrick
Messages: 495
Registered: July 2009
Senior Member
Karthik...

I'm guessing you don't have the JDBC driver installed in DTP, but that's
kind of the first step.

First, figure out what database type you're going against and download
the correct JDBC driver for it.

Second, in Eclipse, open the Preferences dialog (Window->Preferences).
Drill down to Data Management->Connectivity->Driver Definitions.

Third, click Add. In the Vendor Filter drop-down, select "SQL Server".
In the list below, look for Microsoft SQL Server 2000 Driver for JDBC.
Select it.

Click on the Jar List tab. You should see three jars listed -
msbase.jar, mssqlserver.jar, msutil.jar. Select one, click Edit
JAR/Zip... In the file dialog, find the jdbc driver jar in your file
system. Click OK. You should see a message pop up asking if you want to
update all jars to use the same path. Click Yes.

If all is well and good here, you should be able to click OK on the New
Driver Definition dialog. Click OK on the Preferences dialog to close
that as well.

Now open the Database Development perspective (Window->Open
Perspective->Other) or open the Data Source Explorer view (Window->Open
View->Other - search for Data Source Explorer).

At the top is a toolbar. Mouse over each button until you find the one
that's labeled "New Connection Profile." Find SQL Server in the list and
click Next. Select the driver you created in the preferences here (if
it's not already selected) and provide the data it asks for. Click Finish.

Try to connect to your database. If it doesn't work, there's something
wrong with the connection information you provided.

Hope that helps
--Fitz

karthik wrote:
> Hai,
>
> Please give me step by step procedure to connect the sql server
> 2000 using DTP. I tried to connect but i ended with connection error.
>
> Thanks in Advance
> :) karthik
Previous Topic:creating an IConnectionProfile using ConnectionProfileFactory.createConnection
Next Topic:how do i "sell" DTP to my company?
Goto Forum:
  


Current Time: Thu Jul 31 05:34:04 EDT 2014

Powered by FUDForum. Page generated in 0.02894 seconds