Public bug reported:

unixodbc is used with freetds to connect to mssql databases with PHP.

The following PHP connect string is used:
odbc_connect(DSN, USER, PASSWORD, SQL_CUR_USE_ODBC);

SQL_CUR_USE_ODBC is used to speed up database access. The following
error occurs:

##################
PHP Warning: odbc_connect(): SQL error: [unixODBC][Driver Manager]Can't open 
cursor lib ‘/etc/libodbccr.so’ : file not found, SQL state 01000 in SQLConnect
Error: >>[unixODBC][Driver Manager]Can't open cursor lib ‘/etc/libodbccr.so’ : 
file not found<<
##################

unixodbc or libodbc2 may be searching for libodbccr.so in the wrong
place. Perhaps it should be searching for libodbccr.so.2.0.0.

Setting the following symbolic link fixes the problem:
ln -s /usr/lib/x86_64-linux-gnu/libodbccr.so.2.0.0 
/usr/lib/x86_64-linux-gnu/libodbccr.so


ProblemType: Bug
ApportVersion: 2.20.11-0ubuntu82.6
Architecture: amd64
CasperMD5CheckResult: pass
Date: Tue Oct 15 12:09:03 2024
Dependencies:
 gcc-12-base 12.3.0-1ubuntu1~22.04
 libc6 2.35-0ubuntu3.8
 libcrypt1 1:4.4.27-1
 libgcc-s1 12.3.0-1ubuntu1~22.04
 libidn2-0 2.3.2-2build1
 libltdl7 2.4.6-15build2
 libunistring2 1.0-1
DistroRelease: Ubuntu 22.04
InstallationDate: Installed on 2023-02-28 (595 days ago)
InstallationMedia: Ubuntu-Server 22.04.2 LTS "Jammy Jellyfish" - Release amd64 
(20230217.1)
NonfreeKernelModules: bmhook tmhook
Package: libodbc2:amd64 2.3.9-5ubuntu0.1
PackageArchitecture: amd64
ProcCpuinfoMinimal:
 processor      : 1
 vendor_id      : GenuineIntel
 cpu family     : 6
 model          : 63
 model name     : Intel(R) Xeon(R) Gold 6354 CPU @ 3.00GHz
 stepping       : 0
 microcode      : 0xd0003b9
 cpu MHz                : 2992.968
 cache size     : 39936 KB
 physical id    : 2
 siblings       : 1
 core id                : 0
 cpu cores      : 1
 apicid         : 2
 initial apicid : 2
 fpu            : yes
 fpu_exception  : yes
 cpuid level    : 13
 wp             : yes
 flags          : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov 
pat pse36 clflush mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm 
constant_tsc arch_perfmon nopl xtopology tsc_reliable nonstop_tsc cpuid 
tsc_known_freq pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe 
popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm 
invpcid_single pti ssbd ibrs ibpb stibp fsgsbase tsc_adjust bmi1 avx2 smep bmi2 
invpcid xsaveopt arat md_clear flush_l1d arch_capabilities
 bugs           : cpu_meltdown spectre_v1 spectre_v2 spec_store_bypass l1tf mds 
swapgs itlb_multihit mmio_stale_data retbleed bhi
 bogomips       : 5985.93
 clflush size   : 64
 cache_alignment        : 64
 address sizes  : 43 bits physical, 48 bits virtual
 power management:
ProcEnviron:
 LANGUAGE=
 TERM=linux
 PATH=(custom, no user)
 LANG=de_DE.UTF-8
 SHELL=/bin/bash
ProcVersionSignature: Ubuntu 5.15.0-122.132-generic 5.15.163
SourcePackage: unixodbc
Tags:  jammy
Uname: Linux 5.15.0-122-generic x86_64
UpgradeStatus: No upgrade log present (probably fresh install)
_MarkForUpload: True

** Affects: unixodbc (Ubuntu)
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/2084531

Title:
  Can't open cursor lib '/etc/libodbccr.so' : file not found

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/unixodbc/+bug/2084531/+subscriptions


-- 
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to