Error Detected By Database Dll Crystal Reports 8.5
your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 7 of 7 Thread: "Error detected by database DLL" Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode May 19th, 2003,02:45 PM #1 sandra View Profile View Forum Posts Thread Starter Lively Member Join Date Apr 2001 Location Lebanon Posts 90 "Error detected by database DLL" Hi all, here's my problem: I have my VB program (the executable) on a server, and shortcuts to this file on the clients pc's. My reports are all in a folder on the server (they are designed using Crystal reports v8.5) When I try to run my program from the server, everything works fine. When I run my program from the client pc's everything also works fine, except for the reports. They aren't appearing in the screen and instead I get an error message: "Error Detected by Database DLL" (or smthg like that) I thought maybe it's because on the server I have Crystal Report installed. So I tried to install it on the client PC, but I get the same message. Please help me. What can I do? What's causing this problem? Thank you all Reply With Quote May 20th, 2003,01:45 PM #2 Pasvorto View Profile View Forum Posts Visit Homepage PowerPoster Join Date Oct 2002 Location Minnesota, USA Posts 2,951 Can you run the report manually from the client? Is the db password protected? If so, you must supply the necessary login data: Set Report = crxApplication.OpenReport("Y:\DAD\QCInspectionOut.rpt", 1) For Each crxDatabaseTable In Report.Database.Tables If UCase(crxDatabaseTable.Name) = "TMPQC1" Or UCase(crxDatabaseTable.Name) = "TMPQC17" Or UCase(crxDatabaseTable.Name) = "TMPQC25" Or UCase(crxDatabaseTable.Name) = "TMPQC33" Or UCase(crxDatabaseTable.Name) = "TMPQC41" Or UCase(crxDatabaseTable.Name) = "TMPQC9" Or UCase(crxDatabaseTable.Name) = "TMPQCINSPOUT" Then crxDatabaseTable.LOCATION = "Y:\DAD\Temporary.mdb" Else crxDatabaseTable.SetLogOnInfo "", "", "", "password-here" crxDatabaseTable.LOCATION = "Y:\DAD\Techni.mdb" End If Next crxDatabaseTable Report.SelectPrinter glbPrinterDriver, glbPrinterName, glbPrinterPort If glbPrinterDestination = 0 Then glbReportForm = "frmQCInspectionOut" CRViewer.Show vbModal Else Report.PrintOut False End If As an example. Reply With Quote May 21st, 2003,03:03 PM #3 sandra Vi
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Error detected by database dll Want to Advertise Here? Solved Error detected by database http://www.vbforums.com/showthread.php?245804-quot-Error-detected-by-database-DLL-quot dll Posted on 2003-05-08 Miscellaneous 2 Verified Solutions 8 Comments 29,685 Views Last Modified: 2011-08-24 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 , https://www.experts-exchange.com/questions/20610835/Error-detected-by-database-dll.html i get the error message "Run time error 20534: Error detected by database dll" how to recover from this error please help 0 Question by:harbinderss Facebook Twitter LinkedIn Google LVL 44 Best Solution byCrazyOne http://community.crystaldecisions.com/library/kbase/articles/c2009179.asp Err Msg: "20534: Error detected by database DLL" with Visual Basic 6 SP3 The information in the article refers to: Crystal Go to Solution 7 Comments LVL 44 Overall: Level 44 Miscellaneous 5 Message Accepted Solution by:CrazyOne2003-05-08 http://community.crystaldecisions.com/library/kbase/articles/c2009179.asp Err Msg: "20534: Error detected by database DLL" with Visual Basic 6 SP3 The information in the article refers to: Crystal Reports 8.5 Applies to: Reported version and lower Crystal ActiveX (OCX) Control ODBC connection to a text file Error "20534: Error detected by database DLL" Synopsis A Microsoft Visual Basic application uses the Crystal Reports OCX control (crystl32.ocx) as the reporting development tool. A Crystal Report is created using Microsoft's ODBC driver for text files. When attempting to preview the report in Microsoft Visual Basic, the fo
also some querying tips in SQL and typical source codes which might be useful shared here. HOME My Profile # . LANGUAGER'S LABORATORY Error detected by database http://programmerslab.blogspot.com/2009/07/error-detected-by-database-dll.html DLL Posted on Thursday, July 23, 2009 comments (5) Labels: Crystal Report Error : Error detected by database DLLThis error occurs when trying to open report produced using Crystal Report in application, one of which is application developed using VB.Solution :1. If you are using ODBC, make sure the ODBC has been created.Here are the steps to create ODBC for the connection to the database, press error detected Window + Run, then type "ODBCAD32" (without quotes). Then, on the User DSN tab, press Add.A dialog box will be shown:Click the Add button and choose SQL Server.Insert the name of the database and server.Next, if you're using SQL Server authentication, insert the login ID and password; otherwise, choose Windows Authentication.2. If you've created the ODBC in User DSN tab, and still get the error, error detected by try doing step 1 again for the System DSN tab while creating the ODBC.3. If still, it does not work, check the query used in your report, and make sure the stored procedure used in the report (in case you are using stored procedure) has been granted for the application itself. This is sometimes forgotten by developer ^^To grant the stored procedure to the database user used in the application:grant exec on spr_spname to database_user_name 5 comments: batu permata said... April 15, 2010 at 10:31 AM This is sometimes forgotten by developer ^^To grant the stored procedure to the database user used in the application: Steven Luck said... April 17, 2010 at 10:40 PM Yeah... hehehe, it is easily forgotten, especially by developer. In deployment, it should be a more-common issue ^^ Anonymous said... March 9, 2011 at 4:08 PM Thanks man, your solution helped me - I've been struggling with this problem the whole day.I forgot to grant permissions on the stored procedure to the db user Steven Luck said... March 9, 2011 at 4:29 PM You're welcome. Glad to hear it helps :) Miguel Cajas said... February 21, 2