Results 1 to 3 of 3

Thread: Cannot open SQL Server

  1. #1

    Thread Starter
    Hyperactive Member yousufkhan's Avatar
    Join Date
    Jan 2002
    Location
    India
    Posts
    492

    Angry Cannot open SQL Server

    some tipical problem i m facing
    I have created report in crystal 7, database is in sql 2000
    and using odbc to connect to sql
    rpt is working perfectly in crystal
    'when i am calling through vb6 is giving error

    " Run-time error '20599' Cannot open sql server'

    when the other reports are working perfectly and when i am running any old report after that when i call these rpt its start working but with half selection formulas

    when i am calling these rpt first its gives above error
    what could be problem

  2. #2
    Lively Member afterMoon's Avatar
    Join Date
    Oct 2002
    Location
    cochin
    Posts
    117

    Re: Cannot open SQL Server

    Me also facing the same problem. plz help
    when in doubt, win the trick

  3. #3
    Lively Member afterMoon's Avatar
    Join Date
    Oct 2002
    Location
    cochin
    Posts
    117

    Re: Cannot open SQL Server

    yes ! I solved it. The user should be given the previlage of system administrator in sql server. I donno whether it's the right way. But it's working fine.
    when in doubt, win the trick

Posting Permissions

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



Click Here to Expand Forum to Full Width