我们的开发环境是 2005.NET 数据库是10g ~~
程序在我们的机器上,和发布到虚拟目录上跑是一点问题都没有。
只要一到客户的服务器上就会出一个错误:
未指定的错误
ORA-01747: 无效的用户.表.列,表.列,或列规格~~
客户的服务器数据库是9i~~
我查看了配置完全都没问题~
数据库表也都对过了。也没问题。
我把我们这里生成的SQL语句发给客户的技术 让他们用PLUS执行。
都是没问题的。但是只要一到程序里就报刚刚那个错误。
我去网上查了。都是说是什么关键字当成字段的问题。
我们的字段都不是关键字啊。我实在是没办法了。。
SQL语句可能是这样子的:
update ELE_TEAMMONTHEND set TEAMMONTHEND_DAY22 = '中 ' where TEAMMONTHEND_EMPLOYEEID =8086and TEAMMONTHEND_YEAR = '2007 ' and TEAMMONTHEND_MONTH = '3 '
update ELE_TEAMMONTHENDStatistic set STATISTIC_ZHONG=STATISTIC_ZHONG + 1 where STATISTIC_EMPLOYEEID =8086 and STATISTIC_YEAR = '2007 ' and STATISTIC_MONTH = '3 '
update ELE_TEAMMONTHEND set TEAMMONTHEND_DAY22 = '中 ' where TEAMMONTHEND_EMPLOYEEID =8088and TEAMMONTHEND_YEAR = '2007 ' and TEAMMONTHEND_MONTH = '3 '
update ELE_TEAMMONTHENDStatistic set STATISTIC_ZHONG=STATISTIC_ZHONG + 1 where STATISTIC_EMPLOYEEID =8088 and STATISTIC_YEAR = '2007 ' and STATISTIC_MONTH = '3 '
update ELE_TEAMMONTHEND set TEAMMONTHEND_DAY22 = '中 ' where TEAMMONTHEND_EMPLOYEEID =86202and TEAMMONTHEND_YEAR = '2007 ' and TEAMMONTHEND_MONTH = '3 '
update ELE_TEAMMONTHENDStatistic set STATISTIC_ZHONG=STATISTIC_ZHONG + 1 where STATISTIC_EMPLOYEEID =86202 and STATISTIC_YEAR = '2007 ' and STATISTIC_MONTH = '3 '
update ELE_TEAMMONTHEND set TEAMMONTHEND_DAY22 = '中 ' where TEAMMONTHEND_EMPLOYEEID =89032and TEAMMONTHEND_YEAR = '2007 ' and TEAMMONTHEND_MONTH = '3 '
update ELE_TEAMMONTHENDStatistic set STATISTIC_ZHONG=STATISTIC_ZHONG + 1 where STATISTIC_EMPLOYEEID =89032 and STATISTIC_YEAR = '2007 ' and STATISTIC_MONTH = '3 '
update ELE_TEAMMONTHEND set TEAMMONTHEND_DAY22 = '中 ' where TEAMMONTHEND_EMPLOYEEID =89176and TEAMMONTHEND_YEAR = '2007 ' and TEAMMONTHEND_MONTH = '3 '