Open ndurchx opened 3 months ago
@ndurchx how did you install the freetds
package? Did you build from source or downloaded binary RPMs? The driver is usually in a separate package. If you build locally it is freetds-unixodbc
. Other distros will provide a freetds-libs
.
The list of packages when built locally using latest stable release from ftp.freetds.org
:
freetds-1.4-1.x86_64.rpm
freetds-debuginfo-1.4-1.x86_64.rpm
freetds-debugsource-1.4-1.x86_64.rpm
freetds-devel-1.4-1.x86_64.rpm
freetds-doc-1.4-1.x86_64.rpm
freetds-unixodbc-1.4-1.x86_64.rpm
freetds-unixodbc-debuginfo-1.4-1.x86_64.rpm
The setup has been done through AWS Elastic Beanstalk. Platform PHP 8.1 running on 64bit Amazon Linux 2023/4.1.0 freetds has already been installed on the system. The only additional install was nodejs.
AL2023 comes with unixODBC
but you still need the freetds-unixodbc
package. Notice the error message '/usr/lib64/libtdsodbc.so' : file not found
That's because libtdsodbc.so
is provided by freetds-unixodbc
:
[ec2-user] $ rpm -q --provides freetds-unixodbc
freetds-unixodbc = 1.4.10-1
freetds-unixodbc(x86-64) = 1.4.10-1
libtdsodbc.so.0()(64bit)
and /etc/odbcinst.ini
entries:
[FreeTDS]
Description=FreeTDS unixODBC Driver
Driver=/usr/lib64/libtdsodbc.so.0
Setup=/usr/lib64/libtdsodbc.so.0
UsageCount=2
[SQL Server]
Description=FreeTDS unixODBC Driver
Driver=/usr/lib64/libtdsodbc.so.0
Setup=/usr/lib64/libtdsodbc.so.0
UsageCount=1
The package is not available. Perhaps because of the aarch64 architecture.
I solved it for me by installing the Microsoft ODBC Driver. But this should be just a temporary workaround.
Describe the bug Connection to MSSQL Server ist not working with odbc:FreeTDS. I don´t see another possibility to connect to MSSQL.
To Reproduce Try connect via odbc to MSSQL Server; Driver FreeTDS dsn:
odbc:Driver={FreeTDS};Server=;Database=
Expected behavior There should be atleast one possibility to connect to MSSQL
Error message
Error: SQLSTATE[01000] SQLDriverConnect: 0 [unixODBC][Driver Manager]Can't open lib '/usr/lib64/libtdsodbc.so' : file not found
Additional context Instance class: t4g.small The missing lib is set in /etc/odbcinst.ini