Skip to Content
avatar image
Former Member

Database Connection Error: Cannot obtain error message from the server

I have a SQL statement that wants to add a temp table to the database. The SQL statement works fine but when I try to add it via 'Add Command' feature in Crystal XI R2, I get the following error message:

Database Connection Error: Cannot obtain error message from the server

Any ideas?

Thanks in advance,

Zack H.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 05, 2009 at 09:49 PM

    Can you try creating a stored procedure with the query and adding this to the report? also can you paste the query here?

    Regards,

    Raghavendra

    Edited by: Raghavendra Gadhamsetty on Jun 5, 2009 11:49 PM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 30, 2009 at 03:45 PM

    Crystal probably can't see the table because of the owner of the table. You can usually get around this by setting the quallified table name but you can't do this in Crystal under set database location.

    When creating the table try create the table with a owner that is accessible by everyone. For example in MSSQL dbo would be an owner that everyone can see.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Zilla,

      I tried to create a new database connection using the SA credentials.

      I still get the same error message.

      I know it is a user rights issue within Crystal because I do see the temp table created successfully on the db side.

      Why is it not allowing me to see the temp table in Crystal? How can I overcome this issue?

      Thanks,

      Zack H.

  • avatar image
    Former Member
    Aug 07, 2009 at 04:13 PM

    It works now.

    I had to change my sql statement as follows:

    SELECT LastName, FirstName INTO #TibetanYaks

    FROM Employee

    WHERE EmployeeID between '2000' and '3000'

    SELECT *

    FROM #TibetanYaks

    DROP TABLE #TibetanYaks

    Add comment
    10|10000 characters needed characters exceeded