Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Tallinn, Harjumaa, Estonia
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error in defining qry from SQL Server (Excel2000)

    Hi!

    I installed a new version of application(SCALA) running in SQL Server (7)

    I have lot of queries from the scala database running in
    Excel which I should redesign due to the new verion.

    I get error 'Invalid cursor state' when designing a query in MS qUery window.

    Simple queries are OK, but adding criteria gives the error.It's very frustrating

    What can I do about this?


    Thanks for any help

    Anu

  2. #2
    Lounger
    Join Date
    Jan 2001
    Location
    Tallinn, Harjumaa, Estonia
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error in defining qry from SQL Server (Excel2000)

    Hi!

    There was erroneous Mdac_typ in scala CD, I downloaded Mdac-typ from Microsoft and installed it. Now all works.

    Anu

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •