Windows下SqlServer2008通过ODBC连接到DM数据库安装部署
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pbWcyMDIzLmNuYmxvZ3MuY29tL2Jsb2cvMjc0MjIvMjAyMzA2LzI3NDIyLTIwMjMwNjI5MTgzNzMyMDAzLTYwNTA5NDcxMC5qcGc=1 环境说明
操作系统：Windows Server 2008
数据库版本：SQL Server 2008 10.50.1600.1
2 搭建过程
2.1 达梦数据库软件下载
进入达梦官网 https://www.dameng.com/
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pbWcyMDIzLmNuYmxvZ3MuY29tL2Jsb2cvMjc0MjIvMjAyMzA2LzI3NDIyLTIwMjMwNjI5MTgzOTE4MjcwLTIwNDk2MTg5OTkucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pbWcyMDIzLmNuYmxvZ3MuY29tL2Jsb2cvMjc0MjIvMjAyMzA2LzI3NDIyLTIwMjMwNjI5MTgzOTI1NjI5LTgzNTcwMzk2LnBuZw==
选择X86，win64，点击下载。
2.2 安装数据库
解压下载后文件，进入iso 执行setup.exe
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pbWcyMDIzLmNuYmxvZ3MuY29tL2Jsb2cvMjc0MjIvMjAyMzA2LzI3NDIyLTIwMjMwNjI5MTgzOTMzODAyLTg5Njg0NjA5OC5wbmc=
按默认一直往下点
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pbWcyMDIzLmNuYmxvZ3MuY29tL2Jsb2cvMjc0MjIvMjAyMzA2LzI3NDIyLTIwMjMwNjI5MTgzOTM5MjY2LTE0MTM4MzI0MTIucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pbWcyMDIzLmNuYmxvZ3MuY29tL2Jsb2cvMjc0MjIvMjAyMzA2LzI3NDIyLTIwMjMwNjI5MTg0MDA1MDExLTI2MTc3OTM4NS5wbmc=
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pbWcyMDIzLmNuYmxvZ3MuY29tL2Jsb2cvMjc0MjIvMjAyMzA2LzI3NDIyLTIwMjMwNjI5MTgzOTQ1NzE1LTE3MjU2MjUzNTUucG5n
这里选自定义，勾选驱动
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pbWcyMDIzLmNuYmxvZ3MuY29tL2Jsb2cvMjc0MjIvMjAyMzA2LzI3NDIyLTIwMjMwNjI5MTg0MDE0ODMxLTIwMTI2NDkwNzIucG5n
定义安装路径
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pbWcyMDIzLmNuYmxvZ3MuY29tL2Jsb2cvMjc0MjIvMjAyMzA2LzI3NDIyLTIwMjMwNjI5MTg0MDIxNTIzLTE5OTY5OTM3NTIucG5n
点击安装
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pbWcyMDIzLmNuYmxvZ3MuY29tL2Jsb2cvMjc0MjIvMjAyMzA2LzI3NDIyLTIwMjMwNjI5MTg0MDI3ODY1LTE1ODA1ODkzMzIucG5n
安装完成后在安装根目录下有drivers文件夹，这里面是我们要的驱动文件
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pbWcyMDIzLmNuYmxvZ3MuY29tL2Jsb2cvMjc0MjIvMjAyMzA2LzI3NDIyLTIwMjMwNjI5MTg0MDM0Njc2LTE3MjkxNDczNzYucG5n
安装前的odbc里面是没有DM驱动的
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pbWcyMDIzLmNuYmxvZ3MuY29tL2Jsb2cvMjc0MjIvMjAyMzA2LzI3NDIyLTIwMjMwNjI5MTg0MDQyODA5LTEyODAxOTk2MzUucG5n
安装后就有了
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pbWcyMDIzLmNuYmxvZ3MuY29tL2Jsb2cvMjc0MjIvMjAyMzA2LzI3NDIyLTIwMjMwNjI5MTg0MDQ5NzIzLTEwNzQyMzY5MTAucG5n
2.3通过odbc增加DM数据源
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pbWcyMDIzLmNuYmxvZ3MuY29tL2Jsb2cvMjc0MjIvMjAyMzA2LzI3NDIyLTIwMjMwNjI5MTg0MDU2MTkxLTE3NDQzMzM4My5wbmc=
2.4配置DM数据库相关信息
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pbWcyMDIzLmNuYmxvZ3MuY29tL2Jsb2cvMjc0MjIvMjAyMzA2LzI3NDIyLTIwMjMwNjI5MTg0MTAzOTA2LTg2ODA5MjUzMS5wbmc=
2.5在SqlServer客户端里创建链接服务器
选错了提供程序发生了报错
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pbWcyMDIzLmNuYmxvZ3MuY29tL2Jsb2cvMjc0MjIvMjAyMzA2LzI3NDIyLTIwMjMwNjI5MTg0MTEyNDAxLTE2NzYxMDQ3MTQucG5n
后面提供程序池改为Microsft OLE DB Provider for ODBC Driver就行
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pbWcyMDIzLmNuYmxvZ3MuY29tL2Jsb2cvMjc0MjIvMjAyMzA2LzI3NDIyLTIwMjMwNjI5MTg0MTIyMDYyLTEyMDY2MjEwNDgucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pbWcyMDIzLmNuYmxvZ3MuY29tL2Jsb2cvMjc0MjIvMjAyMzA2LzI3NDIyLTIwMjMwNjI5MTg0MTI5NzkzLTEyNzAwNjIxMjQucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pbWcyMDIzLmNuYmxvZ3MuY29tL2Jsb2cvMjc0MjIvMjAyMzA2LzI3NDIyLTIwMjMwNjI5MTg0MTM2MTU4LTEwNTk4MDMwMDIucG5n
2.6通过语句查询想要的数据
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pbWcyMDIzLmNuYmxvZ3MuY29tL2Jsb2cvMjc0MjIvMjAyMzA2LzI3NDIyLTIwMjMwNjI5MTg0MTQzODQ5LTE4Mzk5Mjg4NjkucG5n
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！
页:
[1]