Salesforce

How to find the DSN and database used by a working Product Library

« Go Back

Information

 
TitleHow to find the DSN and database used by a working Product Library
SummaryHow to find the DSN and database used by a working Product Library
URL NameHowto-find-the-DSN-and-database-used-by-a-working-Product-Library
Resolution

First, check which DSN the library is using:
1. Open the library.
2. Right click in the library and choose Properties.
3. In the "Data Source" tab, review the "Primary data source" field to see which DSN is being used.

Next, find out which database that DSN is pointing to:
4. Choose Start (> Settings, on Windows XP or Windows 10) > Control Panel > Administrative Tools > Data Sources (ODBC)
5. In the "ODBC Data Source Administrator" window, click the "File DSN" tab and select the DSN shown in step 3.
6. Click "Configure..." and on the resulting window, the Workbook (Excel), Database (Access), or Directory (dBase) path will be displayed. If it is truncated, click the Select button for more details.
ProductsPlanogram Converter; Space Planning; Space Planning Field; Space Planning Plus; Space Planning Viewer
Module
VersionAll
Error Message Code
Cause
Additional Information

- The default location of DSN files is different on various versions of Windows.
- On XP, the default location is C:\Program Files\Common Files\ODBC\Data Sources
- On Windows 7, the default location is C:\Users\[Username]\Documents\
- On Windows 10, the default location is C:\Program Files (x86)\Common Files\ODBC\Data Sources
Publication StatusPublished

Powered by