Probs with SQL used in Rules Engine when called from Orchestration
Web Server forum
Back To The Forum Home!Search!Private Messaging System

Web Server Talk Web Server Talk > Web Servers reviews > BizTalk Server > BizTalk Server Orchestration > Probs with SQL used in Rules Engine when called from Orchestration




  Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

racs is offline     Probs with SQL used in Rules Engine when called from Orchestration  
racs


View Ip Address Report This Message To A Moderator Edit/Delete Message


Click Here to See the Profile for racs Click here to Send racs a Private Message Find more posts by racs Add racs to your buddy list
 
08-16-04 10:55 PM

Hi, I have the following problem:

I created a small Orchestration where a XML-File comes in and is sent then t
o the Rules Engine using the CallRules shape.

The rule decides on two parameters, one is in the XML-File, the other should
 be looked up in a SQL-Database, so the rule looks like:

IF  "XML-Price" is bigger than "SQL-Price" then do "Action"

When I test the Rule with the build-in Test-Engine, all works fine.

But if I let the Orchestration run, the rule is not executed. 

For the XML part a Vocabulary is created, which works.

But neither a vocabulary for the SQL part nor the direct binding in the rule
s enginge composer (referring to the Database) work in this form of statemen
t.

I tried a lot around and all works, if no DataBase-statement is involved.

So, for example: If XML-Price is bigger than 5 works fine.

My guess is, that as in the test tool of the Rules Composer I have to specif
y an instance of the Database, an instance has to be passed as a parameter i
n the CallRules Shape ??? But I have no clue how to manage this...

So, if anyone could help me, this woul be really fine..




[ Post a follow-up to this message ]



brunchey is offline     Check out the online documentation  
brunchey


View Ip Address Report This Message To A Moderator Edit/Delete Message


Click Here to See the Profile for brunchey Click here to Send brunchey a Private Message Find more posts by brunchey Add brunchey to your buddy list
 
10-19-04 02:42 AM

You need to declare a variable of SqlConnection and DataConnection.  

Please see this link...

http://msdn.microsoft.com/library/d..._rules_huft.asp




[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 09:11 AM.      Post New Thread    Post A Reply      
  Last Thread   Next Thread Next


Most Popular forums 

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register