Announcement

Collapse
No announcement yet.

Export and Import ODBC settings

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Export and Import ODBC settings

    Hi all,

    how can i EXPORT an ODBC settings (system dsn) and then import them to my whole domain ? there are also win2k and winxp machines.
    i tried exporting the REG keys, but then it does not appear on System DSN.

    Thanks, Retaliator
    Thanks & Regards

    Retaliator

    MCSA/MCSE/CCNA
    Computer Science Graduate

  • #2
    Re: Export and Import ODBC settings

    I found out there is also that ODBC.INI file with some values that need to be added. is there a better way then adding the REG file to script and the line to ODBC.INI and also what with win2k ?
    Thanks & Regards

    Retaliator

    MCSA/MCSE/CCNA
    Computer Science Graduate

    Comment


    • #3
      Re: Export and Import ODBC settings

      How about File DSN, they is easier to distribute.
      "...if I turn out to be particularly clear, you've probably misunderstood what I've said” - Alan Greenspan

      Comment


      • #4
        Re: Export and Import ODBC settings

        I don't know the diff, but its a system dsn anyway ..
        Thanks & Regards

        Retaliator

        MCSA/MCSE/CCNA
        Computer Science Graduate

        Comment


        • #5
          Re: Export and Import ODBC settings

          If you could recreate it as a file DNS there is no registery import or export or any of that. Create a test one under file dsn and the go to
          C:\Program Files\Common Files\ODBC\Data Sources\*
          copy and paste that file to the target computer and you have distributed an ODBC source. I have never found a practice difference in functionality between the two.
          "...if I turn out to be particularly clear, you've probably misunderstood what I've said” - Alan Greenspan

          Comment


          • #6
            Re: Export and Import ODBC settings

            Thanks, for now i am fixed, as i already spreaded that on the domain by hansd (we have helpdesk).. for future, i found that a REG that match XP can work for 2k too (even though it points to windows and not winnt) or the script that some1 posted me before.

            Retaliator,
            MCSE
            Thanks & Regards

            Retaliator

            MCSA/MCSE/CCNA
            Computer Science Graduate

            Comment

            Working...
            X