StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POCode to generate Crystal Reports report works fine in CLI, but "Data source name not found" when accessed from browser
text
Body
copied!<p>I'm trying to generate a report from PHP, using Crystal Reports, The code seems to be correct:</p> <pre><code><?php set_time_limit(0); if(isset($_GET['id'])) { $id = $_GET['id']; } else { die('Please specify an ID'); } $path = "c:\\wamp\\www\\billing\\reports"; $file = $chemin."\\bill_".$id.".pdf"; $app_obj = new COM("CrystalRuntime.Application") or Die ("Did not open"); $report= $path."\\bill.rpt"; $rpt_obj= $app_obj->OpenReport($report,1); $app_obj->LogOnServer("p2ssql.dll","host","bdd","userbd","passwordbd"); $rpt_obj->EnableParameterPrompting = FALSE; $rpt_obj->RecordSelectionFormula = "{F_DOCLIGNE.DO_Piece}='$id'"; $rpt_obj->ExportOptions->DiskFileName = $file; $rpt_obj->ExportOptions->PDFExportAllPages = true; $rpt_obj->ExportOptions->DestinationType = 1; $rpt_obj->ExportOptions->FormatType = 31; $rpt_obj->Export(false); header("Content-Type: application/pdf"); readfile($file); ?> </code></pre> <p>If I run the script from command line, it works just fine, and I have the PDF exported and parsed in the console.</p> <p>But from a browser's point of view, the story is different, If you get the request through Apache, I get this exception :</p> <pre><code>com_exception: Source: Crystal Reports ActiveX Designer Details : IM002:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified in C:\wamp\www\facture\report.php on line 25 </code></pre> <p>On the report, the database connection is made through ODBC, I couldn't use that, as any other driver, marked with ODBC refused to work.</p> <hr>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload