![]() J2EE Code Generator tool allows you to generate EJB 3.0 annotated Pojos as well as JDBC DAO access layer code from existing tables. The table creator allows you to define table columnsĪnd constraints using a simple interface and you can preview the SQL before Multiple result-sets, printing, persisted query history, exporting, image, XML, ASN.1 viewing and searching within results.ĭB Solo also contains table and index creator tools that allow you to create tablesĪnd indexes without knowing SQL. You don't need to know SQL to be able to navigate and explore your databaseĪd-hoc queries can be entered in a query window that supports auto-completion, explain plan, You can also graphically view your table's foreign-key relationships with other tables. View, edit, print and export data of tables or results of your ad-hoc queries. Tablespaces, users, roles, sessions and stored procedures you can also In addition to viewing and managing objects such as schemas, tables, indexes, views, On Windows, Mac OS X, Solaris and Linux platforms, so you don't have to buy another tool onlyīecause you want to run manage your databases from different operating systems. You can manage all of theseĭBMS products - even at the same time - from a single application. Oracle, Microsoft SQL Server, DB2, Solid, Sybase and MySQL. DB Solo has an intuitive user interface that allows you to exploreĪnd manage your database objects as well as execute your own ad-hoc queries.ĭB Solo supports most major relational database products available today including Note You can obtain the corresponding providers and drivers for SQL Server from these websites.DB Solo is a powerful database development and management tool for developersĪnd DBAs. Latest feature pack for Microsoft SQL Server 2012 Latest feature pack for Microsoft SQL Server 2008 and Microsoft SQL Server 2008 R2 Latest feature pack for Microsoft SQL Server 2005 To obtain the latest feature packs for SQL Server, go to the following Microsoft websites: To determine which version of SQL Server Native Client that you have installed on your system, follow the steps that are described earlier in this article to check the version of the sqlncli xx.dll file. To connect to SQL Server relational databases, we recommend that you download the appropriate Microsoft SQL Native Client instead of using the old Microsoft/Windows Data Access Components (MDAC/WDAC) drivers for your operating system. For example, the version number may be 100 (Msolap100.dll) for MSOLAP.4 and 110 (Msolap110.dll) for MSOLAP.5. Note xxxrepresents the version number of MSOLAP. To do this, right-click msolap xxx.dll, and then check the version number in the Details tab in the Properties menu. To determine which version of MSOLAP you are using, check the version number of the msolap xxx.dll file on your system. To connect to SQL Server Analysis Services, download the appropriate version of MSOLAP for your operating system. Note Some features that are supported in later versions of SQL Server may not be available in versions of Excel that are not written specifically to take advantage of the features. We recommend that you install the version of MSOLAP that matches the latest version of the data source server that you are using. However, if the version of the data source server corresponds to a version of the provider that is earlier than the version of the provider that is installed, the provider can retrieve data from the data source server. Therefore, if a provider tries to retrieve data from a data source server, and the version of the data source server corresponds to a version of the provider that is later than the version of the provider that is installed, the provider may experience certain issues. ![]() The providers for SQL Server are backward compatible. You can obtain the corresponding providers and drivers for SQL Server from the feature pack for each version of SQL Server. Note If you want to connect to SQL Server 2012 Service Pack 1 (SP1), you have to upgrade the provider to the latest version of MSOLAP.5. To retrieve the data, Excel 2010 must use Analysis Services OLE DB Provider for SQL Server 2012 (MSOLAP.5) instead. For example, Excel 2010 cannot use Analysis Services OLE DB Provider for SQL Server 2008 R2 (MSOLAP.4) to retrieve data from a Microsoft SQL Server 2012 cube. ![]() Microsoft Excel uses MSOLAP to connect to Microsoft SQL Server. However, Excel cannot connect to a SQL Server Analysis Services database if an incorrect version of MSOLAP is used. This article describes the latest versions of Microsoft Analysis Services OLE DB Provider for Microsoft SQL Server (MSOLAP) and where you can download the providers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |