Components of an ADO.NET connection – PB Docs 2017
Components of an ADO.NET connection When you access a database using ADO.NET in PowerBuilder, your connection goes through several layers before reaching the database. It is important to understand that each layer represents a separate component of the connection, and that components might come from different vendors. The PowerBuilder ADO.NET interface consists of a driver…
Controlling system table access – PB Docs 2017
Controlling system table access Contents Setting Use Extended Attributes or Read Only to control access Granting permissions on system tables to control access To control access to the PowerBuilder system tables at your site, you can specify that PowerBuilder not create or update the system tables or that the system tables be accessible only to certain users…
Specifying the Oracle server connect descriptor – PB Docs 2017
Specifying the Oracle server connect descriptor To connect to an Oracle database server that resides on a network, you must specify the proper connect descriptor in the Server box on the Connection tab of the Database Profile Setup dialog box for your Oracle interface. The connect descriptor specifies the connection parameters that Oracle uses to…
OLE DB data providers – PB Docs 2017
OLE DB data providers When you use the .NET Framework data provider for OLE DB, you connect to a database through an OLE DB data provider, such as Microsoft’s SQLOLEDB or MSDAORA or a data provider from another vendor. The .NET Framework Data Provider for OLE DB does not work with the MSDASQL provider for…
Assigning an owner to the PowerBuilder catalog tables – PB Docs 2017
Assigning an owner to the PowerBuilder catalog tables When you use the I10 interface, you can use the PBCatalogOwner DBParm on the System tab page to assign a nondefault owner to the extended attribute system tables. For ANSI-compliant databases, the owner name that you specify must be unique but the table name does not have to…
Support for long object names – PB Docs 2017
Support for long object names The I10 interface supports Informix long object names with up to 128 characters. Document get from Powerbuilder help Thank you for watching.
Displaying the PowerBuilder extended attribute system tables – PB Docs 2017
Displaying the PowerBuilder extended attribute system tables PowerBuilder updates the extended attribute system tables automatically whenever you change the information for a table or column. The PowerBuilder extended attribute system tables are different from the system tables provided by your DBMS. You can display and open PowerBuilder extended attribute system tables in the Database painter just like other…
Obtaining OLE DB data providers – PB Docs 2017
Obtaining OLE DB data providers PowerBuilder Enterprise lets you access data with any OLE DB data provider obtained from a vendor other than SAP if that data provider supports the OLE DB object interfaces required by PowerBuilder. In most cases, these drivers work with PowerBuilder. However, SAP might not have tested the drivers to verify this. Document…
Unsupported SQL Server 2008 features – PB Docs 2017
Unsupported SQL Server 2008 features The PowerBuilder SNC interface does not support the User-Defined Table Type (a user-defined type that represents the definition of a table structure) that was introduced in SQL Server 2008. Document get from Powerbuilder help Thank you for watching.
Supported versions for OLE DB – PB Docs 2017
Supported versions for OLE DB The OLE DB interface uses a DLL named PBOLE170.DLLÂ to access a database through an OLE DB data provider. Required OLE DB version To use the OLE DB interface to access an OLE DB database, you must connect through an OLE DB data provider that supports OLE DB version 2.0 or…