Skip to Content
0
Oct 11, 2006 at 12:24 PM

Cant save in SQL SERVER.

14 Views

Hi all.

i have a BMP that save data in a SQL Server Table from a XML document.

the BMP finish perfect but when i check in SQL there no any data.

I am using the next estructure:

<?xml version="1.0" encoding="UTF-8"?>

<sp_jdbc_MT>

<dbTableName action="INSERT">

<table>TEST</table>

<access>

<SALUDO>HI</SALUDO>

<NOMBRE>JAMES</NOMBRE>

</access>

</dbTableName>

</sp_jdbc_MT>

my JDBC Comunication channel has the next configuration:

JDBC DRIVER: com.microsoft.jdbc.sqlserver.SQLServerDriver

CONNECTION:jdbc:microsoft:sqlserver://srv-cap01-adm:1433;DatabaseName=TEST

any idea??

Thanks & Regards

Rodrigo