none
分析服务2008数据连接问题 RRS feed

  • 问题

  • 使用分析服务2008连接sybase IQ数据源,连接成功后可在数据连接中查看IQ相关表内容,但建立数据源视图时失败,

    提示“ASAProv”失败,没有可用的错误消息,结果代码: DB_E_DELETEDROW(0x80040E23)。 (Microsoft Visual Studio)

    求达人指教。。。

    2011年4月22日 3:34

答案

  • 3. In the data source views section, create a new data source view given your data source that you just created. It seems importing the tables directly fails with some arcane error.
    a. Don't select any tables, just click next, until an empty view is created.
    b. You can now create named queries like "select * form <table name>

     

    说 创建一个空的view先,不要选任何表, 然后创建 query select * from table

    估计是ASA Anywhere的driver对于metadata的处理不够好


    If you think my suggestion is useful, please rate it as helpful.
    If it has helped you to resolve the problem, please Mark it as Answer.
    http://twitter.com/7Kn1ghts

    2011年4月30日 17:05

全部回复

  • Did you install Sybase client on ssas server?
    2011年4月22日 15:10
  • 你好 极光1987

     

    另外,我建议你参考下面链接所给的方法: SQL Server 2008 AS 链接Sybase IQ
    http://orangemile.blogspot.com/2009/09/connecting-to-sybase-iq-12-from.html

     

    Thanks,
    Weilin Qiao


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
    2011年4月25日 3:21
    版主
  • 需要安装SQL2008在IQ的服务器上吗?

    2011年4月28日 7:23
  • 连接打不开。。

    2011年4月28日 7:24
  • Don't need sql on Sybase machine, sql server runs on windows only by the way.
    2011年4月28日 13:50
  • 3. In the data source views section, create a new data source view given your data source that you just created. It seems importing the tables directly fails with some arcane error.
    a. Don't select any tables, just click next, until an empty view is created.
    b. You can now create named queries like "select * form <table name>

     

    说 创建一个空的view先,不要选任何表, 然后创建 query select * from table

    估计是ASA Anywhere的driver对于metadata的处理不够好


    If you think my suggestion is useful, please rate it as helpful.
    If it has helped you to resolve the problem, please Mark it as Answer.
    http://twitter.com/7Kn1ghts

    2011年4月30日 17:05