Am using an SQL task to get a recordset returned then putting the output into a global variable. Passing it to a message Queue task where it places the global quite happily into a public message Queue.
I then run a VB app that can read the Queue. The vb app then bombs and states that the body of the message is not a recordset.
It is not the program b/c I have written another VB app that takes a recordset and places it into the Queue and the recieveing app then works perfectly.
Has anyone dabled into this area of SQL?
It has got me stumped for almost 2 weeks. Have bought books and played on the web non stop.
I believe that the real issue is actually the global variable and the data that it is storing
I then run a VB app that can read the Queue. The vb app then bombs and states that the body of the message is not a recordset.
It is not the program b/c I have written another VB app that takes a recordset and places it into the Queue and the recieveing app then works perfectly.
Has anyone dabled into this area of SQL?
It has got me stumped for almost 2 weeks. Have bought books and played on the web non stop.
I believe that the real issue is actually the global variable and the data that it is storing
