MIS Systems Thread, SIMS Commad Reporter and multiple connections? in Technical; Hi all,
Does anybody know how to tell the CommandReporter which database to connect to when there are multiple entries ...
25th March 2010, 05:06 PM #1
SIMS Commad Reporter and multiple connections?
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)!
25th March 2010, 05:17 PM #2
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?
Originally Posted by JoshJohnson
Thanks to dhicks from:
LosOjos (25th March 2010)
25th March 2010, 05:19 PM #3
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.
Originally Posted by dhicks
Last edited by LosOjos; 25th March 2010 at 05:40 PM.
25th March 2010, 09:10 PM #4
What are you thinking of doing, it'll determine how you do it. PM me if you want.
26th March 2010, 11:03 AM #5
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.
Originally Posted by matt40k
26th March 2010, 06:34 PM #6
How about having a directory for each client setup? It's likely that commandreporter will use connect.ini from the current directory.
By RuAware in forum MIS Systems
Last Post: 25th February 2011, 07:57 PM
By dhicks in forum Internet Related/Filtering/Firewall
Last Post: 17th February 2010, 08:38 PM
By neilmc in forum Windows Server 2000/2003
Last Post: 19th January 2010, 11:41 AM
By gshaw in forum Internet Related/Filtering/Firewall
Last Post: 17th September 2009, 10:16 PM
By russdev in forum MIS Systems
Last Post: 20th September 2007, 03:00 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread