强悍的数据库客户端
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关键字高亮显示(依据与不同是数据库)
存储过程不知道支不支持,这个有待考证~~~

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

Sending JSON data using PHP's cURL library In PHP development, it is often necessary to interact with external APIs. One of the common ways is to use cURL library to send POST�...

Many website developers face the problem of integrating Node.js or Python services under the LAMP architecture: the existing LAMP (Linux Apache MySQL PHP) architecture website needs...

Configure the apscheduler timing task as a service on macOS platform, if you want to configure the apscheduler timing task as a service, similar to ngin...

Alternative usage of Python parameter annotations In Python programming, parameter annotations are a very useful function that can help developers better understand and use functions...

How to replace the disabled initialize_agent function in LangChain? In the LangChain library, initialize_agent...

Python binary library (.whl) download method explores the difficulties many Python developers encounter when installing certain libraries on Windows systems. A common solution...

The technical Q&A community in the ChatGPT era: SegmentFault’s response strategy StackOverflow...

This article describes how to build a highly available MongoDB database on a Debian system. We will explore multiple ways to ensure data security and services continue to operate. Key strategy: ReplicaSet: ReplicaSet: Use replicasets to achieve data redundancy and automatic failover. When a master node fails, the replica set will automatically elect a new master node to ensure the continuous availability of the service. Data backup and recovery: Regularly use the mongodump command to backup the database and formulate effective recovery strategies to deal with the risk of data loss. Monitoring and Alarms: Deploy monitoring tools (such as Prometheus, Grafana) to monitor the running status of MongoDB in real time, and
