Palo Community Forum

Hi,
maybe by fireing a shell command. You can get server version by using

palo -V in commandshell. (change the directory to palo dir first)
(capital v)


Holger

I thought piping it to a file and reading this would work but somehow it doesn't.

You can use a PALO http api function

like

http://localhost:7778/server/info?sid=0000&

enter http://localhost:7778/ for http api documentaion

To see that in the browser add line
admin "127.0.0.1" 7778 to ini file and restart PALO service.


By declaring and using some API functions (wininet.dll) you can read it and put it into a variable. But a PALO.xxx command for use in excel would be better :-) Maybe something for the wishlist.

Or use this one but thats pretty dirty:

Sub dumpVersion()

Dim ver As String
Dim wb As Workbook

Application.ScreenUpdating = False

Set wb = Workbooks.Open("http://localhost:7778/server/info?sid=0000&")
ver = wb.Sheets(1).Cells(1, 1)
wb.Close
ThisWorkbook.Activate
Application.ScreenUpdating = True
MsgBox ver


End Sub

Its returns the result of the PALO API call mentioned above like:

2;5;0;3625;0;0

First value is major version second is minor version .... see details in http API documentation.



Or maybe some more ideas?


Holger