Showing posts with label Database. Show all posts
Showing posts with label Database. Show all posts

Tuesday, March 7, 2017

Powerbuilder with MySQL Database

One of the easiest way to connect to MySQL DB from Powerbuilder is thru ODBC connection. You have to install latest version of MySQL ODBC Driver  from their official site: https://dev.mysql.com/downloads/file/?id=415028 Download the 32 bits version

Tuesday, October 5, 2010

How to connect to 2 databases in Powerbuilder

How to connect to more than 1 database in Powerbuilder

Some times, you need to connect to more than 1 database in your application. In Powerbuilder, there's 1 object for database connection that you can create programmatically. The object call: TRANSACTION.

In this example, I will explain how to connect to 2 databases, which mean 1 is with default database connection object (named SQLCA), and the other is the object that we create mannualy.

Monday, August 16, 2010

Connection String

For every database programmer, Connection String is a MUST term to be remembered. Connection string is one of way to connect to database.

Since we provided by the multi databases type, some times the programmers forget about how to fill the Connection String.