It is possible to type in the name if it is not in the drop-down list. Select the appropriate instance of SQL Server to connect to. Enter a brief description of the connection, as well. Make a note of the name entered here, as it will be needed in future steps. In this example, the Name is the store data file's name, AjaxOrders. Enter a meaningful name for the data source, such as OMDataFile or the OMStoreNameDataFile name, if more than one data file is used.Select SQL from the drivers list and click the Finish button. The path for the data file will appear in the ODBC Microsoft Access Setup window:Ĭlick the OK button to return to the System DSN tab.Ĭlick on OK to exit the ODBC Data Source Administrator window.Ĭreate an ODBC Connection to a Microsoft SQL Server Database in Windows XP Make sure that the Read Only and Exclusive options are NOT checked (see the figure above) then click on the OK button. Look for the entry " Order Manager Data File" to obtain the name and path information for your store’s data file. This will bring up a window with details on the file names and locations used by the Order Manager. To determine the name or location of the data file used by the Order Manager, press CTRL+SHIFT+C at the Main Menu. Enter a brief description of the connection, as well.Ĭlick on the Select button (pictured above) to navigate to the location of the Order Manager’s data file. Select Microsoft Access Driver (*.mdb) from the drivers list and click the Finish button.Įnter a meaningful name for the data source, such as OMDataFile or OMStoreNameDataFile, if more than one data file is used. Select Administrative Tools and double click the Data Sources (ODBC) icon. Create an ODBC Connection to a Microsoft Access Database in Windows XP If the ODBC connections will be made manually on a 64-bit operating system, please read the Knowledge Base article, Windows 64-bit Operating System Considerations before proceeding. This function automatically creates an ODBC connection for a Microsoft Access data file. The preferred method to create an ODBC connection for use with an Access data file is by utilizing the Worldship Setup function found by going to Maintenance Menu >Setup Functions >UPS Worldship Setup >Go. Review the settings of the ODBC connection on the workstation or server where the data file was converted from Microsoft Access to duplicate them on additional workstations. If an SQL data file is being used by the Order Manager, it is preferable to utilize the same ODBC connection that was automatically created by the program when the Microsoft Access database was converted to SQL to avoid errors. This document outlines the manual steps to create ODBC connections for an Access database and an SQL database in the Windows XP environment as it relates to connecting an Order Manager data file with external shipping software applications or to connect additional workstations to a new SQL data file that was converted from Microsoft Access. Create an ODBC Connection to a Microsoft SQL Server Database in Windows XP.Create an ODBC Connection to a Microsoft Access Database in Windows XP.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |