()Īt .ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)Īt .ExecutionManager.ExecuteNonQuery(String cmd)Īt .LinkedServer.TestConnection()Īt .LinkedServerProperties.DoPreProcessExecution(RunType runType, ExecutionMode& executionResult)Ĭannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "VF". Do you want to keep the linked server?Īn exception occurred while executing a Transact-SQL statement or batch. The linked server has been created but failed a connection test. gress.atgn ow.com/esp rogress/js p/AnswerCo ntrols.jsp ?directSol utionLink= 1&tabs =true& docPropVal ue=p120484 I have followed the instruction in this article on the progress website However when I am trying to setup a linked server in SSMS I receive the below error. I have set up a system DSN which connects to the progress DB fine and I can use MS access/Excel to pull data back from the progress DB using the DSN. I am trying to set up a linked server in MS SQL server 2008 32 bit.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |