安装freetds报错sql.h not found

最新推荐文章于 2021-05-16 23:10:29 发布
原创 最新推荐文章于 2021-05-16 23:10:29 发布 · 1.2k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#php

本文介绍了如何解决在安装freetds过程中遇到的sql.h找不到的问题。通过指定unixodbc的安装路径，可以成功定位到sql.h文件，确保freetds的正确配置与安装。
部署运行你感兴趣的模型镜像

如果安装freetds出现sql.h not found错误，则需要指定unixodbc的路径

当unixodbc安装在/usr/local下是，sql.h则会在/usr/local/include下

./configure --with-unixodbc=/usr/local --prefix=/usr/local/lib

您可能感兴趣的与本文相关的镜像

Stable-Diffusion-3.5

Stable-Diffusion-3.5

图片生成
Stable-Diffusion

Stable Diffusion 3.5 (SD 3.5) 是由 Stability AI 推出的新一代文本到图像生成模型，相比 3.0 版本，它提升了图像质量、运行速度和硬件效率

linux 通过 freetds下访问sqlserver
red10057的专栏
04-27 2692
编译安装freetds 需要root用户，不然make install会报错 $ tar zxvf freetds-stable.tgz（解压） $ ./configure --prefix=/usr/local/freetds --with-tdsver=8.0 --enable-msdblib $ make $ make install 连接测试 /usr/local
airflow安装过程各种报错解决办法
入眸幻灭的博客
03-06 3806
在mac(10.14.3 ) +python3.6.5上安装airflow(注意不要用3.7，airflow initdb时会引入tenacity的包（from tenacity.async import AsyncRetrying）async在python3.7版本被加入了关键字，导致airflow无法在python3.7运行，https://github.com/jd/tenacity/iss...
安装freetds报错sql.hnotfound
yangyouchang的专栏
09-20 1209
安装freetds报错sql.h not found 处理办法： 1.编辑configure vim ./configure 如下图所示： 找到$with_unixodbc中的 test -r "$ODBC_INC/sql.h" || as_fn_error $? "sql.h not found" "$LINENO" 5 这段代码 修改成 test -r "$ODB...
R语言之安装RODBC错误信息configure: error: "ODBC headers sql.hand sqlext.h not found"
木小鱼的笔记
03-24 6325
R语言之安装RODBC错误信息configure: error: "ODBC headers sql.hand sqlext.h not found"
使用github.com/lunny/godbc,找不到sql.h
chouchenpei4000的博客
09-01 224
centos7 使用github.com/lunny/godbc,找不到sql.h 解决办法: sudo yum install unixODBC-devel 转载于:https...
linux sql.h 找不到,sqlfront.h 没有那个文件或目录
weixin_39572409的博客
05-16 998
[wyq@localhost ~]$ sudo pip install pymssqlDownloading/unpacking pymssqlDownloading pymssql-2.1.0.tar.bz2 (1.9MB): 0% 8.2kBDownloading pymssql-2.1.0.tar.bz2 (1.9MB): 1.9MB downloadedRunning setup.p...
(venv) gapinyc@DESKTOP-9QS7RL5:~/superset$ sudo apt install freetds-bin [sudo] password for gapinyc: Reading package lists... Done Building dependency tree... Done Reading state information... Done freetds-bin is already the newest version (1.3.6-1). 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. (venv) gapinyc@DESKTOP-9QS7RL5:~/superset$ # 查看当前系统使用的 freetds.conf 路径 freerds-config --freetds-conf freerds-config: command not found (venv) gapinyc@DESKTOP-9QS7RL5:~/superset$
11-06
如果有报错（比如缺少 `sybdb.h`），就说明缺头文件： ```bash # 安装头文件 sudo apt install libsybdb-dev ``` 然后再重装： ```bash pip install pymssql ``` --- ## ✅ 最终建议：切换为 `pyodbc` + ...
(venv) gapinyc@DESKTOP-9QS7RL5:~/superset$ tdsver tdsver: command not found (venv) gapinyc@DESKTOP-9QS7RL5:~/superset$ sudo apt update sudo apt install -y freetds-dev freetds-bin tdsodbc [sudo] password for gapinyc: Get:1 http://security.ubuntu.com/ubuntu jammy-security InRelease [129 kB] Hit:2 http://archive.ubuntu.com/ubuntu jammy InRelease Hit:3 https://packages.microsoft.com/ubuntu/22.04/prod jammy InRelease Get:4 http://archive.ubuntu.com/ubuntu jammy-updates InRelease [128 kB] Hit:5 https://deb.nodesource.com/node_18.x nodistro InRelease Get:6 http://security.ubuntu.com/ubuntu jammy-security/universe amd64 c-n-f Metadata [22.4 kB] Get:7 http://archive.ubuntu.com/ubuntu jammy-backports InRelease [127 kB] Fetched 407 kB in 2s (202 kB/s) Reading package lists... Done Building dependency tree... Done Reading state information... Done All packages are up to date. Reading package lists... Done Building dependency tree... Done Reading state information... Done The following additional packages will be installed: freetds-common libct4 libodbc1 libodbccr2 libsybdb5 The following NEW packages will be installed: freetds-bin freetds-common freetds-dev libct4 libodbc1 libodbccr2 libsybdb5 tdsodbc 0 upgraded, 8 newly installed, 0 to remove and 0 not upgraded. Need to get 1132 kB of archives. After this operation, 4347 kB of additional disk space will be used. Get:1 http://archive.ubuntu.com/ubuntu jammy/main amd64 freetds-common all 1.3.6-1 [26.3 kB] Get:2 http://archive.ubuntu.com/ubuntu jammy/main amd64 libsybdb5 amd64 1.3.6-1 [194 kB] Get:3 http://archive.ubuntu.com/ubuntu jammy/universe amd64 freetds-bin amd64 1.3.6-1 [209 kB] Get:4 http://archive.ubuntu.com/ubuntu jammy/main amd64 libct4 amd64 1.3.6-1 [168 kB] Get:5 http://archive.ubuntu.com/ubuntu jammy/main amd64 freetds-dev amd64 1.3.6-1 [309 kB] Get:6 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 libodbccr2 amd64 2.3.9-5ubuntu0.1 [16.7 kB] Get:7 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 libodbc1 amd64 2.3.9-5ubuntu0.1 [2546 B] Get:8 http://archive.ubuntu.com/ubuntu jammy/main amd64 tdsodbc amd64 1.3.6-1 [206 kB] Fetched 1132 kB in 2s (560 kB/s) Preconfiguring packages ... Selecting previously unselected package freetds-common. (Reading database ... 55226 files and directories currently installed.) Preparing to unpack .../0-freetds-common_1.3.6-1_all.deb ... Unpacking freetds-common (1.3.6-1) ... Selecting previously unselected package libsybdb5:amd64. Preparing to unpack .../1-libsybdb5_1.3.6-1_amd64.deb ... Unpacking libsybdb5:amd64 (1.3.6-1) ... Selecting previously unselected package freetds-bin. Preparing to unpack .../2-freetds-bin_1.3.6-1_amd64.deb ... Unpacking freetds-bin (1.3.6-1) ... Selecting previously unselected package libct4:amd64. Preparing to unpack .../3-libct4_1.3.6-1_amd64.deb ... Unpacking libct4:amd64 (1.3.6-1) ... Selecting previously unselected package freetds-dev. Preparing to unpack .../4-freetds-dev_1.3.6-1_amd64.deb ... Unpacking freetds-dev (1.3.6-1) ... Selecting previously unselected package libodbccr2:amd64. Preparing to unpack .../5-libodbccr2_2.3.9-5ubuntu0.1_amd64.deb ... Unpacking libodbccr2:amd64 (2.3.9-5ubuntu0.1) ... Selecting previously unselected package libodbc1:amd64. Preparing to unpack .../6-libodbc1_2.3.9-5ubuntu0.1_amd64.deb ... Unpacking libodbc1:amd64 (2.3.9-5ubuntu0.1) ... Selecting previously unselected package tdsodbc:amd64. Preparing to unpack .../7-tdsodbc_1.3.6-1_amd64.deb ... Unpacking tdsodbc:amd64 (1.3.6-1) ... Setting up freetds-common (1.3.6-1) ... Setting up libodbccr2:amd64 (2.3.9-5ubuntu0.1) ... Setting up libsybdb5:amd64 (1.3.6-1) ... Setting up tdsodbc:amd64 (1.3.6-1) ... Setting up freetds-bin (1.3.6-1) ... Setting up libct4:amd64 (1.3.6-1) ... Setting up libodbc1:amd64 (2.3.9-5ubuntu0.1) ... Setting up freetds-dev (1.3.6-1) ... Processing triggers for man-db (2.10.2-1) ... Processing triggers for libc-bin (2.35-0ubuntu3.11) ... (venv) gapinyc@DESKTOP-9QS7RL5:~/superset$ tdsver tdsver: command not found (venv) gapinyc@DESKTOP-9QS7RL5:~/superset$
11-06
tdsver: command not found ``` 这是正常的！因为 **`tdsver` 并不是一个真实存在的命令**。 --- ## ✅ 正确的测试方式：使用 `tsql`（不是 `tdsver`） 你在网上看到的 `tdsver` 可能是误传或拼写错误。 ...
mac 安装pymssql
Jason_WangYing的博客
07-08 1768
我们在mac环境下想连接mssqlserver数据库，首先要考虑的就是使用pymssql库，而pymssql是在freedts的基础上研发的，所以要先安装freedts，但是安装这个库之前还需有有一系列的支撑库 brew installunixodbc pip installCython pip install setuptools_git 我们正常直接使用pip install pymssql时会报下面的错误 Jason-MacBook-Pro:~ wangying$ pip instal..
(venv) gapinyc@DESKTOP-9QS7RL5:~/superset$ tsql -H 192.168.110.219 -p 1433 -U sa -P sasa -d TestDB tsql: invalid option -- 'd' Usage: tsql [-a <appname>] [-S <server> | -H <hostname> -p <port>] -U <username> [-P <password>] [-I <config file>] [-o <options>] [-t delim] [-r delim] [-D database] or: tsql -C or: tsql -L -H <hostname> If -C is specified just print configuration and exit. If -L is specified with a host name (-H) instances found are printed. -a specify application name -S specify server entry in freetds.conf to connect -H specify hostname to connect -p specify port to connect to -U specify username to use -P specify password to use -D specify database name to use -I specify old configuration file (called interface) to use -J specify character set to use -v verbose mode -o options: f Do not print footer h Do not print header t Print time information v Print TDS version q Quiet Delimiters can be multi-char strings appropriately escaped for your shell. Default column delimitor is <tab>; default row delimiter is <newline> (venv) gapinyc@DESKTOP-9QS7RL5:~/superset$
最新发布
11-06
| `-S <server_name>` | 使用 `freetds.conf` 中定义的服务名（可替代 `-H -p -D`） | --- ### ✅ 推荐方式：通过 `/etc/freetds/freetds.conf` 简化连接 编辑配置文件： ```ini [mydb] host = 192.168.110.219...
freetds安装使用
06-10
在Linux系统上通过ODBC技术访问 Windows系统上的SqlSever数据库.配置过程
centos、php、unixODBC、freetds连接sqlserver、sybase等数据库_嗼淰_新浪博客
yangyouchang的专栏
01-05 1380
1.准备软件 php-7.1 下载地址：http://php.net/downloads.php​ unixodbc-2.3.4 下载地址：http://www.unixodbc.org/ freetds 下载地址：http://www.freetds.org/index.html 2. 优先安装unixodbc tar zxf unixODBC-2.3...
suse安装unixODBC问题记录
Adnerly的专栏
11-09 2265
一,安装unixODBC 1,下载unixODBC最新版本:http://www.unixodbc.org/ 2,#tar zxvf unixODBC-2.3.7.tar.gz 3,#cd unixODBC-2.3.7 4,#./configure --prefix=/usr/local/unixODBC-2.3.7 --includedir=/usr/include --libdir=/...
【Nginx】configure 报错checking for C compiler … not found
zclinux的博客
02-19 7230
编译安装在执行./configure步骤报错，是因为缺少环境变量 checking for C compiler … not found ./configure: error: C compiler cc is not found 解决办法，安装环境需要 yum install gcc gcc-c++ -y 看到这里稍等，如果没有安装openssl openssl-devel 也会编译失败 报错如下 ./configure: error: the HTTP rewrite module
mac php-7.4.3安装问题
houzhimin的专栏
03-02 2381
mac brew install php74 失败，brew 库php74尚未更新。 自己下载最新版php安装过程中出现错误： php-7.4 fatal error: 'libxml/parser.h' file not found 处理方法： 将libxml的目录软链到 include 目录 解决问题 ln -s /usr/local/Cellar/libxml2/2.9.7/i...
linux编译找不到sql.h
weixin_30580943的博客
07-16 2337
参考：http://blog.csdn.net/coder_xia/article/details/6746166 sudo apt-get install libiodbc2 sudo apt-get install libiodbc2-dev 转载于:https://www.cnblogs.com/sig3/p/4011808.html
PHP编译安装时常见错误解决办法，php编译常见错误
牛奔的博客
08-27 462
This article is post on https://coderwall.com/p/ggmpfa configure: error: xslt-config not found. Please reinstall the libxslt >= 1.1.0 distribution复制代码 代码如下: yum -y install libxslt-develconfigure: ...
Linux下安装MS SQL扩展：freetds-patched.tar.gz教程
这通常涉及到编辑配置文件，如`/etc/freetds/freetds.conf`，以设置正确的服务器地址、端口、使用的TDS版本、认证信息等。 5. **测试连接**：配置完成后，需要测试连接是否成功。FreeTDS提供了多种工具来测试连接，...
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值