这是我的语法报错 select box.scph,box.box,box.boxchild,box.dvr,box.date,box.boxchild1,box.mac,box.id,box.pellet,link_orcal.GETACCREDITDATA.sn,link_orcal.GETACCREDITDATA.stbmac,link_orcal.GETACCREDITDATA.cmmac,link_orcal.GETACCREDITDATA.nuid from box inner join link_orcal..CPEA.GETACCREDITDATA ON box.id=link_orcal.GETACCREDITDATA.sn where box.scph='81009510'
select box.scph,box.box,box.boxchild,box.dvr,box.date,box.boxchild1,box.mac,box.id,box.pellet, b.sn,b.stbmac,b.cmmac,b.nuid from box INNER JOIN link_orcal..CPEA.GETACCREDITDATA b ON box.id=b.sn where box.scph='81009510'OK
查詢報錯服务器: 讯息 7354,层级 16,状态 1,行 1 OLE DB Provider 'MSDAORA' 提供数据行 'LASTACCREDITTIME' 无效的中继数据 (Metadata)。The data type is not supported. OLE DB 错误追踪 [Non-interface error: Column 'LASTACCREDITTIME' (ordinal 5) of object '"CPEA"."GETACCREDITDATA"' reported an unsupported value for DBTYPE of 13]。
select box.scph,box.box,box.boxchild,box.dvr,box.date,box.boxchild1,box.mac,box.id,box.pellet,link_orcal.GETACCREDITDATA.sn,link_orcal.GETACCREDITDATA.stbmac,link_orcal.GETACCREDITDATA.cmmac,link_orcal.GETACCREDITDATA.nuid from box inner join link_orcal..CPEA.GETACCREDITDATA ON box.id=link_orcal.GETACCREDITDATA.sn where box.scph='81009510'
OLE DB Provider 'MSDAORA' 提供数据行 'LASTACCREDITTIME' 无效的中继数据 (Metadata)。The data type is not supported.
OLE DB 错误追踪 [Non-interface error: Column 'LASTACCREDITTIME' (ordinal 5) of object '"CPEA"."GETACCREDITDATA"' reported an unsupported value for DBTYPE of 13]。