![]() Optionally, Database can be set to connect to a specific database. If IntegratedSecurity is set to false, then User and Password must be set to valid userĬredentials. The Server and Port properties must be set to a MySQL server. Driver Name: Enter the class name of the driver,.Profile Name: Enter a user-friendly name for the profile.In the Database Profile Setup dialog, enter the following:.Right-click the JDBC node and click New Profile.Note: If you are using PowerBuilder Classic, you can also add the path to the driver JAR by clicking Tools -> System Options -> Java. Set the CLASSPATH system environment variable to the path to the driver JAR, located in the lib subfolder of the installation directory. In the Database Painter, you can graphically manipulate data as well as execute SQL queries.Īdd the driver JAR to the PowerBuilder classpath. You can use a database profile to save connection properties. This article shows how to create a basic PowerBuilder application that uses the CData JDBC Driver for MySQL to perform reads and writes.įollow the steps below to use the Database Painter tool to create a database profile based on an JDBC URL for MySQL. This article shows how to use the CData JDBC Driver for MySQL The CData JDBC Driver for MySQL is a standards-based control that can be usedįrom any platform or development technology that supports JDBC, including ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |