harbinderss
asked on
Error detected by database dll
dear sir
i'm using VB and access2000 and crstal reports 8.0
my program works fine in my computer
but when i make the exe and load it in another PC where there is no Vb, access and crsystal reports 8.0 , i get the error message
"Run time error 20534: Error detected by database dll"
how to recover from this error
please help
i'm using VB and access2000 and crstal reports 8.0
my program works fine in my computer
but when i make the exe and load it in another PC where there is no Vb, access and crsystal reports 8.0 , i get the error message
"Run time error 20534: Error detected by database dll"
how to recover from this error
please help
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
CrazyOne
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q246167
http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr_general_sql_server_error.pdf
Error: 20534 "Error detected by database DLL"
when using an alias
Symptom
A report is created off a Microsoft SQL Server database and is previewed at
runtime using the Crystal Report Engine Automation Server (Cpeaut32.dll 32-
bit, Cpeaut16.dll 16-bit).
The location of the table is set to a temporary table using the 'Location' property
of the 'DatabaseTable' object. When the report is previewed the following errors
occur:
General SQL Server Error: Check messages from SQL Server
<followed by>
Runtime error 20534
Error detected by database DLL
The syntax of the 'Location' property for setting the table location is correct. The
temporary table has the same structure as the original and the location of the
temp table is fully qualified.
For example:
'pubs = the database
'joe = the owner
'table1 = the table
Report.Database.Tables(1).
Resolution
The error occurs due to the owner of the temporary table being an alias of the
default owner. For example, if the default owner were 'dbo', then to resolve the
error, you would specify the default database owner when setting the 'Location'
property:
'pubs = the database
'dbo = the owner
'table1 = the table
Report.Database.Tables(1).
An alias is a database username that is shared by several login IDs. An alias
allows you to treat more than one person as the same user inside a database,
giving all of them the same permissions. A common use for aliases is to allow
several users to assume the role of database owner (DBO).
Creating a table under an alias does not make the alias the owner of the table.
For more information on changing the database and table location for a SQL
database at runtime please refer to Knowledge Base articles C2001075 and
C2000957. These can be found at http://support.crystaldecisions.com/kbase
Previous Article ID: c2002269
Error: 20534 "Error detected by database DLL"
when using an alias
Symptom
A report is created off a Microsoft SQL Server database and is previewed at
runtime using the Crystal Report Engine Automation Server (Cpeaut32.dll 32-
bit, Cpeaut16.dll 16-bit).
The location of the table is set to a temporary table using the 'Location' property
of the 'DatabaseTable' object. When the report is previewed the following errors
occur:
General SQL Server Error: Check messages from SQL Server
<followed by>
Runtime error 20534
Error detected by database DLL
The syntax of the 'Location' property for setting the table location is correct. The
temporary table has the same structure as the original and the location of the
temp table is fully qualified.
For example:
'pubs = the database
'joe = the owner
'table1 = the table
Report.Database.Tables(1).
Resolution
The error occurs due to the owner of the temporary table being an alias of the
default owner. For example, if the default owner were 'dbo', then to resolve the
error, you would specify the default database owner when setting the 'Location'
property:
'pubs = the database
'dbo = the owner
'table1 = the table
Report.Database.Tables(1).
An alias is a database username that is shared by several login IDs. An alias
allows you to treat more than one person as the same user inside a database,
giving all of them the same permissions. A common use for aliases is to allow
several users to assume the role of database owner (DBO).
Creating a table under an alias does not make the alias the owner of the table.
For more information on changing the database and table location for a SQL
database at runtime please refer to Knowledge Base articles C2001075 and
C2000957. These can be found at http://support.crystaldecisions.com/kbase
Previous Article ID: c2002269
http://www.wizard-net.com/faq/general.html#10
When generating reports I get the following error '20500 "Not Enough Memory For Operation"' or 20534 'Error detected by database DLL'.
Why does this occur?
This typically occurs when there are multiple Microsoft Database System files found on the system.
How do I fix it?
Download and install the Seagate Crystal Reports Secured Database Registry Utility. Follow the instructions found on the download page.
When generating reports I get the following error '20500 "Not Enough Memory For Operation"' or 20534 'Error detected by database DLL'.
Why does this occur?
This typically occurs when there are multiple Microsoft Database System files found on the system.
How do I fix it?
Download and install the Seagate Crystal Reports Secured Database Registry Utility. Follow the instructions found on the download page.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned. I will make a recommendation to the moderators on its resolution in approximately one week. I would appreciate any comments by the experts that would help me in making a recommendation.
It is assumed that any participant not responding to this request is no longer interested in its final deposition.
If the asker does not know how to close the question, the options are here:
https://www.experts-exchange.com/help.jsp#hs5
MusicMan
EE Cleanup Volunteer
It is assumed that any participant not responding to this request is no longer interested in its final deposition.
If the asker does not know how to close the question, the options are here:
https://www.experts-exchange.com/help.jsp#hs5
MusicMan
EE Cleanup Volunteer
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:
Split: CrazyOne {http:#8493774} & iozturk {http:#8497115}
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
MusicMan
EE Cleanup Volunteer
I will leave the following recommendation for this question in the Cleanup topic area:
Split: CrazyOne {http:#8493774} & iozturk {http:#8497115}
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
MusicMan
EE Cleanup Volunteer