Search results

It there a simple way (though ODBC and SQL) to grant select to a specific user? There are 147 tables and I do not want to GRANT SELECT ON table1 TO 'mrme' a hundred and 127 time ( I will have to revoke access to about 20 HR tables) I can script something but it seem like a wast for only one...

I found a spreadsheet on oehive: with the title: "Secondary broker parameter spreadsheet" @ http://www.oehive.org/files/DBparamsOEHIVE.xls this tells me the only three parameters I need to start my secondary broker are: +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -m3 -ServerType...

Is it OK to update eclipse that the OE runs on? How about loading other plugins? Thanks in advance

P 9.1E O/S Windows XP SP3 DB on SLES 10 These screen shots are from Progress version 9.1E ISSUE: Screen spaces crazy when not in V6Display mode. The only change between the 2 images was V6Display=yes changed to V6Display=no in the .ini file. We have not been able to figure out the settings...

I moved part of this from Database Admin, yes I know bad boy, but I need some help. Thanks ... Long story short, I came to work here after the install, and I am new to Progress I need to see the switches on some files, but when I expand per...

Sorry if this is in the wrong spot, it seemed like the spot because these are DB admin user type files. This KB tells me to look at the source to find the switches. if there is another place to find them that would work just as well. here is where I gained part of my information...

I was given a procedure that has me use _progress mydb -pf /home/prousr/pf/mydb.pf then it gives me the steps to load the data definitions by loading the dot df files within the text interface. Is there a way (program) in progress that will do the same thing without a text interface? a quick...

I got my environments set up and running in 20 days, but this wasn't my victory. THANKS!!! for all of the help from everyone. This is a great set of forums and the people are helpful. Yes now for the hard part but I assume I will get as much help in the future as I have had in the past. I...

I am calling a second broker to enable the SQL servertype: /usr/dlc/bin/proserve -pf /users/dev/db/mffg1SQL.pf When I call this I receive an error about an -e argument. I cannot find a -e anything within the documents (there is a -E but that is for European numbers) this is the error...

I can start the second broker manually. I have a script that starts the database and the primary broker (anyway that is what I think it does). It is a dot PF file. it looks like this: #++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ # # SESSION,Session-related parameters...

Not enough sleep I guess, I need schema help, I would like to automate some importing to the progress database. What I need is a way to get any specific table's fields and data-types. I found the _tables and _fields files but there doesn't seem to be a way to tie them together (I know that...

A question I cannot find in the Docs or KB: DBs, can ones, on the same server, have the same name but different IPs I need to setup a development database, I would like to use the same names that are in production, I was wondering if I can specify the IP address for the dev DBs? They will be...

OK so I tried to use the OE explorer, it failed to let me login, I used the creator database UID (root) and PW still wouldn't let me in to the Admin Server. Does the Admin Server have a name? Does the proadsv need to be running (I assume yes)? I didn't get to set up this environment so how...

I am trying to connect to proadsv from a windows proexp12 application. I tried both the creators UID and the SYSPROGRESS (both cap and lower) the actual PW of the creators ID and a "fake" and the sysprogress with a space, blank and a fake password. I am not sure where to go from here. The...

Now that I have 5 days of progress under my belt, whats next? Any one have suggestions for tutorials or books? Thanks ... JustMe

Newbie, on progress day 4 continued ... (Is this SQL or DB problem?, should it be moved to DB forum?) The version is 10.2b 05 I am running eclipse on windows XP servicepack 3 (Admin programs also) The database is running on SLES11 linux After setting up a second broker for SQL only I...

and I cannot type: "Eye Dee Ten Tee problem" Still a newbie, day 4 ... The version is 10.2b 05 I am running eclipse on windows XP servicepack 3 (Admin programs also) The database is running on SLES11 linux I need a second broker for SQL-92 access. I found a knowledge base to add a...

I am new to progress and the progress database. We do not seem to have security turned on in the database yet (one of my many new tasks) but the OE when connected will not let me do queries against the databases. I created the connection and can see the database, tables, indexes etc …...