Download location for JDBC Driver for 2005 for Java Webdynpro application?

[Former Member]

Hi I want to download JDBC driver for SQL Server 2005 for develoiing java based WebDynpro application. Could you please suggest me where shall I serach to download?. I mean

Basically I am looking for the driver suitable to use the following code

Driver -> com.sap.portals.jdbc.sqlserver.SQLServerDriver

Conn URL ->dbc:sap:sqlserver://mysqlserver:1433;DatabaseName=Northwind

Please also send me the mail/url link if you know the location to download.I appreciate your help and wold award points for the answers.

Thank you

Regards

Maruthi

chandra-s@mailcity.com

[Former Member · Accepted solution]

Hi,

You can download the driver from

http://www.microsoft.com/downloads/details.aspx?familyid=e22bc83b-32ff-4474-a44a-22b6ae2c4e17&displa...

http://msdn2.microsoft.com/hi-in/data/aa937724(en-us).aspx

Create SQL server 2000 JDBC 2.0 driver in j2ee engine

install it on j2ee server.

• Open Visual administrator, /usr/sap/<instance name>/JC00/j2ee/admin/go.bat

• Navigate to server > services > JDBC connector > drivers in runtime tab

• Click create new driver and specify a name, eg “SQL Server”)

• Point to 3 .jar files which was installed by the MS jdbc driver before. The files are: msbase.jar, mssqlserver.jar and msutil.jar

• The driver installation is now completed

Create datasource

• Click DataSources in the same path as above (server > services > JDBC connector)

• Click “new driver or datasource”.

• Fillout the following properties:

o Main tab > DataSource Name: fx “MyDatasource”

o Main tab > Add Alias: fx “MyAlias”

o Main tab > Driver Name: SQL Server

o Main tab > JDBC version: 2.0 (with XA support)

o Main tab > Object factory: com.microsoft.jdbcx.sqlserver.SQLServerDataSourceFactory

o Main tab > DataSource Type: ConnectionPoolDataSource

o Main tab > CPDS classname: com.microsoft.jdbcx.sqlserver.SQLServerDataSource

o Additional tab > add property “serverName = <your server>, fx localhost”

o Additional tab > add property “databaseName = <your db>, fx Northwind”

o Additional tab > add property “portNumber = <port>, fx 1433”

o Additional tab > add property “user = <sql database user>, fx sa”

o Additional tab > add property “password = <password>”

• Save and restart J2EE. The datasource is now ready to use.

Regards

Ayyapparaj

[Former Member · Accepted solution]

Hi Ayyapparaj,

Thank you for the information. I already knew about the information/urls you passed to me. I have few limitations in my specification

1. I must not use Visula Composure/Visual Admin to create Data Soucres.

2. I have already developed a program which uses 'Microsoft SQL Server 2005 JDBC Driver 1.0' which retrives SQL data successfully . but I am having probleams to deploy the application to JDI/NWDI as a WebDynpro Component. The application is working as a stand alone application and not as a WebDynpro Component based application.

SAP has suggested Note 773401

So Any ideas..?

Thank you

Maruti