Home Database Mysql Tutorial 强悍的数据库客户端

强悍的数据库客户端

Jun 07, 2016 pm 03:41 PM
db2 graphics client tool database Compare Bring your own this

DB2自带的图形化工具比较烂,这个路人皆知 于是,我开始寻找连接db2的客户端工具,在csdn上看到了一款作者自己编写的工具:sqleditor 一个用c#写的db2客户端工具 http://blog.csdn.net/dima80/article/details/4059135 由于我用的是Windows Server 2008R2的6

DB2自带的图形化工具比较烂,这个路人皆知

于是,我开始寻找连接db2的客户端工具,在csdn上看到了一款作者自己编写的工具:sqleditor 一个用c#写的db2客户端工具

http://blog.csdn.net/dima80/article/details/4059135

由于我用的是Windows Server 2008R2的64位系统,这款工具一直跑不动,郁闷死我了。

建议和我一样状况的童鞋还是不要用这款工具了,毕竟技术支持有限啊,伤不起啊,有木有~~~

我所遇到的问题如下:

sqleditor 在windows server 2008 r2 X64的系统下跑不动,我已经安装了 DB2 9.5fp7 32位的版本和
IBM Data Server Driver for ODBC, CLI and .Net 64位的版本,连接的时候报错:算术运算导致溢出
---------------------------

---------------------------
算术运算导致溢出。 在 IBM.Data.DB2.DB2ConnPool.Open(DB2Connection connection, String szConnectionStringIn, DB2ConnSettings& ppSettings, Object& ppConn)

  在 IBM.Data.DB2.DB2Connection.Open()

  在 SQLEditor2.Env.mCreateConnection(String connstr)

  在 SQLEditor2.FrmMain.FrmMain_Load(Object sender, EventArgs e)
---------------------------

之前装了IBM Data Server Driver for ODBC, CLI and .Net 32位的版本也跑不动,不过报错内容不一样,会报长度为0的错误。。。

DBeaver

 

接下来切入正题:DBeaver, 第一次用就非常顺利的客户端连接工具,操作界面基于Eclipse,感觉相当舒适,关键是代码高亮啊,有自动缩进啊,而且又有免安装版,操作界面语言自动匹配,最最重要的是开源的工具啊,免费啊,不用破解啊,有木有~~~~太给力了,有木有~~

我要是早点搜到DBeaver我就不用浪费那么多时间研究那个sqleditor了~~~而且64位的系统跑32位的程序完全木有问题~~~

 

下载地址如下:http://dbeaver.jkiss.org/download/

DBeaver经官方测试,其支持:MySQL、Oracle、PostgreSQL、IBM DB2、Microsoft SQL Server、Sybase、ODBC、Java DB (Derby)、Firebird (Interbase)、HSQLDB、SQLite、Mimer、H2、IBM Informix、SAP MAX DB、Cache、Ingres、Linter、Teradata和一些符合JDBC连接的数据库。

 

基本特性:

1. 支持数据库元数据浏览

2. 支持元数据编辑(包括表,列,键,索引)

3. 支持SQL语句和脚本的执行

4. 支持SQL关键字高亮显示(依据与不同是数据库)

存储过程不知道支不支持,这个有待考证~~~

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to solve the complexity of WordPress installation and update using Composer How to solve the complexity of WordPress installation and update using Composer Apr 17, 2025 pm 10:54 PM

When managing WordPress websites, you often encounter complex operations such as installation, update, and multi-site conversion. These operations are not only time-consuming, but also prone to errors, causing the website to be paralyzed. Combining the WP-CLI core command with Composer can greatly simplify these tasks, improve efficiency and reliability. This article will introduce how to use Composer to solve these problems and improve the convenience of WordPress management.

How to solve complex BelongsToThrough relationship problem in Laravel? Use Composer! How to solve complex BelongsToThrough relationship problem in Laravel? Use Composer! Apr 17, 2025 pm 09:54 PM

In Laravel development, dealing with complex model relationships has always been a challenge, especially when it comes to multi-level BelongsToThrough relationships. Recently, I encountered this problem in a project dealing with a multi-level model relationship, where traditional HasManyThrough relationships fail to meet the needs, resulting in data queries becoming complex and inefficient. After some exploration, I found the library staudenmeir/belongs-to-through, which easily installed and solved my troubles through Composer.

Accelerate PHP code inspection: Experience and practice using overtrue/phplint library Accelerate PHP code inspection: Experience and practice using overtrue/phplint library Apr 17, 2025 pm 11:06 PM

During the development process, we often need to perform syntax checks on PHP code to ensure the correctness and maintainability of the code. However, when the project is large, the single-threaded syntax checking process can become very slow. Recently, I encountered this problem in my project. After trying multiple methods, I finally found the library overtrue/phplint, which greatly improves the speed of code inspection through parallel processing.

How to solve SQL parsing problem? Use greenlion/php-sql-parser! How to solve SQL parsing problem? Use greenlion/php-sql-parser! Apr 17, 2025 pm 09:15 PM

When developing a project that requires parsing SQL statements, I encountered a tricky problem: how to efficiently parse MySQL's SQL statements and extract the key information. After trying many methods, I found that the greenlion/php-sql-parser library can perfectly solve my needs.

How to optimize website performance: Experiences and lessons learned from using the Minify library How to optimize website performance: Experiences and lessons learned from using the Minify library Apr 17, 2025 pm 11:18 PM

In the process of developing a website, improving page loading has always been one of my top priorities. Once, I tried using the Miniify library to compress and merge CSS and JavaScript files in order to improve the performance of the website. However, I encountered many problems and challenges during use, which eventually made me realize that Miniify may no longer be the best choice. Below I will share my experience and how to install and use Minify through Composer.

Solve CSS prefix problem using Composer: Practice of padaliyajay/php-autoprefixer library Solve CSS prefix problem using Composer: Practice of padaliyajay/php-autoprefixer library Apr 17, 2025 pm 11:27 PM

I'm having a tricky problem when developing a front-end project: I need to manually add a browser prefix to the CSS properties to ensure compatibility. This is not only time consuming, but also error-prone. After some exploration, I discovered the padaliyajay/php-autoprefixer library, which easily solved my troubles with Composer.

How to solve the API integration problem in payment processing? Use PayPalServerSDK! How to solve the API integration problem in payment processing? Use PayPalServerSDK! Apr 17, 2025 pm 08:51 PM

I encountered a tricky question when developing an e-commerce platform: How to efficiently integrate payment processing capabilities? Especially how to handle PayPal's API calls. This issue not only involves technical implementation, but also includes how to ensure the security and stability of the payment process. After some research, I discovered the PayPalServerSDK, a tool designed specifically for PayPalRESTAPI, which helped me solve this problem easily.

Solve caching issues in Craft CMS: Using wiejeben/craft-laravel-mix plug-in Solve caching issues in Craft CMS: Using wiejeben/craft-laravel-mix plug-in Apr 18, 2025 am 09:24 AM

When developing websites using CraftCMS, you often encounter resource file caching problems, especially when you frequently update CSS and JavaScript files, old versions of files may still be cached by the browser, causing users to not see the latest changes in time. This problem not only affects the user experience, but also increases the difficulty of development and debugging. Recently, I encountered similar troubles in my project, and after some exploration, I found the plugin wiejeben/craft-laravel-mix, which perfectly solved my caching problem.

See all articles