D Duncan H Williamson Member Licensed User Longtime User May 4, 2014 #1 Hi, I have an app that utilises the remote database connector to connect to a sql server database via wifi. I now have found I need to retrieve data from a seperate database on the sql server instance. I have installed two instances of RDC server using seperate ports and within the app have Dim reqManager As DBRequestManager Dim reqManager2 As DBRequestManager and created this sub for the second; Sub SETCONNUM Dim cmd As DBCommand cmd.Initialize cmd.Name = "updatefdm" reqManager2.ExecuteQuery(cmd, 0, "6") End Sub however I do not see how to configure jobdone can anyone help ? please... Regards Duncan
Hi, I have an app that utilises the remote database connector to connect to a sql server database via wifi. I now have found I need to retrieve data from a seperate database on the sql server instance. I have installed two instances of RDC server using seperate ports and within the app have Dim reqManager As DBRequestManager Dim reqManager2 As DBRequestManager and created this sub for the second; Sub SETCONNUM Dim cmd As DBCommand cmd.Initialize cmd.Name = "updatefdm" reqManager2.ExecuteQuery(cmd, 0, "6") End Sub however I do not see how to configure jobdone can anyone help ? please... Regards Duncan
D Duncan H Williamson Member Licensed User Longtime User May 4, 2014 #2 Answered my own question must have been having a real elderly moment....... dont need to run two instances of the connector.... I just need to select the database in my query because both databases are running in the same sql server instance !!! Regards Duncan Upvote 0
Answered my own question must have been having a real elderly moment....... dont need to run two instances of the connector.... I just need to select the database in my query because both databases are running in the same sql server instance !!! Regards Duncan