blocks|key|170397|text|不幸的是，至少使用PB+9，您不能在本机。PB一直是一个两层开发工具。但是，如果您使用的是在PB+9中启动的WebServices支持，您可以通过调用连接池appServer上的WebServices来绕过这一限制。我还没和PB11.5玩过呢。那里可能不一样。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|170398|杰森|170399|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Unfortunately, at least with PB 9, you can't natively. PB has always been a two-tier dev tool. However, if you are using the WebServices support that started in PB 9 you can get around this limitation by invoking WebServices on a connection pooled appServer. I haven't played with PB 11.5 yet BTW. Could be different there.

Jason

blocks|key|847882|text|冒着自我提升的风险，这可能会让您开始为Oracle：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|847883|PB9/Oracle+9i|unordered-list-item|offset|length|847884|PB11.5/Oracle+11g|847885|如果您转到Sybase手册+(直观的，嗯？)，查看您正在查看的版本的“连接数据库手册”，搜索“池”可能会很有成效。查看11.5的本地副本，我可以看到对SNC+(MS)和ODBC的引用。|847886|至于“非本地”方法，我猜Jason可能指的是与应用程序服务器的连接池，然后通过它获取数据。|847887|祝好运。|847888|entityMap|0|LINK|mutability|MUTABLE|url|http://www.techno-kitten.com/Changes_to_PowerBuilder/New_In_PowerBuilder_9/PB9New_-_Database_Connectivity/PB9New_-_Oracle9i_Support/pb9new_-_oracle9i_support.html|1|http://www.techno-kitten.com/Changes_to_PowerBuilder/New_in_PowerBuilder_11_5/NewIn115-Database_interface_en/NewIn115-Native_driver_support/NewIn115-Support_for_session_a/newin115-support_for_session_a.html|2|http://sybooks.sybase.com/^0|0|0|D|0|0|0|H|1|0|5|8|2|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|11|8|@]|9|@$E|12|F|13|1|14]]|A|$]]|$1|G|3|H|5|D|7|15|8|@]|9|@$E|16|F|17|1|18]]|A|$]]|$1|I|3|J|5|6|7|19|8|@]|9|@$E|1A|F|1B|1|1C]]|A|$]]|$1|K|3|L|5|6|7|1D|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|1E|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]|W|$5|R|S|T|A|$U|X]]|Y|$5|R|S|T|A|$U|Z]]]]

At this risk of self-promotion, these may get you started for Oracle:

<ul>
<li><a href="http://www.techno-kitten.com/Changes_to_PowerBuilder/New_In_PowerBuilder_9/PB9New_-_Database_Connectivity/PB9New_-_Oracle9i_Support/pb9new_-_oracle9i_support.html" rel="nofollow noreferrer">PB9/Oracle 9i</a></li>
<li><a href="http://www.techno-kitten.com/Changes_to_PowerBuilder/New_in_PowerBuilder_11_5/NewIn115-Database_interface_en/NewIn115-Native_driver_support/NewIn115-Support_for_session_a/newin115-support_for_session_a.html" rel="nofollow noreferrer">PB11.5/Oracle 11g</a></li>
</ul>

If you go to <a href="http://sybooks.sybase.com" rel="nofollow noreferrer">Sybase Manuals</a> (intuitive, eh? ), go to the Connecting to Your Database manual for the version you're looking at, a search for "pool" may be productive. Looking at my local copy for 11.5, I can see references to SNC (MS) and ODBC. 

As far as "non-native" approaches, I'm guessing Jason might have been referring to connection pooling with an application server, then getting your data through that. 

Good luck.

blocks|key|852115|text|在使用Oracle本机驱动程序并连接到Oracle9i及以上数据库的PowerBuilder版本9和更新之后，您可以使用CnnPool='Yes'数据库参数告诉Oracle在池中维护连接：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|852116|来自PB11.1文档的其他信息：1110/html/dbparm/BJEBJADI.htm|852117|entityMap|0|LINK|mutability|MUTABLE|url|http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc33820_1110/html/dbparm/BJEBJADI.htm^0|1O|D|0|G|T|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@$9|Q|A|R|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|S|8|@]|D|@$9|T|A|U|1|V]]|E|$]]|$1|H|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|I|$J|$5|K|L|M|E|$N|O]]]]

With PowerBuilder version 9 and up using the Oracle native driver and connecting to Oracle 9i and above databases, you can tell Oracle to maintain connections in a pool using the CnnPool='Yes' database parameter:

Additional info from the PB 11.1 docs:
<a href="http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc33820_1110/html/dbparm/BJEBJADI.htm" rel="nofollow noreferrer">http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc33820_1110/html/dbparm/BJEBJADI.htm</a>

blocks|key|1169603|text|我不相信|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1169604|CnnPool=“是”|blockquote|1169605|在PB+9中得到了官方支持。|1169606|我不确定大多数PB开发人员是否都那么熟悉如何处理池。|1169607|与我使用一些Java应用服务器的经验相比，ASP.NET的方法简单而直接。(请不要为最后一句开战，我说过我的经历)。|1169608|我编写了一个“服务器”应用程序，接收为ds.retrieve()和ds.update()执行的PB数据存储，并将数据传回给客户机PB应用程序。这是一种游泳池的方式。服务器应用程序将打开多个连接..。我是在PB+8中这样做的(外面有一本书)。我不会再评论这种方法..。很多代码。|1169609|在PB11.x中，您应该考虑一些很酷的新方法。|1169610|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$]]|$1|E|3|F|5|6|7|S|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|T|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|U|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|V|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|W|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|P|$]]

I don't believe that 

<blockquote>
 CnnPool='Yes'
</blockquote>

was supported officially in PB 9.

I'm not sure that most PB developers are all that familiar with how to deal with pools.

ASP.Net's approach is simple and straight forward at least compared to my experience with some Java app servers. (Please don't start a flame war on that last sentence, I said my experience).

I have written a "server" application that received PB datastores that were executed for ds.retrieve() and ds.update() and passed the data back to the client PB app. It was a way to pool. The server application would open multiple connections... I did this in PB 8 (there's a book out there somewhere). I wouldn't recomment this approach... lot's of code.

In PB 11.x, there are some cool new approaches that you should consider.

blocks|key|847858|text|@Jason+Vogel..。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|847859|你说过我不能做本地的...so，有其他的方法吗？|847860|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

@Jason Vogel...

You said I can't do natively ...so there is an alternative way to do it?

blocks|key|170643|text|/*声明为实例变量*/|type|unstyled|depth|inlineStyleRanges|entityRanges|data|170644|n_to_server+i_to_server+//Transaction对象替代SQLCA，i_to_server是自定义名称，n_to_server也是|170645|/*前列腺素连接对象*/|170646|i_to_server+=//在来自n_to_server的实例变量中声明|170647|i_to_server.DBMS+=+"ODBC“|170648|i_to_server.AutoCommit+=真|170649|"ConnectString='DSN=SourceServer;UID=username;PWD=password'“=+i_to_server.DBParm|170650|使用i_to_server连接；|170651|在:li_TranCount中选择@@trancount|170652|从注射器|170653|其中名称=+'sysobjects‘|170654|使用i_to_server；//必须在不使用SQLCA+(本机事务)的事务中使用|170655|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|10|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|11|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|12|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|13|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|14|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|15|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|16|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|17|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|18|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|19|8|@]|9|@]|A|$]]|$1|V|3|W|5|6|7|1A|8|@]|9|@]|A|$]]|$1|X|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]]|Y|$]]

/* Declare as an instance variable*/

<h2>n_to_server i_to_server //Transaction Object alternative to SQLCA, i_to_server is a custom name as is n_to_server</h2>

/* Instatiate connection object*/

i_to_server = CREATE transaction 
//Was declared in the instance variables from n_to_server

i_to_server.DBMS = "ODBC"

i_to_server.AutoCommit = TRUE

i_to_server.DBParm = "ConnectString='DSN=SourceServer;UID=username;PWD=password'"

CONNECT USING i_to_server ;

SELECT @@trancount INTO :li_TranCount

FROM sysobjects

WHERE name = 'sysobjects'

USING i_to_server ; //Must have USING in transactions that are not using SQLCA (the native transaction)

How to make database connection pool in PowerBuilder (v9+) with...

<ul>
<li>...ODBC?</li>
<li>...SQL Server?</li>
<li>...Oracle?</li>
</ul>

PowerBuilder database connection pool? How-to

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

如何在PowerBuilder (v9+)中使用....ODBC？...SQL服务器？...Oracle？

问PowerBuilder数据库连接池？如何.
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问PowerBuilder数据库连接池？如何.EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问PowerBuilder数据库连接池？如何.
EN