+ 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,674
    Thank Post
    1,484
    Thanked 1,267 Times in 860 Posts
    Rep Power
    804

    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,733
    Thank Post
    1,294
    Thanked 797 Times in 693 Posts
    Rep Power
    239
    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,674
    Thank Post
    1,484
    Thanked 1,267 Times in 860 Posts
    Rep Power
    804
    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 05:40 PM.

  5. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,489
    Thank Post
    372
    Thanked 657 Times in 537 Posts
    Rep Power
    162
    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,674
    Thank Post
    1,484
    Thanked 1,267 Times in 860 Posts
    Rep Power
    804
    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
    274
    Thank Post
    27
    Thanked 39 Times in 29 Posts
    Rep Power
    22
    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, 07:57 PM
  2. Best use of multiple ADSL connections
    By dhicks in forum Internet Related/Filtering/Firewall
    Replies: 13
    Last Post: 17th February 2010, 08:38 PM
  3. Disconnect multiple connections
    By neilmc in forum Windows Server 2000/2003
    Replies: 1
    Last Post: 19th January 2010, 11:41 AM
  4. Webmail and multiple connections
    By gshaw in forum Internet Related/Filtering/Firewall
    Replies: 1
    Last Post: 17th September 2009, 10:16 PM
  5. urgent: Sims.net command line reporter (CLR)
    By russdev in forum MIS Systems
    Replies: 2
    Last Post: 20th September 2007, 03: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
  •