Admin: Splice Machine Configuration

This section describes how to create and configure ac Splice Machine Data Source Name (DSN). Please follow the steps below.  Please note that you may skip steps 1 – 3 if you have already installed the ODBC driver. 

1. In a web browser, navigate tohttp://www.easysoft.com/products/data_access/odbcderby-driver/ - section=tab-1 https://www.easysoft.com/cgibin/productdownload.cgi?p=58http://www.easysoft.com/products/data_access/odbcderby-driver/ - section=tab-1 to download the driver. 

2. In the download page, set Platform to ‘Windows - x86 - (32 - Bit, 64 - Bit)’ and proceed to download the driver.

   

3. In the download folder, double click odbc-derby-1_1_0-windows.exe.  

4. In the Easysoft ODBC-Derby Driver Setup Window, click Next and follow the required steps to install the driver. 

   

5. Once you have successfully installed the ODBC driver, go to Control Panel\All Control Panel Items\Administrative Tools and click ODBC Data Sources (64-bit). 

6. In the ODBC Data Source Administrator Window, click the System DSN tab. 

7. Click the Add… button to create a new Data Source.

8. Find Easysoft ODBC-Derby Driver and click Finish. 

   

9. In the Easysoft ODBC-Derby Driver DSN Setup Window, configure the following details: 

   • DSN: the name of the Data Source. 

   • Database: the database name. 

   • User: the database username. 

   • Password: the database password. 

   • Server: the host server (IP address or server name). o If the server is hosted in Amazon, use the EC2 DNS name, i.e. ‘ec2-xx-xxx-xxxxxx.compute-1.amazonaws.com’. 

   • Port: the server port number. Only numerical values are supported. The default server port is 1527. 

     

10. Click the Test button. Once the connection has been made successfully, click the OK button to create the DSN.