Hi all

This forum seems to be a nice spot for tech talk.I was trying to use SQL adapter with Biztalk Server 2004 for the first time and encountered a problem.

My SQL Stored Proc accepts two parameters(DataType: uniqueidentifier).When I deployed the solution and tried to test, i got the below error:

The adapter "SQL" raised an error message. Details "HRESULT="0x80040e07" Description="Error converting data type nvarchar to uniqueidentifier."
".

I tried changing the datatype for the SP parameters to NVARCHAR but still got the below similar error:

The adapter "SQL" raised an error message. Details "HRESULT="0x80040e14" Description="Syntax error converting from a character string to uniqueidentifier."
".

Any help would be really appreciated.

Thanks
Vivek Khurana
Email: [email protected]

Hi there,
This a simple type conversion error.Just check this things
1.The datatype in the stored procedure and the field in the table is same(nvarchar).
2.The value you are passing to the stored procedure form the Biztalk in case of a send port is same(nvarchar).
3.If you are using generated schema, you have to regenerate the same after making changes.

Try this things and get back if anything else get u in trouble

Regards,
Vishal Dube
[email protected]

VISHAL DUBE