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...
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:
I have found from using ODBC to make queries against Progress from Access, that I have to :
1. make sure I include all the fields that are part of the primary key - even if I don't need them in the query.
2. know how the Progress fields have been defined in terms of length - I am working...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.