Options

Silent Installation for Vertica Driver (ODBC)

KaitoKaito Employee
in General Discussion

Do we have any workaround or enhancement plan to install Vertica with silent installation option?

My prospect wants to deploy Vertica ODBC Driver for 800 clients automatically.

Thanks in advance,

Comments

  • Options
    Jim_KnicelyJim_Knicely - Select Field - Administrator

    Hi,

    For Windows?

    See:
    https://my.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/ConnectingToVertica/InstallingDrivers/Windows/SilentlyInstallTheClient.htm

  • Options
    KaitoKaito Employee

    Thank you, Jim. This customer wants to install the driver on Windows environments.

    I have one more question. Do you know how to set up a connection info at ODBC DSN using slient install or command line?

    Thanks in advance,

  • Options
    Jim_KnicelyJim_Knicely - Select Field - Administrator

    Vertica won't create a DSN for you on client machines. Maybe look into Windows "Group Policies"? The system admin should be able to push a DSN out to clients using Vertica.

  • Options
    KaitoKaito Employee

    Thank you, Jim!

  • Options
    KaitoKaito Employee

    This command-line works fine at Windows environment.

    odbcconf /S /A {CONFIGSYSDSN "Vertica" "DSN=VerticaSilentTest|Servername=192.168.1.146|UID=dbadmin|PWD=password|PreferredAddressFamily=none"}

  • Options
    KaitoKaito Employee

    odbcconf /S /A {CONFIGSYSDSN "Vertica" "DSN=VerticaSilentTest1|Servername=192.168.1.146|UID=dbadmin|PWD=password|PreferredAddressFamily=none|Database=Vmart"}

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...