Multiple Salesforce Connections in one QV applicaiton

[#1]

I've got a UserID to multiple production Salesforce orgs and built a single QV app to query a specific table from each of these - they all have different CUSTOMCONNECT commands but the same LOAD and SQL statement.

But when I execute the app, I get an error when it tries to initiate the second connect. So, if I comment out the first connect the second works fine so I know there is no syntax error.

Is there a close connect command I need to write or a wait command etc before the second/third connect?

Thanks. Jay

[Anonymous]

There is DISCONNECT statement. Manual says it is optional, so it maybe won't help. Worth trying.
(In fact, I am using it in a similar situation, have to connect to different databases on different servers.)

[#3]

What error are you getting on second connect?

[#4]

Did you ever solve this Jay? I am having the same issue

I put DISCONNECT right at the end of the first block and then used the CUSTOM CONNECT command. This was the error I got:

Garbage after statement

DISCONNECT

CUSTOM CONNECT TO "Provider=SalesForceDLL.dll;T26;XUserId=FZFNd.......................................;"