I am attempting to insert data into a linked server using openquery. I have attempted the below syntax, but get an error of
Cannot get the column information from OLE DB provider "MSDASQL" for linked server "Aurora".
What is the proper way to write this syntax so that my update statement will execute as it should?
INSERT INTO OPENQUERY(AURORA, 'Select firstname, lastname, address, city, state from testdb.address_info') VALUES ('jo', 'bob', '11111 no where drive', 'city1', 'state1')