![]() ![]() ![]() Select on General: Name the Linked server whatever you like.Create a new linked server by Right Clicking on Linked Server and selecting New Linked Server.Ensure that “Level zero only” and “Allow inprocess” are checked.Click on Server Objects, Linked Servers, Providers, then Right Click MSDASQL and go to Properties.NOTE: these examples were completed in the 64-bit (圆4) version of Sage 100 Install Sage ODBC by following the image example guide below.Follow the step-by-step guide below to get started: Creating a SQL Linked Server with Sage ODBC Steps: An Open Database Connectivity is an API designed to help access and jointly manage separate database management systems, allowing you to export and view reports between different applications like Sage 100cloud and Excel. This walkthrough will show the steps to creating a SQL linked server in Sage 100 using a Sage ODBC to connect the databases and speed up reporting that may be running slow. Purpose: Speed up reports currently in Sage that may run slow ![]() Cosmetics and Nutraceutical Manufacturing ERP Software. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |