Small photo

TeamSybase Blogs

Breck Carter
Sending Emails Via SendGrid SMTP Relay
Dec 20
Once upon a time, it was possible to send emails from inside SQL Anywhere by using xp_sendmail with Google's free service.It may still be possible, but apparently not for me... all I get is return code 6 (Secure connection error) after clicking on Send Test Alert Email in Foxhound:Email test result: SMTP start test AutoDrop email failed with return code 6 when sending "Foxhound Test AutoDrop Email (2017-12-01 09:58:38)". Secure connection errorThere are a number of alternatives ...
Top 10 Cool New Features In Foxhound 4
Nov 15
Version 4 of the Foxhound Database Monitor has been around for a while, long enough for five patches and a new build... long enough for a Top 10 listicle about the best new features:1. Foxhound Is The BookOnce upon a time (2004) there was a book about SQL Anywhere 9.Then the book got old and the questions started:Q: When are you going to write a book about SQL Anywhere Version 11? I really like the Version 9 book.Eventually (2009) the questions were answered:A: This blog is that book.Now, the an...
Monitor The Arbiter Server With Foxhound
Oct 29
Question: How do I monitor a SQL Anywhere High Availability Arbiter server with Foxhound 4?Answer: Gosh, how hard can that be? After all, dbping has no problem connecting to an arbiter server:"%SQLANY17%\bin64\dbping.exe" -c "SERVER=ARBITER_PROD; HOST=localhost:55501;"SQL Anywhere Server Ping Utility Version server successful.Foxhound 4 uses ODBC to connect, so all we have to do is add a DRIVER= to the connection string, right?SERVER=ARBITER_PROD; HOST=localhost:55501; DRIVER=SQL...
How To Shrink Foxhound
Oct 9
Question: How do I shrink and reorganize the Foxhound 4 database?Answer: Foxhound uses SQL Anywhere for its database, and the only way to shrink the size of a SQL Anywhere database file is to unload, recreate and reload the file from scratch. The good news is, that whole process is automatic when you reinstall Foxhound on an existing installation:First, Foxhound creates a new, empty copy of the database file. Second, Foxhound finds the old database file, then it asks you how much of the old data...
New Foxhound 4 Build 4740
Oct 5
A new build of Foxhound 4 is available here.You can use it to upgrade an existing copy of Foxhound 4 for free. You can also use it to install a new copy of Foxhound 4, or to upgrade an existing copy of Foxhound 1, 2 or 3.If you are already using Foxhound 4, here's why you should consider upgrading to build 4740:Build 4740 "rolls up" all five patches that were previously released for the original Foxhound 4 build 4729. Several performance problems have been fixed, making it less likely that Foxho...

Bruce Armstrong
More options for connecting PowerBuilder with Git for source control
Mar 15
One of the things that has been hindering PowerBuilder users from adopting Git for source control has been the lack of a MSSCCI provider for Git.  That changed when PB Software released their provider in 2014, although I didn't discover it until 2017 and wrote about it in this blog post.Of course, one of the new features in PowerBuilder 2017 R2 is native support for Git, so if you're using that version then the lack of a MSSCCI provider for Git is no longer an issue.  However, if you'r...
PowerBuilder 2017 R2 New Feature: Git source control support
Feb 21
In a previous blog article we looked at the new feature of PowerBuilder 2017 R2 for Subversion source control support. In this blog article we're going to look at a very similar feature, Git source control support.  I'm not going to go through the history of source code support in PowerBuilder again, I'd refer you to that previous blog article for that.  We're going dive straight in to how the Git feature works.Setting up GitFor this demo, we're going to use Bonobo Git Server.  On...
Running .Net in the Browser
Feb 13
Mentioned Blazor a while back, here's an update:They've opened up a github repository now.  There's also there's a blog post explaining the status of the project.  Conversely, there's also a somewhat less than enthusiastic independent appraisal of it over on I Programmer.
PowerBuilder 2017 R2 New Feature: Subversion (SVN) source control support
Feb 6
PowerBuilder's initial support for version control systems required drivers for specific vendors (e.g., PVCS) and often for specific versions of that vendor's products.  It was not unusual to find that you needed to wait to upgrade your source control product until PowerBuilder released an updated driver for it.  And if your source control provider wasn't supported by PowerBuilder you were simply out of luck.That changed with PowerBuilder 6.  With that release, PowerBuilder abando...
PowerBuilder 2017 R2 New Feature: REST
Feb 5
One of the new features added to PowerBuilder 2017 R2 is support for REST web services.  This feature isn't 100% complete, as additional REST functionality is planned for 2017 R3.  There's still a lot in the R2 release to look at though.To make things simple for the demo, we're going to use a online REST webservice called JSONPlaceHolder..  The service doesn't require creating an account or user authentication.  While the GET (retrieve) methods are fully functional the POST (...

Dave Fish
PowerBuilder 12 CTP Hands On Guided Tours
May 28
PowerBuilder 12 CTP Hands On Events in JuneSybase in conjunction with ISUG will be holding a series of hands on Guided Tours of the new PowerBuilder .NET Community Technology Preview release during the month of June. For more information and to register please will be held in:Boston,New York,Minneapolis,Houston,DenverThe public CTP is scheduled to begin in early June. Download information will be made available here as soon as the program begin...
PowerBuilder Accelerated Development Tour
Jan 21
PowerBuilder Accelerated Development TourWe’re packing up the PowerBuilder team and hitting the road to bring the latest in PowerBuilder news, code, and goodies to you. PowerBuilder 11.5 just came out and we want to share how the new features and capabilities will help accelerate your development, bring aesthetic enhancements to your PowerBuilder applications, and simplify .NET development. We are also working fast and furiously on delivering PowerBuilder 12, which blend the Visual Studio Isolat...
PowerBuilder 11.5 and strong-named .NET Assemblies
May 13
Another new feature in PowerBuilder 11.5 is the ability to generate strong-named assemblies for any of the four .NET targets (Web Forms, Windows Forms, .NET Web Services or .NET Assemblies). What does this mean?Well the Help file says this:A strong name consists of an assembly's identity—its simple text name, version number, and culture information (when provided)—plus a public key and digital signature. It is generated from an assembly file using the corresponding private key. The assembly file...
More on Graphs in PowerBuilder 11.5
May 10
Last week I posted a screen shot of the new 3D Rendering capabilities being added to some of the 3D graphs in PowerBuilder 11.5. It was met with mixed reviews on the PowerBuilder Futures newsgroup ( so I went back to the drawing board to see what I could come up with. Apparently there are quite a few configuration settings one can set programmatically to render better looking graphs. For example, the primary color scheme default can be changed by making a couple of function cal...
DataWindow Tooltips in 11.5
May 6
Today's sneak preview is on the DataWindow Tooltip enhancement in 11.5. This screenshot shows a tooltip on the first_name column:This shows a tooltip with the title property populated as well as an icon property selected. It also shows the bubble format. Below you can see the list of properties that will be available for tooltips:It is important to point out that you can place a tooltip on any control on the DataWindow. Drawing objects, buttons, nested reports, computed fields, labels, they all ...

Jason Froebe
HOWTO: SAP Sybase IQ, SQLAnywhere, and Powershell
Mar 22
Connecting to IQ can be a rather pain in the tuckus. In the v16 IQ client for Microsoft Windows, the .net assembly changed to “Sap.Data.SQLAnywhere” from “iAnywhere.Data.SQLAnywhere”. Another annoyance is the loading of the assembly where SAP recommends loading it via This forces you to remember the exact version of the assembly as well as … Continue reading "HOWTO: SAP Sybase IQ, SQLAnywhere, and Powershell"
VIDEO: PostgreSQL at 10 TB and beyond
Feb 3
If you’re interested in large databases and PostgreSQL, Chris Travers at Edument has been kind enough to share his experiences with such a setup (YouTube)
SAP IQ and SQL Anywhere UnixODBC UserDSN and SystemDSN issues: WORKAROUND
Nov 30
SAP’s IQ / SQLAnywhere ODBC driver on Linux/*nix doesn’t work with a system that has both UserDSNs (~/.odbc.ini) and SystemDSNs (/etc/odbc.ini). Currently when the driver looks for a DSN (db instance), the resolution is: $ODBCINI – must contain the exact full path name of the .odbc.ini file. $HOME Current directory $PATH Notice that /etc/odbc.ini is … Continue reading "SAP IQ and SQL Anywhere UnixODBC UserDSN and SystemDSN issues: WORKAROUND"
HOWTO: IBM DB2, ODBC, and Linux (*nix) configuration
Oct 6
The DB2 ODBC driver works like anything else IBM. Nonstandard to the rest of the universe. How to set up ODBC: Unix admin needs to do: Retrieve the config file locations: /etc/odbcinst.ini : list of the available drivers and default configuration for each driver /etc/odbc.ini : list of the instances/databases for *all* users aka “System … Continue reading "HOWTO: IBM DB2, ODBC, and Linux (*nix) configuration"
HowTo: Set up iSCSI with Multipath (MPIO) in Windows 10 SOLVED
Oct 5
I searched high and low and wasn’t able to find a definitive answer on whether Microsoft Windows 10 supports multipath (MPIO) over iSCSI. I found many many blog posts, articles, and press releases for Windows servers but nothing for Windows 10. The good news is that Windows 10 supports it out of the box. You … Continue reading "HowTo: Set up iSCSI with Multipath (MPIO) in Windows 10 SOLVED"

Paul Horan
Swift 2.0 and the Public Sector
Feb 2
Introduction Apple introduced their new Swift programming language at their World Wide Developer Conference back in 2014.  Swift is a native language for Apple’s Cocoa and Cocoa Touch frameworks, on which the OS/X and iOS operating systems are built.  During its … Continue reading →
Swift for PowerBuilder Developers – Part III
Jan 17
Introduction In this third installment of the series, we’ll compare and contrast the different types of Loop constructs available in both PowerScript and Swift. If you want to start at the beginning, here are Part 1 and Part 2. Overview … Continue reading →
Swift for PowerBuilder Developers – Part II
Jan 17
Introduction This is the second of a series of posts that introduce the Swift programming language and the Xcode IDE to PowerBuilder developers.  Part 1 can be found here: Swift for PowerBuilder Developers: Part 1 In this installment, we’ll talk … Continue reading →
Swift for PowerBuilder Developers – Part I
Jan 15
Introduction I’ve been a developer most of my career, and I’ve worked with a number of different programming languages.  I spent most of the 90’s and early 00’s working in PowerBuilder.  I still think it’s one of the cleanest, easiest … Continue reading →
2009 Napa Valley Marathon!
Mar 4
The Napa Valley Marathon was run on Sunday, March 1st, 2009.  26.2 miles of the most gorgeous countryside in the world.  It’s my favorite race because A) it runs the length of the Silverado Trail from Calistoga to Napa, and B) … Continue reading →

Yakov Werfe
A Snap-In App Framework Using Dynamic PowerBuilder Assemblies (Part 2)
Mar 16
This two-part series examines and contrasts PowerBuilder .NET 12.5.1’s new dynamic assembly feature with corresponding dynamic library functionality in PowerBuilder Classic. The discourse is presented in the context of a simplified yet practical use case. Part 1 presented the use case, reviewed pertinent PowerBuilder Classic dynamic APIs and presented a Classic PBD implementation. Part 2 introduces PowerBuilder .NET 12.5.1’s Dynamic Assembly feature, reveals relevant PowerBuilder .NET generated ...
Building a Snap-In App Framework Using Dynamic PowerBuilder Assemblies
Mar 2
The articles in this two-part series examine and contrast PowerBuilder .NET 12.5.1’s new dynamic assembly feature with corresponding dynamic library functionality in PowerBuilder Classic. The discourse is presented in the context of a simplified yet practical use case. The first article presents the use case, reviews pertinent PowerBuilder Classic dynamic APIs, and presents a Classic PBD implementation. The second article introduces PowerBuilder .NET 12.5.1’s Dynamic Assembly feature, reveals re...
Breaking Platform Limitations
Mar 2
One of the innovative new features in the PowerBuilder 12.5.1 release is its ability to deploy PowerBuilder .NET code to run in 64-bit mode on 64-bit Windows platforms. In this article, after gaining background and perspective on 32- and 64-bit memory management and .NET deployment models, you’ll explore the internals, strengths and limitations of this new feature. Almost all current server, desktop and notebook hardware platforms have 64-bit processors. Almost all current versions of Windows op...
PFC Project Partitioning Using a Referenced PowerBuilder Assembly Target
Feb 22
Paul Harvey, the great American radio personality, would always conclude his colorful broadcasts with the quip “And now you know the rest of the story.” For those of you not acquainted with Paul’s broadcasts, here’s a sample. If you get to about 3:40 in, you’ll hear the classic remark. Paraphrasing Paul’s tag line, in this article you’ll learn “the rest of the story” about RAD Development methodology in PowerBuilder 12.5 .NET using a Referenced PB Assembly Target. I’ll explain the technique and ...
Writing to the Console in PowerBuilder 12.5 .NET
Nov 3
Yesterday I taught an intro to PowerBuilder .NET 12.5 session. Part of the presentation had me comparing the.NET IL code inside an assemblies generated from code written in C# and PowerBuilder. The C# code, after performing a simple arithmetic calculation echoed results to the console using these two lines of code. In PowerScript, ordinarily, I echo results using a Messagebox call, but yesterday, I thought I’d “step out on the limb” and echo output to the console using the same NET Framework ...

PowerBuilder ...

PowerBuilder ...

PowerBuilder PFC...

Replication Server...

Sybase ASE...

SQL Anywhere 9...

SQL Anywhere 9
Chinese Edition...

SQL Anywhere 9
Japanese Edition...