This statement works if I enter it directly into mysql: UPDATE BEX_USER_REG_INFO SET STATUS_ID=5 WHERE BEX_USER_REG_INFO.BEX_USER_REG_INFO_ID=2
Utilizing the openquery command I'm trying to do the same thing from a MS SQL Server SELECT * FROM OPENQUERY(MYSQLTEST, 'UPDATE BEX_USER_REG_INFO SET STATUS_ID=6 WHERE BEX_USER_REG_INFO.BEX_USER_REG_INFO_ID=2') Server: Msg 7357, Level 16, State 2, Line 1 Could not process object 'UPDATE BEX_USER_REG_INFO SET STATUS_ID=6 WHERE BEX_USER_REG_INFO.BEX_USER_REG_INFO_ID=2'. The OLE DB provider 'MSDASQL' indicates that the object has no columns. OLE DB error trace [Non-interface error: OLE DB provider unable to process object, since the object has no columnsProviderName='MSDASQL', Query=UPDATE BEX_USER_REG_INFO SET STATUS_ID=6 WHERE BEX_USER_REG_INFO.BEX_USER_REG_INFO_ID=2']. I don't think that I am far off-can anybody see what is wrong with my syntax? Thanks, Jim ----------------------------------------------------------------- Jim Gronquist Computer Network and Programming Analyst Office of the Bursar Indiana University 812.856.3026 x6-3026 [EMAIL PROTECTED]
