Easysoft Blog

Tue, 06 February 2018

ODBC Access from Windows Server Core

Server Core is an installation option available in Windows Server that eliminates any services and features that are not essential to provide the most commonly used server roles. For example, a Windows Server machine that runs in Server Core mode has no graphical user interface i.e. no Windows desktop.

The advantages of Server Core are: reduced hardware requirements, much smaller attack surface, and a reduction in the need for updates.

By default, Easysoft ODBC drivers have a GUI-based licensing program on Windows. This blog shows how to license an Easysoft driver in a GUI-less environment.

When testing, we used the Salesforce.com ODBC driver on Windows Server version 1709. If you want to uses another Easysoft ODBC driver on Windows Server Core, please contact our Support team.

  1. Download the Windows Salesforce.com ODBC Driver. (Registration required.) and copy the installer to the Windows Server Core machine.
  2. Run the Easysoft installer by changing to the folder where you copied the program and running:
    odbc-salesforce-version-windows.exe /exenoui /qn

    where version must be 1_1_12 or higher.

  3. In a PowerShell window, run:
    & 'C:\Program Files (x86)\Easysoft Limited\Easysoft SalesForce ODBC Driver\libs\siteinfo.exe'

    This will get the site number for your machine.

    If you didn't install the driver on your C drive or in the default location, amend the command accordingly.

  4. Obtain a trial license or purchased license using the Easysoft web site.
  5. When you have the license in PowerShell, run:
    $path='HKLM:\SOFTWARE\WOW6432Node\Easysoft\Licences'
    Set-Location -Path $path
    cd ..
    Get-ChildItem
    

    The output of this command will be similar to:

    Name                           Property
    ----                           --------
    Info                           LICENCEAPP  : "C:\Program Files (x86)\Common Files\Easysoft\License Manager\eslicap.exe"
                                   LicenceHelp :
                                   Company     :
                                   Email       :
                                   FaxNo       :
                                   PhoneNo     :
                                   Name        : Administrator
    Licences                       l1 : LMKMR-JW4BQ-2CLPG-3UG82-RWGC2-FXU2Q-WJPBU-Q8R3Q-WG9VC-8KYR8
    
  6. To add the license key, in PowerShell, run:
    New-ItemProperty -Path $path -Name $name -Value $key -PropertyType string

    where:

    • $name='ln'

      If your machine has not been licensed before, the Licences line will be missing from the command output generated in the previous step, and you should set n to 1, i.e. $name='l1'

      If your machine has been licensed before, set n to the next number in the sequence, e.g. $name='l2'

    • $key='Your license key goes here'

    Repeat the New-ItemProperty command for each key you need to add, incrementing n in $name and putting your new key in $key.

  7. When you have added the key, run:
    Get-ChildItem

    If the previous step was successful, the command's output will show you your keys.

  8. When the software is licensed, you can either set up an ODBC data source or use a DSN-less connection (for example, DRIVER={Easysoft Salesforce ODBC Driver};User=myuser@easysoft.com;Password=mypassword; TOKEN=ABCDEFGH123456;).

    To set up a 32-bit ODBC data source (do this if your application is 32-bit), run:

    drive:\Windows\SysWOW64\odbcad32.exe

    To set up a 64-bit ODBC data source (do this if your application is 64-bit), run:

    drive:\Windows\System32\odbcad32.exe

To create a Salesforce.com ODBC Driver data source:

  1. Choose the System DSN tab, and then choose Add.
  2. In the Create New Data Source dialog box, choose Easysoft ODBC-Salesforce Driver, and then choose Finish.
  3. Complete the Easysoft ODBC-Salesforce Driver DSN Setup dialog box:
    Setting Value
    DSN Salesforce.com
    User Name The name of your Salesforce.com user. For example, myuser@mydomain.com.
    Password The password for your Salesforce.com user.
    Token The security token for your Salesforce.com user, if required.

    To find out whether you need to supply a security token, choose the Test button. If the connection attempt fails with an error which contains LOGIN_MUST_USE_SECURITY_TOKEN, you need to supply one.

    Salesforce.com emails the security token to the email address associated with your Salesforce.com user account. If you have not received a security token, you can regenerate it. Salesforce.com will then email the new security token to you. To regenerate your security token, log in to Salesforce.com and then choose Setup from the user menu. Search for "security token" in the Quick Find box. Click Reset Security Token in the Reset Security Token page. When you receive the token in your email client, copy it and then paste it into the Token field.

  4. Use the Test button to verify that you can successfully connect to Salesforce.com.