JeffGBrown857
New Member
I am trying to perform INSERT and UPDATE statements in MS SQL 7.0 through a linked server set up through a ODBC connection using the MERANT 3.60 32-BIT Progress SQL92 v9.1B drivers.
From what I've read, this should be the standard format for an INSERT:
select * FROM
OPENQUERY ( UniDev, 'INSERT INTO pub."hm-test" (lastname, firstname) VALUES ("Rip", "Tendon")')
But when I execute this from SQL Query Analyzer, I get the following response:
Server: Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing a query for execution against OLE DB provider 'MSDASQL'.
[OLE/DB provider returned message: [MERANT][ODBC PROGRESS driver][PROGRESS]Syntax error (7587)]
Is this not the proper syntax for INSERTing a row into a PROGRESS database? Any help that can be provided would be greatly appreciated.
Jeff Brown
From what I've read, this should be the standard format for an INSERT:
select * FROM
OPENQUERY ( UniDev, 'INSERT INTO pub."hm-test" (lastname, firstname) VALUES ("Rip", "Tendon")')
But when I execute this from SQL Query Analyzer, I get the following response:
Server: Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing a query for execution against OLE DB provider 'MSDASQL'.
[OLE/DB provider returned message: [MERANT][ODBC PROGRESS driver][PROGRESS]Syntax error (7587)]
Is this not the proper syntax for INSERTing a row into a PROGRESS database? Any help that can be provided would be greatly appreciated.
Jeff Brown