Domain Name Hosting, Java Programming - Cheap Web Hosting Blog

Chapter 17 . ODBC/JDBC 505 Figure 17-19: The Insert Database button on the database toolbar 4. Click Get Data. The Open Data Source box appears, as shown in Figure 17-20. 5. From within the Open Data Source dialog box, click MS Query. If Microsoft Query is installed, it opens as a new program with the Choose Data Source box open, as illustrated in Figure 17-21. Go directly to Step 6. Figure 17-20: The Open Data Source dialog box
In case you need affordable webhost to host your website, our recommendation is ecommerce web host services.

504 Part IV . Development Figure 17-18: The Products table contains the data from MySQL, as you would expect. Importing data into Microsoft Word Importing data into a Microsoft Word document is not as simple as working with Microsoft Access. To import data into Microsoft Word, you must use Microsoft Query. Microsoft Query may or may not be installed with your version of Microsoft Word or Microsoft Office. If it is not installed, re-run the Microsoft Office Setup Wizard. Assuming you have Microsoft Query installed, the steps for importing data into Word look like this: 1. Open the Word document into which you want to import the data (it can be a new document). 2. On the Database toolbar, click the icon that inserts a database (see Figure 17-19). Tip If you don t have the Database toolbar available, select View . Toolbars . Database. Doing so adds a Database toolbar to the toolbars visible in Word. 3. Click the Insert Database button. The Database dialog box appears, showing two options: Get Data and Cancel.
Go visit our java server pages services for a reliable, lowcost webhost to satisfy all your needs.

Chapter 17 . ODBC/JDBC 503 Figure 17-17: The Products table is created as a regular table. With the creation of the new object (in this example, the Products table), the import process is complete. Figure 17-18 shows the completed Products table. Note If you update the data in the MySQL database directly, the data is not normally updated in the Access version of the table. Likewise, any operations performed on the Access version of the data are not performed on the MySQL copy of the data. You can use the Link Tables function in Microsoft Access to tie the Access version of the data back into MySQL.
Check Tomcat Web Hosting services for best quality webspace to host your web application.

502 Part IV . Development Figure 17-15: The Machine Data Source tab is where you select the MySQL ODBC data source. Once your ODBC data source is selected and authenticated, a list of tables appears, as illustrated in Figure 17-16 (which shows and example from the ecommerce database). 4. Select the appropriate table that contains the data you are importing. In the example, I ve selected the product table from the Import Objects dialog box. Doing so creates the Products table (see Figures 17-17). Figure 17-16: The Import Objects dialog box, showing a list of tables
Visit our web design programs services for an affordable and reliable webhost to suit all your needs.

Chapter 17 . ODBC/JDBC 501 Figure 17-13: Selecting ODBC Databases () in the Files of type box The Select Data Source box opens, as shown in Figure 17-14. 3. Click the Machine Data Source tab at the top of the Select Data Source dialog box, and then select the MySQL data source that you want to use (as shown in Figure 17-15). Figure 17-14: The Select Data Source dialog box as it appears when it opens
We recommend you use shared web hosting services, because many users agree that it is cheap, reliable and customer-satisfying webhost.

500 Part IV . Development Figure 17-11: The current location where you can find the Import dialog box in Microsoft Access The Import dialog box opens, as shown in Figure 17-12. 2. Within the Import dialog box, drop down the Files of type box and select ODBC Databases (), as shown in Figure 17-13. Figure 17-12: The Import dialog box in Microsoft Access
Visit our web design programs services for an affordable and reliable webhost to suit all your needs.

Chapter 17 . ODBC/JDBC 499 Figure 17-10: The Configuration page within the ODBC Data Sources Administrator Using MyODBC Once MyODBC is installed, you can start sharing data between MySQL and your ODBC-enabled applications (such as Word and Access). Understandably, a frequent practical question that crops up at this point is how to get data from a MySQL database into Microsoft Access, so it makes a good first example. The process is a little different for importing into Word. I look at both in the upcoming section. Importing MySQL data into Microsoft Access With MyODBC installed, importing data into Microsoft Access is quite easy. This section examines the process for importing tables into Access. Caution Microsoft seems to change the location and processes for import often, so the steps given here may change by the time you read this (or by the time I finish writing this section). Problems can arise working with Microsoft Access if you have an old version of the Microsoft Data Access Components (MDAC). Download a new version of these drivers from Microsoft. The current location of Microsoft s data- related software on the Web is http://www.microsoft.com/data/. Currently the steps for importing tables into Access are as follows: 1. From within Access with a database open, click File . Get External Data . and . Import, as shown in Figure 17-11.
Looking for affordable and reliable webhost to host and run your business application? Then look no more and go to servlet web hosting services.

498 Part IV . Development Figure 17-8: ODBC Data Sources (32 bit) contains the information about the MySQL ODBC connection. The ODBC Data Source Administrator dialog box opens, showing the User DSN tab (as depicted in Figure 17-9). 3. Click sample-MySQLand then click Configure, as shown in Figure 17-10. Tip Each ODBC connection connects to an individual database. Therefore, if you want to connect to more than one database, you must add a new data source by clicking the Add button. Figure 17-9: The default page in the ODBC Data Source Administrator
If you are looking for affordable and reliable webhost to host and run your business application visit our ftp web hosting services.

Chapter 17 . ODBC/JDBC 497 Figure 17-6: Setting the default configuration for MyODBC Changing MyODBC Options Should you want to change options for MyODBC at a later date, you do so through Control Panel on Windows 95 or 98 and through Administrative Tools on Windows 2000 and XP. Follow these steps: 1. Click Start . Settings . Control Panel. Control Panel opens. 2. Double-click ODBC Data Sources, as shown in Figure 17-8. Figure 17-7: A successful installation of MyODBC
If you are looking for cheap and quality webhost to host and run your website check Jboss Web Hosting services.

496 Part IV . Development Figure 17-4: Click the MySQL driver to select it for installation. Next you configure the MySQL data source. When presented with the list of Data Sources, click once to highlight sample-MySQL (MySQL), as in Figure 17-5. With sample-MySQL (MySQL)highlighted, click the Setup button to bring up the MySQL default configuration box. Set whichever options you need (for example, MySQL Host, User, Password, and so on), as illustrated in Figure 17-6. When finished, click OK. You can change the options later via the ODBC applet, located in Control Panel on Windows 95 and 98 and Administrative Tools on Windows 2000 and XP. Once you have configured MyODBC, click Close. You should see a success message like that in Figure 17-7. Figure 17-5: Click sample-MySQL (MySQL) in the list of available data sources.
We recommend high quality webhost to host and run your jsp application: christian web host services.