Connect to QuickBase Data from PowerBuilder

詳細情報をご希望ですか?

無償トライアル:

ダウンロードへ

製品の詳細情報へ:

QuickBase ODBC Driver

QuickBase ODBC Driver を使って、ODBC 接続をサポートするあらゆるアプリケーション・ツールからQuickBase にデータ連携。

QuickBase データにデータベースと同感覚でアクセスして、QuickBase のApplications に使い慣れたODBC インターフェースで双方向連携。



This article demonstrates how to use the CData ODBC Driver for QuickBase to connect to QuickBase data and execute queries in PowerBuilder.

The CData ODBC Driver for QuickBase can be used from any platform or development technology that supports ODBC, including Sybase PowerBuilder. This article shows how to connect to QuickBase data and execute queries from the Database Painter and controls such as the DataWindow.

※製品について詳しい情報をご希望の方は以下からお進みください。

Create a Profile for the ODBC Driver for QuickBase

Follow the steps below to use the Database Painter tool to create a database profile based on an ODBC DSN (data source name) for QuickBase. In the Database Painter, you can use wizards and the UI to work with QuickBase data.

  1. If you have not already done so, create an ODBC DSN for QuickBase. The DSN contains the connection properties required to connect to QuickBase data. You can use the Microsoft ODBC Data Source Administrator to create and configure DSNs. This is the last step of installing the driver. Required connection properties are the following:
    • User
    • Password
    • Domain
    • ApplicationToken

    User Authentication Method

    To authenticate with user credentials, specify the following connection properties:

    1. Set the User and Password.
    2. If your application requires an ApplicationToken;, you must provide it otherwise an error will be thrown. You can find the ApplicationToken under SpecificApp > Settings > App management > App properties > Advanced settings > Security options > Manage Application Token.

    User Token Authentication

    To authenticate with a user token, specify the following connection properties:

    1. Set UserToken and you are ready to connect. You can find the UserToken under Quick Base > My Preferences > My User Information > Manage User Tokens.
    See the help documentation for a guide to creating a QuickBase DSN.
  2. In PowerBuilder, click Tools -> Database Painter.
  3. In the Objects window in the Database Painter, right-click the ODBC node and click New Profile.
  4. On the Connection tab, enter a name for the profile and select the QuickBase DSN in the Data Source menu.
  5. To view and modify a table, right-click a table and then click Edit Data -> Grid.

Using QuickBase Data with PowerBuilder Controls

You can use standard PowerBuilder objects to connect to ODBC data sources and execute queries. The following example shows how to retrieve QuickBase data into a DataWindow. You can add the following code to the open method:

SQLCA.DBMS = "ODBC" SQLCA.DBParm = "ConnectString='DSN=CData QuickBase Source'" CONNECT USING SQLCA; dw_sampletable_1.SetTransObject(SQLCA); dw_sampletable_1.Retrieve();