Main Menu

KB#00930-Step-by-step instructions for creating a ODBC data source under Windows


Step-by-step instructions for creating a ODBC data source under Windows


When you installed the BASIS ODBC Driver a manual was installed into the same program group as the ODBC Driver. Here are step-by-step instructions for creating a data source using the Microsoft ODBC Administrator. 

1. Go to START / Settings / Control Panel / ODBC Administrator. Double Click to run. 
2. Click on the 'File DSN' tab, then in the box labelled 'Look in:' verify what the path to your Data Sources directory. This is usually C:\program files\common files\odbc\data sources\. 
3. Using Windows Explorer, go to the above data sources directory and create a file with a DSN extension. As an example, I am going to have a data source for accounting, so I will name my file 'Accounting.dsn'. This is an ASCII text file - editable by any program such as wordpad or notepad. If you already have at least one .dsn file then you can also copy and paste it into the same directory and then rename the copy. 
4. Open the Accounting.dsn file for editing and enter the following 2 lines. 
If you've made a copy of another and there are additional lines in this file remove them. 
5. Save Accounting.dsn ensuring that Windows doesn't add a .txt extension to it making it look like Accounting.dsn.txt 
6. Go back to the ODBC Administrator, and on either the User DSN tab, or the System DSN tab, click on Add . . . 
Select the BASIS ODBC Driver from the list presented and then Finish. 
7. In the BASIS ODBC Driver Data Source Configuration window that comes up, enter Accounting in the Data Source Name: field. You can enter a description if desired but this field isn't required. In the Database field, enter the complete path and filename to your BASIS configuration file. This file is typically named CONFIG.TPM (under UNIX it's typically config.TPM) and is usually in the same directory as the data dictionary files. 
        a.) if your config.tpm file is local to this workstation but you will be connecting to a PRO/5 Data Server enter the User ID: into the provided field OR make sure you have a USERID=username line in the config.tpm file. 
        b.) if your config.tpm file is located on another machine that you will be connecting to with a PRO/5 Data Server, you MUST enter a valid User ID: in the next field, in order for the connection to be made. Then enter the path to the data server in the Database field like this: 

8. Since you probably have a demo ODBC Driver, you must select READ ONLY in the Options list. It's strongly suggested that you also enable all 3 types of logging and put a complete path and filename in for a logfile. 
9. If your PRO/5 data contains any OEM or Julian dates then you need to define the suffix of your date fields defined in the dictionary. If you have more than one suffix, separate them by commas. If your dates are stored in any of the formats listed in the drop down box next to this select it and click on the OK button. 
10. Close the ODBC Administrator 

Then using your 3rd party application, choose get external data and get the Accounting Data Source. 

Last Modified: 12/30/2003 Product: BASIS ODBC Driver Operating System: Windows

BASIS structures five components of their technology into the BBx Generations.

  Google+ View BASIS LinkedIN Profile Visit our Twitter Feed Check out our Facebook Public Profile Click to View the BASIS youTube channel