[Bug 2084531] Re: Can't open cursor lib '/etc/libodbccr.so' : file not found

[garblixa]

You are right, the package unixodbc-dev installs the symbolic link
/usr/lib/x86_64-linux-gnu/libodbccr.so -> libodbccr.so.2.0.0

This means to me that the php8.1-odbc package has a missing dependency
on unixodbc-dev. So I will report a corresponding bug there.

So this report can be closed.

Thanks again!

** Changed in: unixodbc (Ubuntu)
       Status: Incomplete => Invalid

** Changed in: unixodbc (Ubuntu)
       Status: Invalid => New

** Changed in: unixodbc (Ubuntu)
       Status: New => Invalid

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

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

Status in unixodbc package in Ubuntu:
  Invalid

Bug description:
  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

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