Technology and Community

Jim O'Neil

Subscribe to Jim O'Neil: eMailAlertsEmail Alerts
Get Jim O'Neil: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn

Top Stories by Jim O'Neil

This article offers a brief look into accessing the ODBC API from a PowerBuilder client application that views the tables and columns within any ODBC data source. The techniques shown here can be leveraged to provide capabilities such as ad-hoc reporting within your PowerBuilder applications. A Brief Overview of ODBC In 1989, the SQL Access Group (SAG), including representation from Oracle, Informix, Ingres, and Sun, was launched with the goal of defining standards for database interoperability. SAG took the lead in developing a SQL Call Level Interface (CLI) specification to define an application programming interface (API) that was vendor neutral, but provided essentially the same functionality as the proprietary embedded-SQL techniques that had been widely used to that point. The API was to be used by database vendors and other software providers in developing dri... (more)

The Debut of DataWindow.NET

In Part 1 we looked at the overall architecture of DataWindow.NET (PBDJ, Vol. 11, issue 4); in Part 2 we'll start coding our first application. We'll code a simple client application that contains two DataWindows with a master-detail relationship using the Department and Employee tables from the PowerBuilder 10 Demo Database (EAS Demo DB V10). For simplicity's sake, we'll provide the option to update only the employee salaries, but obviously the application could be easily extended to allow for inserting and deleting employees as well as departments. Creating the DataWindow Obje... (more)

IBM & Informix

In this article we'll discuss connectivity requirements, Informix-specific data type processing, and the use of Informix stored procedures within the PowerBuilder environment. PowerBuilder offers developers four specific connectivity options for IBM Informix databases: Third-party Open Database Connectivity (ODBC) drivers Third-party Java Database Connectivity (JDBC) drivers Third-party OLE-DB providers The "native" driver available in the PowerBuilder Enterprise version In this article we'll focus on the last option and in Part 2 we'll discuss TEXT and BYTE data, Stored Procedur... (more)

PowerBuilder and EAServer: Uniting the .NET and J2EE Communities

In PowerBuilder 11.2, .NET meets J2EE head-on with the capability to deploy .NET Windows Forms and Web Forms applications (as well as assemblies and Web Services) that access Enterprise JavaBeans (EJBs) in Sybase’s own EAServer. As you’ll see over the course of this article, integrating these “competing” technologies is quite straightforward and leverages mechanisms that have been available since PowerBuilder 7. The enabling technology for the .NET to J2EE functionality in PowerBuilder is the new client support introduced in EAServer 6.1. The EAServer .NET runtime includes three... (more)

Windows 8 AND Visual Studio 2012 Completion Milestones

It’s been a busy day! Both the Windows 8 team and the Visual Studio teams have reached significant milestones in their respective releases. Per Steven Sinofsky’s blog, Windows 8 has been Released to Manufacturing (RTM), and the Windows Store is officially open for paid applications and company accounts (and with a considerable expansion in the number of markets and certification languages). And Jason Zander just announced the final build for Visual Studio 2012, with MSDN availability on August 15th, and a online launch event on September 12th. Here’s a quick rundown of the timel... (more)