Hey all,
We have a problem with out reports taking much longer then they should to run. So the plan is to get rid of the reports and replace then with SQL Views instead and present the views to the users. Anyway I'm trying to set up an ODBC Connection to the our OpenEdge 10.0 database that will allow us to create the views we want to create.
I've set up an ODBC connection to the database but I'm getting an error with the following progress code (7512). I've looked up the error and it say the following for a fix:
"1) Open the SQL Explorer and connect as 'sysprogress' (no password)
2) Grant DBA privilege to the desired user:
GRANT DBA TO 'user';
COMMIT;
The drawback is that anybody can use this user account (or sysprogress) in order to delete/modify any SQL92 objects (tables, indexes, ...) or modify the SQL92 privileges (creating new DBA user with password)."
Following the steps listed above, I'm told that I can't connect to the database using the Administrator account in SQL Explorer because my username and password as incorrect. I'm using the correct username and password for the database, since its the same username and password that I use to start, stop, backup, whatever for the database. Can anyone help me figure out what I'm doing wrong trying to get the ODBC Connection working properly. I'm some what of a NEWBIE when it comes to Progress/OpenEdge 10.0b05. I mean in SQL Server I could have the ODBC Connection, Users and Rights assigned in about 5 mins. But here it just seems like I'm running in circles and not getting anywhere quick. Any help that you can provide would be greatly apprecaited.
Thanks,
Pete J.
We have a problem with out reports taking much longer then they should to run. So the plan is to get rid of the reports and replace then with SQL Views instead and present the views to the users. Anyway I'm trying to set up an ODBC Connection to the our OpenEdge 10.0 database that will allow us to create the views we want to create.
I've set up an ODBC connection to the database but I'm getting an error with the following progress code (7512). I've looked up the error and it say the following for a fix:
"1) Open the SQL Explorer and connect as 'sysprogress' (no password)
2) Grant DBA privilege to the desired user:
GRANT DBA TO 'user';
COMMIT;
The drawback is that anybody can use this user account (or sysprogress) in order to delete/modify any SQL92 objects (tables, indexes, ...) or modify the SQL92 privileges (creating new DBA user with password)."
Following the steps listed above, I'm told that I can't connect to the database using the Administrator account in SQL Explorer because my username and password as incorrect. I'm using the correct username and password for the database, since its the same username and password that I use to start, stop, backup, whatever for the database. Can anyone help me figure out what I'm doing wrong trying to get the ODBC Connection working properly. I'm some what of a NEWBIE when it comes to Progress/OpenEdge 10.0b05. I mean in SQL Server I could have the ODBC Connection, Users and Rights assigned in about 5 mins. But here it just seems like I'm running in circles and not getting anywhere quick. Any help that you can provide would be greatly apprecaited.
Thanks,
Pete J.