windows ODBC驱动链接不上linux上的Mysql 数据库原因

来源：互联网发布：c语言怎么求素数因子编辑：程序博客网时间：2024/04/29 20:19

1. 主要原因是Linux开了 iptables 防火墙，对于window发起到mysql的3306 端口的tcp链接

被linux 回复了ICMP 服务器reject...

解决的方法是：

是在防火墙中放开 3306 的端口；linux采用工具这边抓包；

iptables -A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT

iptables -A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT

iptables -A INPUT -j REJECT --reject-with icmp-host-prohibited

LINUX的文件：(仅供参考，/etc/sysconfig/iptables)

# Firewall configuration written by system-config-firewall
# Manual customization of this file is not recommended.
*filter
:INPUT ACCEPT [0:0]
:FORWARD ACCEPT [0:0]
:OUTPUT ACCEPT [0:0]
-A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT
-A INPUT -p icmp -j ACCEPT
-A INPUT -i lo -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT
-A INPUT -j REJECT --reject-with icmp-host-prohibited
-A FORWARD -j REJECT --reject-with icmp-host-prohibited
COMMIT

修改为： （重新启动后，永久生效）

[root@CentOS jack]# cat /etc/sysconfig/iptables
# Firewall configuration written by system-config-firewall
# Manual customization of this file is not recommended.
*filter
:INPUT ACCEPT [0:0]
:FORWARD ACCEPT [0:0]
:OUTPUT ACCEPT [0:0]
-A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT
-A INPUT -p icmp -j ACCEPT
-A INPUT -i lo -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT
-A INPUT -m state --state New -m tcp -p tcp --dport 3306 -j ACCEPT
-A INPUT -j REJECT --reject-with icmp-host-prohibited
-A FORWARD -j REJECT --reject-with icmp-host-prohibited
COMMIT
[root@CentOS jack]#

[root@CentOS jack]# service iptables stop
iptables：清除防火墙规则：                                 [确定]
iptables：将链设置为政策 ACCEPT：filter                    [确定]
iptables：正在卸载模块：                                   [确定]
[root@CentOS jack]# service iptables start
iptables：应用防火墙规则：                                 [确定]
[root@CentOS jack]# iptables -L -nv
Chain INPUT (policy ACCEPT 0 packets, 0 bytes)
pkts bytes target     prot opt in     out     source               destination
   14   924 ACCEPT     all -- *      *       0.0.0.0/0            0.0.0.0/0           state RELATED,ESTABLISHED
    0     0 ACCEPT     icmp -- *      *       0.0.0.0/0            0.0.0.0/0
    0     0 ACCEPT     all -- lo     *       0.0.0.0/0            0.0.0.0/0
    0     0 ACCEPT     tcp -- *      *       0.0.0.0/0            0.0.0.0/0           state NEW tcp dpt:22
    0     0 ACCEPT     tcp -- *      *       0.0.0.0/0            0.0.0.0/0           state NEW tcp dpt:3306
    0     0 REJECT     all -- *      *       0.0.0.0/0            0.0.0.0/0           reject-with icmp-host-prohibited

Chain FORWARD (policy ACCEPT 0 packets, 0 bytes)
pkts bytes target     prot opt in     out     source               destination
    0     0 REJECT     all -- *      *       0.0.0.0/0            0.0.0.0/0           reject-with icmp-host-prohibited

Chain OUTPUT (policy ACCEPT 8 packets, 1120 bytes)
pkts bytes target     prot opt in     out     source               destination

2. ODBC驱动安装完毕，可以和mysql测试OK, 但是发现和office，excel，visio的外部数据源ODBC连不上，出现：体系冲突；

结果发现，win7 64位，安装的是32为的office，所以，mysql odbc驱动需要下载 32位，才可以使用；mysql odbc 64位的驱动是不行的。