|
Re: connection with sql server 2000 using DTP [message #546715 is a reply to message #546655] |
Tue, 13 July 2010 22:11 |
Brian Fitzpatrick Messages: 500 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 22:11 |
Brian Fitzpatrick Messages: 500 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
|
|
|
Powered by
FUDForum. Page generated in 0.03045 seconds