Updating a MS SQL Server database

[Former Member]

Hi

Can any one help me in sening the data from my WD application into MS SQL Server database.Is it the same way as we do for Oracle, or any other driver classes and connection types have to be used?

Will be greatful for your replies.

Thnaks & Regards

Sharan

[Former Member · Accepted solution]

Hi,

From the coding point of view, yes its the same. For connecting to MS SQL Server you need to have MSSQL Driver.

Following is the path where its available.

http://www.microsoft.com/downloads/details.aspx?familyid=4f8f2f01-1ed7-4c4d-8f7b-3d47969e66ae&displa...

Regards

Ayyapparaj

[ankur_garg5]

Hi Sharan,

Have a look at my article:

[How to Create a Web Service using an Enterprise JavaBean Which Accesses the MS SQL Server|https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/uuid/b00917dc-ead4-2910-3ebb-b0a63e49ef10]

The necessary steps which you need to do are:

1) Configure the MS SQL Server Enterprise Manager (Page 4-7)

2) Create a Data Source in Visual Administrator (Page 8-12)

3) Connect to the Data Source created in VA using Java coding (Page 19)

Hope it solves your problem.

Bye

Ankur

[former_member182374]

Hi,

Look at this thread:

/thread/422379 [original link is broken]

Regards,

Omri