Sanjiv Das

Subscribe to Sanjiv Das: eMailAlertsEmail Alerts
Get Sanjiv Das: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn

Top Stories by Sanjiv Das

This article discusses the use of the OLE DB database interface, with an emphasis on connecting to Microsoft SQL Server 2000 from PowerBuilder 9. I'll start by discussing OLE DB in a generic fashion, then move to PowerBuilder interfaces with OLE DB, and finally discuss the specifics of accessing Microsoft SQL Server from PowerBuilder. This is not about developing OLE DB data interfaces, but rather an overview of OLE DB functionality followed by some details on utilizing OLE DB data sources from your PowerBuilder applications. Please note that Microsoft's native driver for Microsoft SQL Server 2000 is now OLE DB. The "MSS Microsoft SQL Server" native database interface from PowerBuilder uses the Microsoft dblib interface and is meant for Microsoft SQL Server 6.5. You can continue to use the old database driver even with a later version of Microsoft SQL Server, but du... (more)

OLE DB (Microsoft SQL Server) Part 2

Part 1 of this article (PBDJ, Vol. 11, issue 3) defined an OLE DB, discussed the OLE DB interfaces provided with PowerBuilder, and connecting to and accessing MS SQL Server. In Part 2 I'll discuss DataWindows and BLOBs, and answer some frequently asked questions about PowerBuilder and OLE DB. DataWindows and OLE DB The primary means of interaction with a database is through DataWindows, which should be used whenever possible. The DataWindow provides significant features, such as easy result set handling, lots of formatting options, and automatic generation of update statements. U... (more)