+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 24
MIS Systems Thread, SIMS.net and multiple connect.ini files in Technical; Hi All We are in the process of setting up an additional SIMS.net database for another part of the school. ...
  1. #1

    Join Date
    Jun 2007
    Location
    Taunton, Somerset, UK
    Posts
    29
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    SIMS.net and multiple connect.ini files

    Hi All

    We are in the process of setting up an additional SIMS.net database for another part of the school.

    We have in the past modified the connect.ini file to show a drop down list of all the different SIMS.net databases.

    Does anyone know if it possible to reference the database or a different connect.ini file within a shortcut?

    I would like to have 2 shortcuts, one for our main school database and a second for the additional one.

    Thanks

    Tom

  2. #2

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,115
    Thank Post
    380
    Thanked 389 Times in 314 Posts
    Blog Entries
    8
    Rep Power
    180
    We tried this about a year ago and couldn't get it working very well. Because the software only looks in one place for the connect.ini (assuming using a redirected one) we couldn't get anything special to alter the location it was pointing to, so became a manual job.

  3. #3
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42
    Maybe you could use bat files to run SIMS i.e. you have 1 that copies the main connect.ini file to the sims local directory and then runs sims, another that copies the other connect.ini file to the sims local directory and then runs sims. Basically the batch script does what you would have done manually.

  4. #4

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,115
    Thank Post
    380
    Thanked 389 Times in 314 Posts
    Blog Entries
    8
    Rep Power
    180
    We did go down that road, and not until some recent work did we figure out the big pitcure, but security was a big issue for us at that time. Having 2 databases is now not an issue for us so we have not persued it any further. However, we know that that would do the trick because we use a similar batch to enable auto upgrades of SIMS.

  5. #5
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    967
    Thank Post
    37
    Thanked 173 Times in 138 Posts
    Rep Power
    96
    This works for me

    Change the name to the correct name of the server you want to connect to.


    [SIMSConnection]
    ServerName=name1\sims2005
    DatabaseName=sims
    ServerType=SIMSSQL
    DatabaseMode=OnLine

    [SIMSDatabases]
    FriendlyName0=name1
    Server0=name1\sims2005
    DatabaseName0=sims
    DatabaseMode0=Online

    FriendlyName1=name2
    Server1=name2\sims2008
    DatabaseName1=sims_sec
    DatabaseMode1=Online


    FriendlyName2=name3
    Server2=name3\sims2005
    DatabaseName2=sims_training
    DatabaseMode2=Online

    FriendlyName3=name4
    Server3=name4\sims2008
    DatabaseName3=sims
    DatabaseMode3=Online

  6. 6 Thanks to Mcshammer_dj:

    GREED (30th November 2009), LosOjos (25th March 2010), Oops_my_bad (5th September 2011), stratisphere (11th January 2010), tech_guy (5th September 2011), vikpaw (1st December 2009)

  7. #6

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,115
    Thank Post
    380
    Thanked 389 Times in 314 Posts
    Blog Entries
    8
    Rep Power
    180
    And so you get... what? A drop down of SIMS servers/installations to choose from on login?

    Brilliant!

  8. #7
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    967
    Thank Post
    37
    Thanked 173 Times in 138 Posts
    Rep Power
    96
    Quote Originally Posted by GREED View Post
    And so you get... what? A drop down of SIMS servers/installations to choose from on login?

    Brilliant!
    Thought that you would like that.....

    This works within a large domain as well to connect to different machines. The only problem can come with the versions of SIMS

  9. #8
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    444
    Thank Post
    153
    Thanked 77 Times in 61 Posts
    Rep Power
    32
    One more vote for the connect.ini with the friendly database names in. It has one other problem which is people not knowing which sims database they need to run.

    As long as that is clear then any workstation with SIMS .net (at the right version) should be capable of connecting to any SIMS database.


    The other option is creating separate connect.ini files on a network share for the local one to redirect to. Nowhere near as neat or nice.

  10. #9

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,115
    Thank Post
    380
    Thanked 389 Times in 314 Posts
    Blog Entries
    8
    Rep Power
    180
    I guess you could include some form of pop up (batch) to indicate clearly which database you were about to open, with some friendly text, make it as obvious as possible!

  11. #10

    Join Date
    Apr 2008
    Location
    Stoke on Trent
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    hi,

    is there any way to redirect to this type of file, for example if i copy the contents and modify it to my c:\program....\connect.ini file it works ok. however if i copy this connect.ini file to the s:\sims folder and create a c:\program....\connect.ini file to redirect to s:\sims, the drop down list fails and i can only login to the first DB listed!!! i have a requirement for a terminal server so i cannot rewrite files on the c:\ drive and the drop down list seems to have an issue with more than 10-12 entries.

    Thanks,
    Gav

  12. #11
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    967
    Thank Post
    37
    Thanked 173 Times in 138 Posts
    Rep Power
    96
    I haven't tested this on more that 10 but I don't think that there is a number limit on the connect.ini.
    HOwever I am not sure that it will really work in a terminal solution as it will write back the current database as it is used and muliple use will result in exsessive access to the connect.ini.

  13. #12

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,450
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    You can just add /CONNECT: with the path to a connect.ini.

  14. #13

    Join Date
    Feb 2006
    Location
    South Cumbria
    Posts
    199
    Thank Post
    26
    Thanked 29 Times in 24 Posts
    Rep Power
    22

    multiple SIMS

    I do it by redirecting the connect.ini to the connect.ini on the server. Different shortcuts run batch files which map the SIMS drive (S for us) to the required server and I also incorporate a message in the bat file to remind the user which database they ar econnecting to

  15. #14
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30
    Thanks for that.

    I've just tried modifying my connect.ini file with this however I'm not getting the drop-down box to select another database.

    Take it this doesn't work anymore with the current version of SIMS?

  16. #15

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,450
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    It most certain does still work.

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. [SIMS] SIMS.net and Acrobat Pro
    By NortyUK in forum MIS Systems
    Replies: 4
    Last Post: 27th August 2011, 12:10 PM
  2. [SIMS] Nova T4? All functions now in SIMS.net and T6?
    By localzuk in forum MIS Systems
    Replies: 9
    Last Post: 9th June 2011, 10:07 AM
  3. [SIMS] SIMS .net and FMSSQL Autumn 2010 released!
    By matt40k in forum MIS Systems
    Replies: 5
    Last Post: 24th November 2010, 10:14 PM
  4. SIMS.net and Citrix
    By NortyUK in forum MIS Systems
    Replies: 0
    Last Post: 22nd June 2007, 10:52 AM
  5. Sims.net and Outlook
    By SwedishChef in forum MIS Systems
    Replies: 0
    Last Post: 17th May 2007, 08:25 AM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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