Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Feedback

Setting up a Universal SQL data source in Jet Professional


Overview

Setting up a Universal SQL Data Source using Jet Professional

Before you can create a Data Source connection, you must first download and install Jet Professional from the Jet Professional download site.


You’ll also need the following files and information:

 

  • For Jet Professional or Jet Essentials 2013 and higher: your Jet License Activation Code
  • For Jet Essentials 2012 R2 and earlier: your Jet License Files (.jlf)
  • Database Information:
    • Server Name or IP Address
    • Authentication Type (Windows or Database)
    • Database Name
    • Version of SQL Server installed

Watch the Video!

 

 

 

Step-by-Step

To create a new Universal data source connection to your SQL database, start by clicking the Data Source Settings button on the Jet ribbon.

 

On the Data Source Settings window, click the Add button.

 

On the New Data Source window, provide a name for your SQL data source and select Universal for the type.  Click OK.


On the Data Source Settings window, click the Configure... button.

 

On the Provider tab of the Data Link Properties window, you will want to choose the database driver that corresponds to the version of SQL Server hosting your database.

The choice Microsoft OLE DB Provider for SQL Server should work with most databases for SQL Server 2012 or earlier.  Depending upon your version of SQL Server, you may experience better performance with one of the other choices.

Some database products include their own, specific database driver.  You'll want to check with the software provider of your database to determine the correct driver to use.

 

Depending upon which driver you choose, the appearance of the Connection tab can vary but should look similar to this:

On the Connection tab, specify:

  • The name of the server on which your database is located
  • The logon information: Windows NT or the user name and password (be sure to check the Allow saving password box if you are using a user name and password)
  • The name of the database to which this data source is connecting

 

On the Advanced tab...

It is a best practice to trim blank spaces from fixed-length text fields.

 


Note:  If you find that the password will not save when using more modern versions of the SQL database driver, you may need to ensure that that setting for Persist Security Info is set to True on the ALL tab:


 


You can then click the Test Connection button to verify your settings.  You should receive a confirmation message:

 

 

Click OK and the Data Source Settings window should show that you are licensed for the data source.

{If the text reads that You are not licensed for this data source, click that text to get additional information about the issue.}

You can then click the Test Connection button and should see the Test Connection Succeeded message.

Click OK .

If you would like this data source to be the default data source that Jet Professional will use, click the Set Default button on the Data Source Settings window.

Click OK and your Universal SQL data source is now ready for use with Jet Professional.


 
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments