Recent content by JJames100

Also, the client_id = part of the where clause worked whether I put it at the end or included it in the second select instead.

Got the whole thing to work by removing the ) and its matching (, before the 'Is Null'

Also got the following to work which contains a where clause (if I remove the part of the stmt starting with 'AND' at the end. Evidently, the 'is null' is causing it to have an error) SELECT qryClientFromSC.client_id, Pub.pt_program.program_id, Pub.pt_program.program_seq...

I was having a similiar problem trying to run a pass-through query via Access to a Progress DB. I was able to run the following query after much trial/effort: SELECT pub.client.client_id, pub.client.first_name, MyStaff.date_of_hire FROM Pub.Client inner join (select * from pub.staff) MyStaff...

We don't have any new processes that would affect running either at night or during day. We did get new terminal server servers (more processing power, etc). However,this problem started just before these were put into use and continued thereafter. The query now takes 30 minutes on 3 of them...

Reason for interest: we have a system (from vendor), based on a Progress database which is set up for replication. Their 'hyperbase' (don't know if this is a Progress term or just the name of the DB) gets refreshed with new client data around 3AM from the main Progress DB. This process used to...

Were you able to get any answers to this? Interested in knowing about.

Re: linked Progress query (from SQL Server), that uses parameters -- trouble with da To use in SQL Server stored proc had to change as follows (otherwise got error about converting from date to string): select h.client_id,h.PtName,h.team_ID...

Re: linked Progress query (from SQL Server), that uses parameters -- trouble with da I got it to work ...this string which is encased in variable ...: 'select h.client_id,h.PtName,h.team_ID,h.date_of_change,h.HistoryEvent,h.new_data,h.Program_Status, h.pt_History_ID from...

Re: linked Progress query (from SQL Server), that uses parameters -- trouble with da thanks for the reply. This isn't working. Date is not recognized by SQL Server as a valid function - - and I am already declaring these as datetime My guess is that the variable is not getting converted in...

:confused: I'm having problems executing the following in SQL Server. I'm using a linked Progress DB with link name SCPROD and also using OPENQUERY, but must enclose stmt in string, so can pass params into: declare @DateBegin datetime declare @DateEnd datetime DECLARE @TSQL varchar(8000)...

Found the cause of - see details below I had a subquery with multiple where conditions. ONE of them was: "where field = 9". This query when run, worked fine. However, when I changed it to "field = 9 or 16", while it still ran fine by itself, it was producing the above error when called as a...

I could use some help with an error I'm getting when trying to run a query from Access which is linked to a Progress database. :confused: getting message: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Internal error0 (unknown sql92 error) in SQL from subsystem SQL92...

I am using the administrator utility to set up an ODBC connection from a Windows XP machine to a server running Windows Server Enterprise Edition 2003 that the Progress database is installed on.

I would REALLY appreciate help on this! Has there been any resolution to this? I have installed the progress client for 9.1E and am getting the "invalid attribute in connection"..."database not started" error msg (after a long wait), when testing the connection :confused: