J
Jyothi Sundaragiri
Guest
I have created a copy of sports2000 database and created a sysprogress user using a ABL procedure file. Procedure file contains: ---------------------------------- RUN createSQLDBA. MESSAGE "Finished adding SQL DBA user SYSPROGRESS.". PROCEDURE createSQLDBA: /* Create a user named sysprogress with SQL DBA privs */ CREATE _User. ASSIGN _User._Userid = "sysprogress" _User._Password = encode("xxx") _User._Domain-Name = "" _User._User-Name = "sysprogress" _User._Description = "Password = xxx" . END PROCEDURE. /* createSQLDBA */ ------------------------------------ --Created a database prodb testdb sports2000 --Started the database proserve testdb -S 2111 --Ran the procedure file that creates the sysprogress user ${PROEXE} -b -i -p ./addsqldba.p testdb addsqdba.out --SQLEXP connection succeeded sqlexp -char -db testdb -S 2111 -user sysprogress -password xxx OpenEdge Release 11.6ALPHA as of Tue Mar 17 00:59:14 EDT 2015 Connecting user "sysprogress" to URL "jdbc:datadirect
penedge://localhost:2111;databaseName=testdb"... (8920) SQLExplorer Please try creating the sysprogress user the procedure file above. we can change the password in the .p file accordingly.
Continue reading...
penedge://localhost:2111;databaseName=testdb"... (8920) SQLExplorer Please try creating the sysprogress user the procedure file above. we can change the password in the .p file accordingly.Continue reading...