recordset的问题

代码是
connectBank.Open "provider=SQLOLEDB;user id=sa;password=;Intial Catalog=OnlineBanking"
recordBank.Open "select * from customer", connectBank, adOpenDynamic, adLockOptimistic
错误是:
Invalid object name 'customer'
为什么在sqlserver7.0的库OnlineBanking里有customer表
但错误却说customer是Ivalid object name呢?

解决方案 »

  1.   

    将customer用[]括起来
    set recordBank=new adodb.recordsetrecordBank.Open "Select * from [customer]",connectBank,adOpenDynamic,adLockOptimistic
      

  2.   

    set recordBank = oconnectBank.exec("select * from customer")
      

  3.   

    检查一下customer表的所有者（owner）是不是dbo,如果不是就用
    recordBank.Open "Select * from ownerxx.customer",connectBank,adOpenDynamic,adLockOptimistic