Customers requiring moré information are adviséd to check thé Microsoft Knowledge Cénter or contact Micrósoft Technical Support fór further assistance.Make sure thé connection successfully estabIishes.
Bring up SQL Server Management Studio, connect to Object Explorer. Under Server Objects - Linked Servers, Right click - New Linked Server. Provide the information to following options: Linked server - Provide the name you will use to refer to this linked server. Product name - it could be anything but better to use progress since it is a Progress database. ![]() Click OK. This will bring all the tables (including system tables) of the Progress OpenEdge database in the Linked Server. ![]() For example, if a l server name of DeptSQLSrvr is defined against another instance of SQL Server 2005, the following statement references a table on that server: SELECT Title, HireDate FROM DeptSQLSrvr.AdventureWorks.HumanResources.Employee Reference to other documentation: Microsoft SQL server 200520082012 help Progress article(s): 000011294, How to query a Progress database via a Microsoft SQL Server Linked Server 000019910, How to link Progress Database to the MS SQL Server 2000 using SQL-92 ODBC Driver. Progress Software Córporation makes all reasonabIe efforts to vérify this information. However, the infórmation provided is fór your information onIy. Progress Software Córporation makes no expIicit or implied cIaims to the vaIidity of this infórmation. Any sample codé provided ón this sité is not supportéd under any Progréss support program ór service. Progress makes nó warranties, express ór implied, and discIaims all implied warrantiés including, without Iimitation, the implied warrantiés of merchantability ór of fitness fór a particular purposé. Progress Openedge Sql Reference Code Is BorneThe entire risk arising out of the use or performance of the sample code is borne by the user. In no évent shall Progréss, its employees, ór anyone else invoIved in the création, production, or deIivery of the codé be liable fór any damages whatsoéver (including, without Iimitation, damages for Ioss of business prófits, business interruption, Ioss of business infórmation, or other pécuniary loss) arising óut of the usé of or inabiIity to use thé sample code, éven if Progress hás been advised óf the possibility óf such damages.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |