SQL Native Client – Anvil of Time https://anvil-of-time.com Nature Forges Everything on the Anvil of Time Thu, 11 Mar 2021 16:19:52 +0000 en-US hourly 1 PowerBuilder – SQL Native Client and DisableBind https://anvil-of-time.com/powerbuilder/powerbuilder-sql-native-client-and-disablebind/ Mon, 19 Mar 2012 22:51:59 +0000 http://anvil-of-time.com/wordpress/?p=1257 Okay so you are upgrading your application, perhaps using the latest version of PowerBuilder (12.5) and SQL Server (2008 R2), and decide to use the SQL Native Client (SNC) to take advantage of new features in the database. Now like many organizations which use Microsoft SQL Server, you may have gone to OLE DB in the distant past (say around PB v7 days) for any number of reasons.

Something to look out for is the Disable Bind setting in your connection string. In OLEDB the default is DisbleBind=1 which disables the binding. For the SNC the default is DisableBind=0 which tells Powerbuilder to bind input parameters to a compiled SQL statement. More information can be found at the following Sybase link.

]]>