Search results

Think Progress don't think SQL This works for me: select pt_part Label "My Part" from pt_mstr

We use openlink (fancy ODBC) and with that Progress is a linked server in MS SQL.

SAP = May You Live in Interesting Times Your whole company is going to be turned upside down and loads of stuff won't work. Time for a new IT Hero to come to the fore.

Progress V8 QUE ISBN 0-7897-0493-5 I got mine on ebay for £0.39

Work Round We had similar problems here and ODBC always crashed as well :( What we done was run CSV extracts every night from progress then used DTS to import the extracts. This has been working fine for well over a year.

I always use INSERT into Table SELECT * from table2 or INSERT TableDes ( a, b, c) SELECT a, b, sum(c) from TableSrc Where f = 'City' group by a, b The trick I do is build a workable select statement then place a INSERT at the top of it.

I all depends on your firewall. Some firewalls don't allow any traffic between DMZ and Trusted. You may well have to setup routing as well and have al local address on your DMZ that routes (NATS) to trusted network. Exposing your live db to your DMZ means that your risking exposing your DB...

Eek !! Cheer up guys Some folk would kill for a steady job with good money. Retrain, climb large mountains, try and build a time machine in your garage, or start someother off the wall project and get your love of life back.

Just saying hello as I'm new to Progress and glad I've found this site :)