I'm having problems printing a report from my Xojo application, using a Vserver.
I have licensed versions of VStudio Pro 13.3.3, VServer 13.3, and the Xojo/RealBasic ADK, all running on Linux (Ubuntu 22.4) [ all from the OmegaBundle 2023]. I have successfully developed a project ("femstest" and report ("Report_Offer" on the Vserver. The datasource is a MSSQL database on another machine. When I preview the report in VStudio, I get the expected report output. Now, I'm trying to print this same report from within my Xojo Web (Version 2023.1.1) application. I followed the steps shown in the Xojo ADK installation video. Here is my Xojo code behind the "print" button (it's basically Valentina's example code):

try

  

  'Open Connection

  Var conn as VConnection = new VConnection("10.0.0.120", "sa", "sa")

  conn.Open

  

  ' Open Project From VServer

  Var projPath As FolderItem = GetFolderItem("femstest.vsp")

  Var proj As VProject = new VProject(conn, projPath)

  

  ' Print Report into PDF

  Var datasource as string = "mssql://host = '10.0.0.117' port = '1433' dbname = 'eios' user = 'eios' password = 'eios' timeout='10' datalimit='65535' "

  Var query as String = "SELECT * FROM Event"

  var report as VReport = proj.MakeNewReport("Report_Offer", datasource, query)

  Var data as String = report.PrintToBuffer(EVReportPrintType.kToPDF, 1)

  

  ' Prepare file for download

  Self.PDF = new WebFile

  Self.PDF.mimetype = "application/pdf"

  Self.PDF.FileName = "report.pdf"

  Self.PDF.ForceDownload = FALSE

  Self.PDF.Data = data

  

  ' Close Project and Connection

  proj.Close

  conn.Close

  

  ' Show PDF in Browser

  GotoURL(Self.PDF.URL)

  

Exception err as VException

  Var errNumber as Integer = err.ErrorNumber

  Var errString as String = err.Message

End

The VServer log indicates that I successfully connect from my application to the VServer. The MSSQL datasource string is copied from the VStudio Schema Editor. I have no problem connecting to this MSSQL database from VStudio (and other tools) running on the same machine as my application. There isn't a firewall issue.

The VException error message I'm getting is: Error Number: 365829 - File "%S" is not open. The error occurs on the line "var report as VReport = proj.MakeNewReport("Report_Offer", datasource, query)".

I'm missing something simple here and any help or guidance is appreciated. Thank you.