C#代码通过odbc连接后台关系cache数据库的实例出现的问题
玉老虎 2014-06-27 06:59:45 string ConectionString = "Dsn=cacheOdbc;uid=_system;pwd=SYS;providerName=System.Data.Odbc";
public DataSet GetDataSet(){
CacheConnection ccCon = new CacheConnection(ConectionString);
string sql = "select PAADM_PAPMI_DR->PAPMI_Medicare from SQLUser.pa_adm ";
CacheDataAdapter cda = new CacheDataAdapter(sql, ConectionString);
DataSet ds = new DataSet();
cda.Fill(ds);
以上代码在 cda.Fill(ds);时报错捕捉到
CacheException:[SQLCODE:<-30>;<Table or View not found>]
此sql语句“select PAADM_PAPMI_DR->PAPMI_Medicare from SQLUser.pa_adm ”
在intersystems———home——sql——execute sql query 窗口中执行查询
可以查询出结果,没有问题
补充一下:odbc数据源连接成功!
请高手们多多帮忙解决下,非常感谢