[Stackoverflow] [Progress OpenEdge ABL] Progress: How to start PAS with local SQL Server database

[CoXY]

I could start the PAS instance with Progress DB, but could not start it with SQL Server database.

And I have created a schema holder, and import all data into SQL Server database, but every time I try to start PAS, will get error like following:

com.progress.open4gl.dynamicapi.SessionPool$NoAvailableSessionsException: SessionPool : NoAvailableSessions[Could not connect to the AppServer: General Error: Connection refused: connect. (7203)]
        at com.progress.open4gl.dynamicapi.SessionPool$BrokerSessionList.reserveSession(SessionPool.java:758)
        at com.progress.open4gl.dynamicapi.SessionPool.reserveSession(SessionPool.java:3323)
        at com.progress.open4gl.dynamicapi.SessionPool.createSession(SessionPool.java:2300)
        at com.progress.open4gl.dynamicapi.SessionPool.initializePool(SessionPool.java:3622)
        at com.progress.open4gl.dynamicapi.SessionPool.<init>(SessionPool.java:2066)
        at com.progress.open4gl.dynamicapi.SessionPool.createPool(SessionPool.java:1871)
        at com.progress.open4gl.javaproxy.ProObject.<init>(ProObject.java:203)
        at com.progress.open4gl.javaproxy.AppObject.<init>(AppObject.java:93)
        at com.progress.open4gl.javaproxy.OpenAppObjectImpl.<init>(OpenAppObjectImpl.java:27)
        at com.progress.open4gl.javaproxy.OpenAppObject.<init>(OpenAppObject.java:76)
        at com.progress.appserv.broker.agent.TcpAgent.initAdminConnection(TcpAgent.java:2055)
        at com.progress.appserv.broker.agent.TcpAgent.startAgent(TcpAgent.java:253)
        at com.progress.appserv.broker.agent.TcpAgentPool$AgentStarter.call(TcpAgentPool.java:2209)
        at com.progress.appserv.broker.agent.TcpAgentPool$AgentStarter.call(TcpAgentPool.java:2178)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:745)

My pf file like this:

-db C:\xxxx\holder.db -RO -ld holder  #Schema Holder DB

-db data-ld data                      #MSSQL ODBC - data
-dt MSS
-U xxx
-P xxx

Do you have any idea how could start PAS with SQL Server correctly?

Continue reading...