Search results

I can tell you how to do it in SX.e 5.6.063, which might be similar (SX.e is a descendant of NxTrend) In OEET, select File, then Copy/PD. Key in the order number of the quote you wish to convert, then select what type of order you want to convert it to (probably Delivered Order), and click...

I'm sure I've used hashes before successfully, but I think have found the problem - it should be TO_DATE('mm/dd/yyyy').

Hi all. I am running SX.e 5.6.063 with country pack 1.4.063, on version 9.1e (please, no flames about the version!). I am trying to do a query via VBA for MS Access 2000. This query works: SELECT oeeh.orderno AS orderno, oeeh.ordersuf AS ordersuf, oeeh.transtype AS transtype, oeel.shipprod AS...

Hi RHD, we use ODBC all day every day. Yes, performance is shoddy at best, but upgrading Progress is out of my reach at the moment. I've just been trialing an alternative way to deal with the problem, and that seems to be working fine, so I will bow out of this discussion and say thanks to you all.

I wish I'd kept a record, what I can remember is dim con set con=CreateObject("ADODB.Connection") con.Connection = "DSN=livesxe;UID=xxx;PWD=xxx" con.Open dim con set con=CreateObject("ADODB.Connection") con.Open "DSN=livesxe;UID=xxx;PWD=xxx" but I tried a number of other variation on this...

Hi all, I am trying to connect to Progress 9.1E in VBScript, and have tried countless connection string variations I've found, and just randomly tried, but in all cases I have had no success. Can anyone help me with it, please?

Can I confirm you understand that I have 4 different dlc locations?

Yeah, thank you I have that. If I ever need to run dbtool against one of the other databases, am I going to hit the problem that it will look to the instance of /lib referenced in this path? If so can I "un" set it?

I'm in and running. Had to set the library path, which I must admit I wasn't 100% keen on doing, but it happening, so I am very pleased. Thanks everyone for all your help.

JustMe - or should that be JustYou? - you are being very patient with me here, but, where is the path statement? Do you mean cd /app/newver/rd/dlc/bin dbtool nvernxt /app/newver/rd/dlc/lib I'm not a Unix man, I've just been passed a job no one else wants!

I'm not 100% sure I understand, so here goes: My db is in /app/newver/db The path to the dlc is /app/newver/rd/dlc In this folder /lib/librocket_r.so and /bin/dbtool are there. Do you mean I run: dbtool /app/newver/rd/dlc/bin/dbtool /app/newver/db/nvernxt I just am struggling to see how...

by "the call" do you mean "what are you typing into the command line"? If so, just: dbtool nvernxt

Afternoon, apologies for all the questions at the moment, but I am on a bit of a Progress Admin mission. I am trying to run dbtools against a test environment, in order do a straight import into SQL Server 2005. From what I've read, it's an idea to run it occasionally anyway, although I don't...

Tom, In looking for the install location, am I looking for the dlc folder? If so, I have /app/live/rd/dlc (and indeed, running cat dlc/version from /app/live/rd gave me "PROGRESS Version 9.1E04" as the version number). Would you instruction translate in my environment to typing...

Hi everyone, I hope I am not missing something in my search, but I have tried to find straight instructions within the forum and elsewhere on how to perform a Dump and Reload, with no luck. I am running SX.enterprise 5.6.063, Progress 9.1E (and I am aware I should upgrade - technically, I...

Hi, We've been using SX.e 5.6.063 with a few bits of custom code for 4 1/2 years. Most users only ever see the GUI, only I have ever accessed the ChUI. For Invoice Matching, we've always used APET, but an opportunity has come up for a semi-automated Supplier Invoice process at a reasonable...

Sensible advisce, thank you!

Great, thanks for the info. The $DLC thing is a bit worrying - I'll see if I can find anything on that... I'd rather point the backup directly to the alternate server, since I would be looking to do a daily backup, but I'm sure google can tell me how to point to a network server on the command...

Unfortunately, this installation must not follow accepted standard, since "version" is not a recognised directory name at the root directory. I'm struggling to find it at t he moment, but I'm sure I can sort that out another way. Basically, I have no idea where to start with probkup. I presume...

Ok, thanks!