Linux下odbc的安装配置和wxODBC的开发
linux 下的ODBC 有两种：unixODBC 和iodbc ，由于wxGTK 提供的是对iodbc 的支持，因此在安装wxGTK 前需要先安装iodbc 。在后面安
安装
linux 下的ODBC 有两种：unixODBC 和iodbc ，由于wxGTK 提供的是对iodbc 的支持，因此在安装wxGTK 前需要先安装iodbc 。在后面安装freetds 时，依据环境和依赖关系可能会将unixODBC 也装上，iodbc 和unixODBC 修改的ODBC 配置文件都是/etc/odbc.ini 和/etc/odbcinst.ini ，这两个都是ODBC 驱动的管理器，没有冲突问题，但如果要使用wxODBC 进行ODBC 的开发，iodbc 是必须要安装的。
安装 iodbc
如果有yum 源中包括libiodbc ，可直接使用yum install libiodbc* 或在yumex 中搜索iodbc 的包进行安装，否则需要到网上下载相关的rpm 包进行安装。
下载libiodbc-3.52.6-1.i386.rpm
下载libiodbc-devel-3.52.6-1.i386.rpm
下载 libiodbc-admin-3.52.6-1.i386.rpm
下载libiodbc-3.52.6-1.src.rpm
rpm -ivh libiodbc-3.52.6-1.i386.rpm
rpm -ivh libiodbc-devel-3.52.6-1.i386.rpm
rpm -ivh libiodbc-admin-3.52.6-1.i386.rpm
rpm -ivh libiodbc-3.52.6-1.src.rpm
安装wxGTK
./configure --with-odbc --enable-monolithic --enable-xrc --enable-unicode
make
make install
安装 codeblocks
cp /usr/local/share/aclocal/wxwin.m4 /usr/share/aclocal/wxwine.m4
./bootstrap ( 可能需执行aclocal)
./configure --with-contrib-plugins=all
make
makeinstall
连接 SQL Server
安装 freetds
yum install freetds ＊
( 或安装yum yumex 后，执行yumex ，到所有包里搜索freetds, 安装找到的包，有三个，另两个是develop 包和doc 包)
配置 ODBC 驱动
/usr/bin/iodbcadm-gtk
到ODBC Drivers 中点ADD a driver
在description of driver 中填入对驱动连接数据库的描述如MSSQL 或SQL server
在driver file name 中填入/usr/lib/libtdsodbc.so( 具体路径可能有因版本有差异，可搜索libtdsodbc.so 找到具体的路径)
在Setup file name 中填入/usr/lib/libtds.so( 具体路径可能有差异)
点击OK 保存ODBC 驱动的设置
配置 DSN
在 iodbcadm-gtk 切换到system DSN
点击Add, 在出现的窗口中选择要使用的配置好的驱动后点击OK
Data Source Name (DSN) 中填入新建的DSN 源的名称
新建如下Keyword, 并填入值
Keyword Value
Database 使用的数据库
Port 使用的端口号(SQL Server 为1433)
Server 服务器( 可使用IP 地址)
TDS_Version 8.0
Trace No
点OK 保存DSN
点击Test 测试该数据源，弹出窗中填入用户名密码后点OK 看测试情况
点OK 退出iodbcadm-gtk
可使用
isql -v DSN 名 用户名密码
连接DSN
MySQL
安装驱动
用yumex 检查mysql-connector-odbc 包有没有安装，如果没有，使用yum install mysql-connector-odbc 进行安装
配置 ODBC 驱动
在iodbcadm-gtk 中切换到ODBC Drivers ，点击ADD a driver
在description of driver 中填入对驱动连接数据库的描述如MySQL
在driver file name 中填入/usr/lib/libmyodbc3.so( 名称按mysql 的驱动版本可能不同，，如可能会是libmyodbc.so )
在Setup file name 中填入/usr/lib/libodbcmyS.so 具体路径可能有差异)
点击OK 保存ODBC 驱动的设置
配置 DSN
在 iodbcadm-gtk 切换到system DSN
点击Add, 在出现的窗口中选择要使用的配置好的驱动后点击OK
Data Source Name (DSN) 中填入新建的DSN 源的名称
新建如下Keyword, 并填入值
Keyword Value
Database 使用的数据库
Server 服务器( 可使用IP 地址)
user 用户名
password 密码
点OK 保存DSN
然后可点Test 测试或在命令行下用
isql -v DSN 名 用户名密码
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
Using Task Manager in Linux
Aug 15, 2024 am 07:30 AM
There are many questions that Linux beginners often ask, "Does Linux have a Task Manager?", "How to open the Task Manager on Linux?" Users from Windows know that the Task Manager is very useful. You can open the Task Manager by pressing Ctrl+Alt+Del in Windows. This task manager shows you all the running processes and the memory they consume, and you can select and kill a process from the task manager program. When you first use Linux, you will also look for something that is equivalent to a task manager in Linux. A Linux expert prefers to use the command line to find processes, memory consumption, etc., but you don't have to
Solve the problem of garbled display of graphs and charts on Zabbix Chinese monitoring server
Jul 31, 2024 pm 02:10 PM
Zabbix's support for Chinese is not very good, but sometimes we still choose Chinese for management purposes. In the web interface monitored by Zabbix, the Chinese under the graphic icon will display small squares. This is incorrect and requires downloading fonts. For example, "Microsoft Yahei", "Microsoft Yahei.ttf" is named "msyh.ttf", upload the downloaded font to /zabbix/fonts/fonts and modify the two characters in the /zabbix/include/defines.inc.php file at define('ZBX_GRAPH_FONT_NAME','DejaVuSans');define('ZBX_FONT_NAME'
7 ways to help you check the registration date of Linux users
Aug 24, 2024 am 07:31 AM
Did you know, how to check the creation date of an account on a Linux system? If you know, what can you do? Did you succeed? If yes, how to do it? Basically Linux systems don't track this information, so what are the alternative ways to get this information? You may ask why am I checking this? Yes, there are situations where you may need to review this information and it will be helpful to you at that time. You can use the following 7 methods to verify. Use /var/log/secure Use aureport tool Use .bash_logout Use chage command Use useradd command Use passwd command Use last command Method 1: Use /var/l
What should I do if the WPS missing fonts under the Linux system causes the file to be garbled?
Jul 31, 2024 am 12:41 AM
1. Find the fonts wingdings, wingdings2, wingdings3, Webdings, and MTExtra from the Internet. 2. Enter the main folder, press Ctrl+h (show hidden files), and check if there is a .fonts folder. If not, create one. 3. Copy the downloaded fonts such as wingdings, wingdings2, wingdings3, Webdings, and MTExtra to the .fonts folder in the main folder. Then start wps to see if there is still a "System missing font..." reminder dialog box. If not, just Success! Notes: wingdings, wingdin
Teach you how to add fonts to Fedora in 5 minutes
Jul 23, 2024 am 09:45 AM
System-wide installation If you install a font system-wide, it will be available to all users. The best way to do this is to use RPM packages from the official software repositories. Before starting, open the "Software" tool in Fedora Workstation, or other tools using the official repository. Select the "Add-ons" category in the selection bar. Then select "Fonts" within the category. You'll see the available fonts similar to the ones in the screenshot below: When you select a font, some details will appear. Depending on several scenarios, you may be able to preview some sample text for the font. Click the "Install" button to add it to your system. Depending on system speed and network bandwidth, this process may take some time to complete
toss! Running DOS on Raspberry Pi
Jul 19, 2024 pm 05:23 PM
Different CPU architectures mean that running DOS on the Raspberry Pi is not easy, but it is not much trouble. FreeDOS may be familiar to everyone. It is a complete, free and well-compatible operating system for DOS. It can run some older DOS games or commercial software, and can also develop embedded applications. As long as the program can run on MS-DOS, it can run on FreeDOS. As the initiator and project coordinator of FreeDOS, many users will ask me questions as an insider. The question I get asked most often is: "Can FreeDOS run on a Raspberry Pi?" This question is not surprising. After all, Linux runs very well on the Raspberry Pi
How to connect two Ubuntu hosts to the Internet using one network cable
Aug 07, 2024 pm 01:39 PM
How to use one network cable to connect two ubuntu hosts to the Internet 1. Prepare host A: ubuntu16.04 and host B: ubuntu16.042. Host A has two network cards, one is connected to the external network and the other is connected to host B. Use the iwconfig command to view all network cards on the host. As shown above, the network cards on the author's A host (laptop) are: wlp2s0: This is a wireless network card. enp1s0: Wired network card, the network card connected to host B. The rest has nothing to do with us, no need to care. 3. Configure the static IP of A. Edit the file #vim/etc/network/interfaces to configure a static IP address for interface enp1s0, as shown below (where #==========
How to hide your Linux command line history
Aug 17, 2024 am 07:34 AM
If you are a Linux command line user, sometimes you may not want certain commands to be recorded in your command line history. There could be many reasons, for example, you hold a certain position in a company and you have certain privileges that you don't want others to abuse. Or maybe there are some particularly important commands that you don't want to execute by mistake while browsing the history list. However, is there a way to control which commands go into the history list and which don't? Or in other words, can we enable incognito mode like a browser in a Linux terminal? The answer is yes, and depending on the specific goals you want, there are many ways to achieve it. In this article, we’ll discuss some proven methods. Note: All commands appearing in this article have been tested under Ubuntu. different
