SIMS Commad Reporter and multiple connections?

[LosOjos]

Hi all,

 

Does anybody know how to tell the CommandReporter which database to connect to when there are multiple entries in the connect.ini?

 

Tried prefixing the username with the database name as the error returned is along the lines of "login failed for [DB_NAME]_[uSERNAME]" but it seems it's not that simple.

 

Any help will be appreciated (and thanked)!

 

Josh

[dhicks]

Does anybody know how to tell the CommandReporter which database to connect to when there are multiple entries in the connect.ini?

 

Could you run CommandReporter from a script / batch file that rewrites connect.ini before running CommandReporter so that it connects to the server you want?

 

--

David Hicks

[LosOjos]

Could you run CommandReporter from a script / batch file that rewrites connect.ini before running CommandReporter so that it connects to the server you want?

 

--

David Hicks

 

Yeah that's the only way I can see at the moment, I was hoping there would be some undocumented argument like "/DB:[DB_NAME]" or something to make life easier, if not that's what I'm going to have to do I think.

Edited March 25, 2010 by LosOjos

[matt40k]

What are you thinking of doing, it'll determine how you do it. PM me if you want.

[LosOjos]

What are you thinking of doing, it'll determine how you do it. PM me if you want.

 

I have a couple of reporting systems in place that rely on commandreporter to gather information, but now that we have two connections, it's automatically defaulting to the wrong connection so the reports don't run.

[MattMitchell]

How about having a directory for each client setup? It's likely that commandreporter will use connect.ini from the current directory.