+ Post New Thread
Results 1 to 6 of 6
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 ...
  1. #1

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,447
    Thank Post
    1,438
    Thanked 1,168 Times in 797 Posts
    Rep Power
    707

    SIMS Commad Reporter and multiple connections?

    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

  2. #2

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,623
    Thank Post
    1,240
    Thanked 778 Times in 675 Posts
    Rep Power
    235
    Quote Originally Posted by JoshJohnson View Post
    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

  3. Thanks to dhicks from:

    LosOjos (25th March 2010)

  4. #3

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,447
    Thank Post
    1,438
    Thanked 1,168 Times in 797 Posts
    Rep Power
    707
    Quote Originally Posted by dhicks View Post
    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.
    Last edited by LosOjos; 25th March 2010 at 04:40 PM.

  5. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,392
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    What are you thinking of doing, it'll determine how you do it. PM me if you want.

  6. #5

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,447
    Thank Post
    1,438
    Thanked 1,168 Times in 797 Posts
    Rep Power
    707
    Quote Originally Posted by matt40k View Post
    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.

  7. #6

    Join Date
    May 2009
    Location
    Sheffield
    Posts
    244
    Thank Post
    23
    Thanked 36 Times in 27 Posts
    Rep Power
    20
    How about having a directory for each client setup? It's likely that commandreporter will use connect.ini from the current directory.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMs and Command Reporter
    By RuAware in forum MIS Systems
    Replies: 43
    Last Post: 25th February 2011, 06:57 PM
  2. Best use of multiple ADSL connections
    By dhicks in forum Internet Related/Filtering/Firewall
    Replies: 13
    Last Post: 17th February 2010, 07:38 PM
  3. Disconnect multiple connections
    By neilmc in forum Windows Server 2000/2003
    Replies: 1
    Last Post: 19th January 2010, 10:41 AM
  4. Webmail and multiple connections
    By gshaw in forum Internet Related/Filtering/Firewall
    Replies: 1
    Last Post: 17th September 2009, 09:16 PM
  5. urgent: Sims.net command line reporter (CLR)
    By russdev in forum MIS Systems
    Replies: 2
    Last Post: 20th September 2007, 02:00 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •