Skip to Content
0
Former Member
Apr 08, 2009 at 08:14 PM

LogonServer Message with XML Datasource

47 Views

Afternoon all.

I'm making a ODBC connection to an XML file using a CR ODCB XML 5.3 driver (crdb_odbc.dll). The process (which is being run from a handheld scanner) is basically this: create an XML file with the data I want to see on my report, programmatically connect to the XML file, open the report, print it, create a PDF file of the report just printed, close everything, and delete the XML file.

It works perfectly, everything seems to be printing correctly, but I am getting a LogonServer error in my server log occassionally when I'm accessing this XML file.

I've actually got two different XML files being accessed from two different reports, both of which are accessed in succession. Whenever the LogonServer message occurs, it occurs for both reports. It does not occur for just one report or the other.

My initial thoughts on this dealt with some connectivity issues due to the handheld. It tries to make the connection, can't and creates the LogonServer message. It sits there until it can make a connection, and then creates the report / PDF and continues on like nothing happened, other then the error message.

Is this something that can be experienced due to connectivitiy errors or is it another issue that I'm not thinking of? I am just using a blank username / password combination, as I thought that could be the cause, but it seems to work correctly the majority of the time.

Connection code (Progress 4GL)

/* Define the DSN name here */

DSN = "BOL".

...

chCrystalRep = chCrystalApp:OpenReport(cStartDirectory + "BOL.rpt",1).

chCrystalTab = chCrystalRep:DATABASE:Tables(1).

chCrystalTab:ConnectionProperties:ITEM("DSN") = DSN.

chCrystalApp:LogOnServer("CRDB_ODBC.DLL",

DSN,

"",

"",

" ").

Error:

(Procedure: 'LoadReport mmtra/mmtra101ps.r' Line:206) Error occurred while accessing component property/method: LogOnServer.

(Procedure: 'LoadReport mmtra/mmtra101ps.r' Line:206) Exception occurred.

(Procedure: 'LoadReport mmtra/mmtra101ps.r' Line:206) Error code: 0x80020009 LoadReport mmtra/mmtra101ps.r (5890)