www.loanperformer.com

Table of Contents (Online Help)

Establishing the ODBC connectivity

How to establish the ODBC connectivity

Click on Start, then click on Control Panel. The Control panel window is displayed:

Double - click on the Administrative Tools icon. A screen like the one below is displayed:

Double click on the Data Sources (ODBC) icon. The ODBC Data Source Administrator window is displayed. See below:

Note: To open the ODBC Data Source Administrator window shown above for a 64 bit machine you go to C:\Windows\syswow64 and click on the odbcad32.exe file to open the window.

In the ODBC Data Source Administrator Window, select the System DSN tab and click on the Add command button on the right side of the screen. The Create New Data Source window is displayed.

When setting up an ODBC Data Source you have the option to set up by User DSN or System DSN. A User DSN is specific to a user on the workstation. For example, if you log on to a machine as user "David," set up a User DSN, then log off, and then log on to the machine as user "Robert", "Robert" will not see the Data Source. Why? It's specific to David's profile, not Robert's.

Conversely, if you set up a System DSN, it does not matter who logs on to the machine; all users that logon to that workstation will have access to that Data Source

In the Create New Data Source Window, scroll all the way to the bottom of the list and click on SQL Server Native Clients 10.0.

Click on the Finish command button and the following window is displayed:

Note that For instance when you detach a database in SQL Server, you are taking the database offline and removing it from the SQL Server instance from which you are detaching it. The databases data and log files remain intact and are left in a consistent state so you can then attach the database at a later point or to another SQL Server instance.

In the Create a New Data Source to SQL Server window, enter a Name for your ODBC connection, e.g., "LPF".

Enter a Description for the data source. This can be any descriptive information that you desire, e.g., "Demodata".

Enter the Server name for the SQL Server, e.g., "DAVID-PC".

Once all of the fields are entered, click on the Next button.

Click on the appropriate radio button for your connection type. If you access your SQL Server Database using your standard Windows login, keep the default option, i.e., "With Integrated Windows NT Authentication".

Note: If you access your SQL Server Database in the SQL management studio using an SQL Server Login, click on the radio button option for "With SQL Server Authentication" and enter the login details. Then, you must enter your SQL Server Login ID and Password.

Click on Next command button and the following window is displayed:

Tick the Change Default Database To: then, in the drop-down menu, select your SQL Server database name, e.g., "Demodata".

Click on the Next command button and the following window is displayed:

In this window, typically the default options should remain "as is" so do not change any options.

Click on the Finish button. The ODBC Microsoft SQL Server Setup window is displayed:

In the ODBC Microsoft SQL Server Setup Window, click on the Test Data Source button to be sure that your connection settings are correct.

• If your settings are correct, you should see a message indicating that the "TESTS COMPLETED SUCCESSFULLY."
• If the test failed, you'll need to click the BACK buttons to determine which setting is wrong and then repeat the above steps.

Click on the OK command button to exit.

When you now log into Loan Performer (LPF), click on the SQL Server button for LPF to search for databases

existing on your network. The attached database should now appear in the Databases drop down list.

The database is now attached and will appear on the list of available databases on your Server.

Related Topics

Contact LPF live support for more information
This service requires an Internet connection.