Search results

Thanks Vinod , I actually tried it that way and worked my way up. Its now working. Sorry , In my 1st post, I mis-spelled the vm-sold field as vmsold. The working query is : Select "vm-sold" from pub."vhmast" where "vm-sold" = 0 :blush: Thanks everyone. Zak

Hi Casper , Thanks for the suggestion. No joy though - I get a syntax error. Regards Zak

Hi All , Can you please provide some insight to this problem. We finally got our odbc connection working. Thanks to Caper and gang for all your help. Im receiving an error from the reporting app when I try to run queries, Ive tried various formats but this is basically my query : SELECT...

Casper, youre a legend! thanks :) quick question then im out of your hair .... is the OIbroker the same as the secondary broker I already have started ? Thanks :blush:

Hi Casper , Oh yeh , sorry .... Yes it is Sco openserver 5.0.7 . So are you saying its hopeless ?? What are my options then ? Thanks Zak

Hi again , Our software vendor, has sent me a Progress 9.1E sp4 update in an attempt to see if we can get pass this problem. Can you please point me in the direction for some information on updating the sp4 on unix - or is it a case of just copying over the files into the relevant directories...

Hi again, The Sco Unix server shuts down. it does a memory dump and I have to physically restart the server. the server is not running java at all. I am accessing the Unix server via a windows XP pc with Progress installed and configured. Ive tried connecting via Sql explorer. i wasnt sure...

Hi again guys. Having a bit of a problem. Im not sure if its the ODBC driver or the application. As soon as I try to view the tables via the reporting app - i get an " unexptected kernel trap " on the unix server. the server then shuts down. Any idea ? :confused: Thanks!

Hi Casper , Sorry for the laste reply. Went on a short vacation. Thanks anyway. The parameters are working excellently. I used to have messages saying insufficient resources previously when I had the 2nd broker running. but so far thereve been none. Regards Zakaria

Hi Casper, Thanks youve been a great help. Beginning to make some sense now. I am actually going on leave from today onwards & will give it a shot when I get back. Thanks again for your help Regards

Hi Casper , Thanks for the quick reply. .. The primary broker : Maximum number of clients per server (-Ma): 14 Delay of before-image flush (-Mf): 3 Maximum number of servers (-Mn): 5 Maximum number of users (-n): 71 No -Mi or -Mpb set on the primary broker...

Hi There , Ive followed Casper's instructions in setting up a secondary broker for ODBC connections. ie: set up a second PF file , and start with proserve -pf "2nd file" . It works beautifully when all the users are logged off. During the day we have about 52-54 users logged on. -n is set to...