+ 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,494
    Thank Post
    1,452
    Thanked 1,197 Times in 812 Posts
    Rep Power
    711

    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,653
    Thank Post
    1,257
    Thanked 781 Times in 678 Posts
    Rep Power
    236
    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,494
    Thank Post
    1,452
    Thanked 1,197 Times in 812 Posts
    Rep Power
    711
    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,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    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,494
    Thank Post
    1,452
    Thanked 1,197 Times in 812 Posts
    Rep Power
    711
    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
    249
    Thank Post
    23
    Thanked 37 Times in 28 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
  •