- This topic has 4 replies, 1 voice, and was last updated 5 years, 4 months ago by
.
-
Posts
-
-
Hello,
Each time i ‘m trying to create a SQL Adpater with Biztalk 2004 in order to call a stored procedure, at the end (just after generate script) of the wizard i got the message when i click on last next button :
\”Failed To execute SQL Statement. Please ensure that the supllied syntax is correct. Impossible to generate the library of types c:\\program files\\Micro….2004\\Microsoft.Biztalk.SQLAdmin, Version=3.0.1.0, culture=neutral, Public KeyToken=…\”\”
arghh !! help me please, i gonna be mad !! 😯
Fab
-
Fab,
I would check a couple of things.1 – Make sure that the adapter is installed correctly. Have you tried a very simple example with the adapter just to verify it works?
2 – make sure you have the pre-req’s installed. SQLXML 3.0 would be the key one.
3 – What does your stored proc look like? Have you verified you are not maybe returning an unsupported type, etc? Does the stored proc work outside of the adpater?
Todd
-
Did you find out the solution of your problem. Please share it with us, if you found it. I am having the same problem.
Thanx in advance.
-
Hi, i got the same problem and solved this way:
when u select the store procedure to use inside bts ( in combo box ), it%u00b4s put down all the parameters in a grid.
Fill those parameters with some value according to the db type of the parameter.
then, push \” generate button \”.
i hope this helps !!
see ya
-
-
-
Empire of Lies | Raymond Khoury | 9781250210968
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.