Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error detected by database DLL 2

Status
Not open for further replies.

gscheepers

IS-IT--Management
Jan 21, 2002
150
US
Hi,

I've created a report that uses a foreign table. When I run the report, I get the following message on CE:

Error detected by database DLL. [On Page Server: DBSERVCL01.pageserver]

The data's pulled from SQL Server 7.

When I run the report from within CR, it works.

Any ideas to resolving the problem?

Many thanks, Gerhard Scheepers

"Great souls have wills; feeble ones only wishes..."
 
Common problem this one.

I think you need to set up a System DSN on the websever pointing to your SQL server.

When you view your report on CR, it uses your own ODBC connection to the database. On CE, the webserver needs its own connection.

If this doesn't work, it could be a rights thing, the account on the webserver (ce_repadmin i think) needs the rights to your tables in the report.

Hope this helps

mrees
 
From
Solution

This message appears because the report's database is referenced in the report using a mapped drive.

Mapped drives are created when a user logs onto the computer and are only available while that user is logged in. If that user in not logged onto the computer, the mapped drive is not available.

CE services impersonate accounts but do not actually log on to the computer. Therefore, even if a CE service runs under the domain account that mapped the drive, the mapped drive is not recreated when the CE service is running. For this reason, CE servers cannot connect to a database referenced using a mapped drive.

To resolve this, complete the following steps:

1. Open the report in the Crystal Reports designer on the Page Server.

2. On the 'Database' menu click 'Set Location' and then click the 'Convert to UNC' button. The 'File' box now displays the UNC path of the database files.

For example, the location of a table called 'Test_Table' displays as \\computer_name\share_name\Test_Table.mkd

3. Click the 'Done' button.

4. If the report uses more than one database table, the 'Propagate Set Location' box appears. Click the 'Yes' button in this box. This ensures that all tables referenced in the report use the UNC path.

Now you can successfully view the report in either the CMC or ePortfolio.

Note:
The account running the Page or Job server must have permission to the UNC path specified for the report. You may change permissions on the shared folder or change the account running the Page and Job server in the Crystal Configuration Manager. Check the Admin guide for more details.

_____________
AuctionHugh and Kathleen's Homepage:
 
AuctionHugh: The topic was resolved over a year and a half ago.

There are several reasons for this error, you copied one of them.

Check the dates of postings.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top