{"id":1801,"date":"2014-11-12T23:34:04","date_gmt":"2014-11-12T23:34:04","guid":{"rendered":"https:\/\/alt2.minisoft.com\/support\/?p=1801"},"modified":"2014-11-18T23:01:09","modified_gmt":"2014-11-18T23:01:09","slug":"ole-db-how-do-i-create-a-linked-server","status":"publish","type":"post","link":"https:\/\/www.minisoft.com\/support\/ole-db-how-do-i-create-a-linked-server\/","title":{"rendered":"OLE DB – How do I create a Linked Server?"},"content":{"rendered":"

Prior to creating the linked server, properties of the driver must be set.\u00a0 Run SQL Server Management Studio and expand out Server Objects, Linked Servers, Providers. Right click on HP3KProvider and enable “Allow inprocess<\/span>“.<\/p>\n

Right click on Linked Servers and select \u201cNew Linked Server\u2026\u201d<\/p>\n

\"LinkedServer\"<\/a><\/p>\n\n\n\n\n\n\n\n\n
Linked Server<\/b><\/td>\nThis is the name you will use to reference your Linked Server. It can be anything.<\/td>\n<\/tr>\n
Server Type<\/b><\/td>\nSelect \u201cOther data source\u201d.<\/td>\n<\/tr>\n
Provider<\/b><\/td>\nSelect the \u201cMinisoft OLE DB Provider for Image\/Eloquence\u201d.<\/td>\n<\/tr>\n
Product Name<\/b><\/td>\nThis field can not be left blank, but the value can be anything. The suggested value is \u201cHP3KProvider\u201d.<\/td>\n<\/tr>\n
Data Source<\/b><\/td>\nThe IP Address or Host Name of the box running Image\/Eloquence. This field can be left blank if the information is included in the \u201cProvider String\u201d.<\/td>\n<\/tr>\n
Provider String<\/b><\/td>\nA list of properties separated by a semi-colon. At the very least it needs to consist of ServerPort, logon information, and database and\/or schema file references. Please refer to “How do I create a ConnectionString”\u00a0above for the list of properties.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\"LS_Dialog\"<\/a><\/p>\n

Once the linked server is created, right click on the linked server then click properties. Click on Server Options then set “Collation Compatible” and “Rpc Out” to True.<\/p>\n

\"LS_ServerOptions\"<\/a><\/p>\n

\"faq1\"<\/a><\/p>\n

\"LS_Mgmt_Studio\"<\/a><\/p>\n

\"LS_New_LS\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Prior to creating the linked server, properties of the driver must be set.\u00a0 Run SQL Server Management Studio and expand out Server Objects, Linked Servers, Providers. Right click on HP3KProvider and enable “Allow inprocess“. Right click on Linked Servers and select \u201cNew Linked Server\u2026\u201d Linked Server This is the name you will use to reference […]<\/p>\n","protected":false},"author":75,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54,65],"tags":[],"_links":{"self":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/1801"}],"collection":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=1801"}],"version-history":[{"count":5,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/1801\/revisions"}],"predecessor-version":[{"id":1974,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/1801\/revisions\/1974"}],"wp:attachment":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=1801"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=1801"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=1801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}