Hi,
am trying to connect to PRONTO database from sqlserver via linked server and i get the following error
An unexpected NULL value was returned for column "[MSDASQL].plt_monitor_latest_read_date" from OLE DB provider "MSDASQL" for linked server "MIS PRONTO UAG". This column cannot be NULL.
This is my query
select * from
OPENQUERY([MIS PRONTO UAG],
'SELECT
plant_monitor.plant_no, plant_monitor.plt_monitor_latest_read_date
from
plant_master,
plant_monitor
WHERE
plant_monitor.plant_no = plant_master.plant_no AND (plant_master.plt_type_codes#1="LVF")
')
I can't use nullif statments in my openquery as pronto doesn't recognize them. any other way to get around this.
cheers,
nitula