I am having issues with my OE 10.1C database and creation of an SQL DBA user. This is for QAD's EAM report user eamrpt. I performed the following functions using sqlexp on Linux as root (the db creator):
create user 'eamrpt','eamrpt';
commit;
grant dba to eamrpt;
commit;
quit
After...
I have attempted to look at the Progress web site for a list of Open Edge products and have not found any useful information. I am probably not looking in the right area. What I wish to find out is if Open Edge was any products that are similar in content to the ProVision product of the past...
I have had to upgrade my Java to a newer version (from 1.5 to 1.6). This was to fix an issue where I was getting an error with native2ascii class. Now I need to point my Progress OE 10.1C04 environment to the new Java. I would rather not perform a reinstall of Progress to achieve this. What...
I have made the necessary changes to my development and test environments to have 4GL and SQL only servers running. The next time I have to do a restore of production to either of these environments, I will see if I continue to get broker rejections when the database and the subsequent SQL...
I was in the process of creating new services for my test environment (SQL only) from another question I placed out here. As a result of this, the connection now works. Also, I realize that I went to the wrong forum.
Please disregard!
I am getting this log info for a broker rejection. This is after a restore of our test environment from production.
[2010/11/24@08:03:09.486-0500] P-27921 T-0 I BROKER 0: (1055) Server's eceived count 1 does not equal client(1)'s send count 16777216.
We will periodically update our test...
I was being facetious. That fact is that prior to going to Open Edge, we were not using ODBC. The intorduction of ODBC caused us to have to create a user id in the database. Once this happened, we lost the ability to let the OS provide the userid. The blank user id created challenges for us...
Okay...
How can I "break" this for all of my other databases? I only need the ODBC connection to read data (which must be different from retrieving data since I am not having a bunch of angry shipping people yelling at me that they can't ship). I really hate the fact that I do not see the user...
I did not check the _user records, but I find that the SQL user is gone! Yet, I am still making an ODBC connection to the database with a user id! How can this be?
In one of my import issues, the file generated is an xml file coming from Oracle. The encoding for this file is ISO-8859-1. My Progress database is iso8859-1. Could the slight difference in the naming of the code page be a possible point here? If so, can I get Progress to recognize the...
So sorry!
It has been some time since I looked at the issue and forgot the main thrust of the user identity. The actual problem is that we added a user for SQL, which caused all users (OS) to be blank. Then, for some reason, the users started showing up again, even though the SQL user is still...
Okay...
I am now starting a separate broker for my ODBC connections. I login using the 4GL server and check promon; still no user id shows up. This is really the crux of my original post, but I do agree that I needed to take the steps to have a separate SQL port for those user types.
Any...
Hello,
We have had a long standing issue with importing data into our Progress database (OE and earlier).
When we bring the text in, the special characters do not transfer. We have the ability to view these characters in our ERP system, but when we try to import characters of this type, we get...
I am having a great deal of difficulty with OE! Our upgrade to OE included the need to create SQL users for ODBC connectivity. The initial impact of this was that promon did not show the users name, so disconnecting a user session on the OS (linux) required more work. Then, all of sudden, on...
Is not the knowledge of RealHeavyDude all encompassing? LOL
The version of Progress is OE10.1C. In terms of the error message, there was no associated number just the message in a warning box prefixed by the ODBC connection info, [DataDirect][ODBC Progress OpenEdge Wire Protocol...
I have narrowed it down to an issue with my jpg conversion, i think. i have an app that generates the barcode as a GIF and I am using convert to make my jpg file. The reason I suspect the conversion is that I tried to convert some text to go beneath the barcode and it was messed up as well...
This leads me to a more confused state.
How did this happen?
How come my existing ODBC client can still connect using the missing _User account?
Is some process out there still connected that will one day end and I will, all of a sudden have no ODBC connectivity?
I have an issue that needs clarification.
I have SQL setup on a test database. For some reason, it started rejecting SQL connections. This database is a restore of our production system each Saturday. I am not sure if it was the restore that caused the issue or it was something else.
Any...
I have seme weird behavior with local vs. ODBC connections to my OE 10.1C database.
When we updated to OE we had to add a user to the database for an ODBC connection. Previously we were using OpenLink, which did not require us to have a user login. This caused us quite a bit of trouble as...
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.