Connect to the Database Using PowerBuilder

What is PowerBuilder (PB )? This is a strange question. To be honest, before this graduation project, I don't know what PowerBulider is (of course, I don't know how short it is ). Baidu encyclopedia explained as follows: "PowerBuilder is a new and fast development tool developed by Sybase in the United States. It is under the client server structure,

What is PowerBuilder (PB )? This is a strange question. To be honest, before this graduation project, I don't know what PowerBulider is (of course, I don't know how short it is ). Baidu encyclopedia explained this as follows: "PowerBuilder is a new and fast development tool developed by Sybase in the United States. It is under the Client/Server structure,

What is PowerBuilder (PB )?

This is a strange question. To be honest, before this graduation project, I don't know what PowerBulider is (of course, I don't know how short it is ). Baidu encyclopedia explained this as follows: "PowerBuilder is a new and fast development tool developed by Sybase in the United States. It is under the Client/Server structure, an Integrated Development Tool Based on Windows3.x, Windows95, and WindowsNT. It contains an intuitive graphical interface and scalable object-oriented programming language PowerScript. It provides interfaces with popular large databases and is connected to single-host databases through ODBC ." In simple terms, PB is a development tool with an intuitive graphical interface. After learning it, I feel similar to VB (of course, every language is accessible !).

PowerBuilder is an object-oriented development tool. Common WINDOWS, menus, and controls in various WINDOWS applications are all objects in PowerBuilder. In PowerBuilder, we can also create our own user objects. In particular, PowerBuilder provides comprehensive support for various technologies in object-oriented methods, we can use the characteristics of object encapsulation, inheritance, and polymorphism in the object-oriented method to make our applications highly reusable and scalable, this is an important goal of Software Engineering for applications.

Main Application of PB

Many materials show that PB is mainly used to develop Database Application Systems Based on databases on backend servers. (PB operations are simple, but the steps for connecting to the database are difficult for generations of students. Below I will explain how to connect to the database. The database I am talking about here is a SQL database. Other databases should be similar to this one .)

How does PB connect to the database?

1. On the powerbuilder software interface, click the database icon above.

2. The Database Profiles window is displayed. In this window, double-click the icon to mark the ODBC Administrator.

3. In the pop-up ODBC data source Manager, click Add on the right.

4. In the pop-up window for creating a new data source, click SQL Server Native Client 10.0 at the bottom.

5. The new data source window created to SQL Server is displayed. Enter any name and description, enter local at the Server, and click Next.

6. Check "change default database to" at the top of the new interface and select the database to be connected by your program. Click Next.

7. click "Next" until the page is displayed. Click "Test Data Source" at the bottom of the page to close the page. If the data source fails, perform the operation again from the beginning. Pay attention to every small detail.

8. After closing the window in the previous step, return to the original ODBC data source Manager window. The created data source is displayed at the top of the list. Close this window.

9. Return to the Database Profiles window, click odb odbc, and then click the New button on the right.

10. The Database Profile Setup-ODBC window is displayed. Fill in the Profile Name and select the corresponding Data Source item from the drop-down list. (If NO logon password is set for your database, you do not need to enter the user id and password below)

Click OK to close this window.

12. Click the newly added item and click the Connect button on the right side. A green tick will appear in the database icon. By now, all the database connection configurations have been completed. You only need to add the database connection code in the program.

13. I added the copied code to an open event in one of my program windows so that the window can be directly connected to the database when it is opened.

I have shared so much with petabytes of data to connect to the database. It's even more exciting to know later !!!