PowerBuilder Connection Database

What is PowerBuilder (hereafter referred to as PB)?

This is a strange question, to tell the truth, before the graduation project, I do not know what is powerbulider (of course, do not rule out my short-sighted). Baidu Encyclopedia explains this: "PowerBuilder US Sybase developed a new, rapid development tool, is a client/server structure, based on windows3.x, WINDOWS95 and windowsnt an integrated development tool. It includes an intuitive graphical interface and extensible object-oriented programming language PowerScript, which provides interfaces to the current large database and is connected to a stand-alone database via ODBC. "Simply to understand, PB is a development tool with an intuitive graphical interface. Learn to feel similar to VB (of course, every language is a pass!) ）。

PowerBuilder is an object-oriented development tool in which Windows, menus, controls, and so on, are common in all kinds of applications in PowerBuilder. In PowerBuilder we can also create our own user objects. In particular, PowerBuilder provides comprehensive support for various technologies in the object-oriented approach, and we can take advantage of the encapsulation, inheritance, and polymorphism of objects in the object-oriented approach so that the applications we develop are extremely reusable and extensible.   And this is the important goal of the application in software engineering.

main applications of PB

Many materials show that PB is mainly used to develop database application system based on database in background server. (PB operation is very simple, but its connection to the database of the steps of a generation and generation of students, below I will give you a graphical representation of the visual description of the connection database operation.) The database I'm talking about here is SQL database Oh, the other database should be similar to this one. ）

How does PB connect to the database?

1. In the PowerBuilder software interface, click on the database icon above.

2. Eject the Database Profiles window, and in this window, double-click the callout ODBC Administrator item in the diagram.

3. In the ODBC data Source Manager that pops up, click the Add button on the right.

4. In the popup Create new Data Source window, click the bottom SQL Server Native Client 10.0 item.

5. Pop up the new Data Source window created to SQL Server, enter any name, description, server input (local), click Next.

6. At the top of the new interface, tick the "change default database to" button below and select the database that your program wants to connect to. Click Next.

7. Click Next until the interface, to this data source to add the basic completion, click on the test data source below, the prompt to close the interface after successful, if not successful, please start again, pay attention to every small detail.

8. After you close the window in the previous step, go back to the original ODBC Data Source Manager window and you can see that the data source you just created appears above the list and closes this window.

9. Go back to the Database Profiles window, click oDB ODBC, then click the New button on the right.

10. New Popup Database Profile Setup-odbc window, fill in the Profile Name, select the corresponding data source entry in the drop-down list. (If your database does not have a login password, the user ID and password entry below do not need to be filled in)

11. One step in the middle, click on the Preview tab above this window to copy the code below and leave it behind.
Click OK to close this window.

12. Click on the newly added item, click the Connect button on the right, then the small database icon will appear a green tick. Here, all the configuration of the connected database has been completed, just add the code that connects to the database in the program.

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

PB Connection database, temporarily share so much, late knowledge, more exciting!!!

PowerBuilder Connection Database