Configuring Easy Rides Data Connections

Easy Rides uses a data connection to the SQL server. The data connection information can be a System DSN, User DSN or File DSN, or be stored in a configuration file. The data connection in an .ini file is encrypted and can only be ready by the Easy Rides software. When stored in .udl files it can be opened and edited, but this not as secure because all of the connection information is visible to anyone opening the file.

Benefits to using the File DSN

  • The easiest to setup and only one file DSN is needed for all users
  • Most reliable because it isn’t subject to changing users on a computer, OS updates or new computers
  • Most secure method (if using a .ini)
  • Requires the least maintenance

Normally, Mobilitat will take care of setting up the data connection for all customers. This documentation is provided for information or as needed if you choose not to have Mobilitat set this up for you.

To store the connection in the INI configuration file:

  • Open Easy Rides or the Easy Rides Utility
  • If there is no configured data connection, Easy Rides will prompt you to create one

Data Connection Prompt

  • Scroll down and choose ‘Microsoft OLE DB Provider for SQL Server’ and click Next»

Data Link Driver

  • Enter Server Name or IP address (and if needed, [SQL instance name] without the brackets). For example; IBUYPOWERI7-930\SQLSERVER

Data Link Properties

  • Select whether you want to use Windows authentication (which requires users or group SQL permissions set and maintained to the Easy Rides database and upkeep as new users are added or leave the group) or a pre-configured SQL User and password
  • If SQL user is selected, enter the User Name and Password then check the Allow saving password checkbox
  • Use the dropdown to select the database
  • Click OK.

This will generate a configuration file called ‘defaultdatalink.ini’ in the same folder as the Easy Rides exes and will work for all users running Easy Rides from this location.

To store the connection in a UDL file

  • Create an empty text file
  • Rename the file ‘defaultdatalink.udl’ – you can open the empty file in a text editor and choose ‘save as’, make sure the file type is “all files” and then save the file with the name ‘defaultdatalink.udl’
  • Find the file in the File Explorer and double-click on it

Data Link Driver

  • On The Provider Tab, Scroll down and choose ‘Microsoft OLE DB Provider for SQL Server’ and click Next»
  • Select whether you want to use Windows authentication (which requires users or group SQL permissions set and maintained to the Easy Rides database and upkeep as new users are added or leave the group) or a pre-configured SQL User and password

Data Link Properties

  • If SQL user is selected, enter the User Name and Password then check the Allow saving password checkbox
  • Use the dropdown to select the database
  • Click OK.

Easy Rides exes and will use this data connection for all users running Easy Rides from this file share.

To rebuild a data connection to the Easy Rides database for MS Access files

  • Open the MS Access file containing the queries or reports provided by Mobilitat or files created for connecting to an Easy Rides database.
  • Click on Linked Table Manager (you might have to click on the External Data tab first)

Linked Table Manager

  • Click on Select All
  • Check “Always prompt for new location” then click OK
  • Click the New… button
  • Select “SQL Server” data source driver

Linked Table Manager

  • It really helps to first browse the network and open the Mobilitat\Reports folder (or wherever the MS Access file your working in is stored). You can browse for it, but copying the UNC network path will pay off later.
  • Copy the file location and paste it into the location window
  • Type “\ERidesdb.dsn” without the quotes on the end of the path

Linked Table Manager

  • Select and copy the path and filename before clicking Next > then Finish
  • Enter a description
  • Enter or select the server

Linked Table Manager

  • Click Finish
  • In the Select Data Source Window it will display your new file. Click it and click OK. It will refresh the linked tables with the SQL Server database