Package Details: msodbcsql 18.4.1.1-1

Git Clone URL: https://aur.archlinux.org/msodbcsql.git (read-only, click to copy)
Package Base: msodbcsql
Description: Microsoft® ODBC Driver 18 for SQL Server®
Upstream URL: https://techcommunity.microsoft.com/t5/sql-server-blog/bg-p/SQLServer/label-name/SQLServerDrivers
Keywords: microsoft msodbcsql mssqldriver odbc sqlserver
Licenses: custom
Submitter: mtorromeo
Maintainer: neo-clon
Last Packager: neo-clon
Votes: 31
Popularity: 0.001233
First Submitted: 2016-10-06 14:48 (UTC)
Last Updated: 2024-08-04 00:02 (UTC)

Latest Comments

1 2 3 4 Next › Last »

mkurz commented on 2025-04-27 23:03 (UTC) (edited on 2025-04-27 23:04 (UTC) by mkurz)

Hi!

msodbcsql 18 ships not just x86_64 but also aarch64 - just look at https://packages.microsoft.com/rhel/9.0/prod/Packages/m/ where you can find msodbcsql18-18*.x86_64.rpm and msodbcsql18-18*.aarch64.rpm files.

mssql-tools from the AUR already takes into account both architecture when downloading the package (see its PKGBUILD). Could we please do the same here? It's very simple, we just have to use ${CARCH} in the url which will be replaced with x86_64 or aarch64, depending on which machine you run makepkg.

Here is the necessary diff (you can test that with CARCH=aarch64 makepkg -scAL -f for aarch64):

diff --git a/.SRCINFO b/.SRCINFO
index 0320464..2c16828 100644
--- a/.SRCINFO
+++ b/.SRCINFO
@@ -5,6 +5,7 @@ pkgbase = msodbcsql
    url = https://techcommunity.microsoft.com/t5/sql-server-blog/bg-p/SQLServer/label-name/SQLServerDrivers
    install = msodbcsql.install
    arch = x86_64
+   arch = aarch64
    license = custom
    depends = unixodbc
    depends = krb5
diff --git a/PKGBUILD b/PKGBUILD
index 2a24118..6800d29 100644
--- a/PKGBUILD
+++ b/PKGBUILD
@@ -6,13 +6,15 @@ pkgname=msodbcsql
pkgver=18.4.1.1
pkgrel=1
pkgdesc="Microsoft® ODBC Driver 18 for SQL Server®"
-arch=('x86_64')
+arch=('x86_64' 'aarch64')
url="https://techcommunity.microsoft.com/t5/sql-server-blog/bg-p/SQLServer/label-name/SQLServerDrivers"
license=('custom')
depends=('unixodbc' 'krb5' 'curl')
options=('!strip')
-source=(https://packages.microsoft.com/rhel/9/prod/Packages/m/msodbcsql18-$pkgver-1.x86_64.rpm)
-sha256sums=('572265bfb20e8c5a5c6d727d62fe55035ced35ceecbcdc3b5a84c52b78267bb1')
+source_x86_64=(https://packages.microsoft.com/rhel/9/prod/Packages/m/msodbcsql18-$pkgver-1.${CARCH}.rpm)
+source_aarch64=($source_x86_64)
+sha256sums_x86_64=('572265bfb20e8c5a5c6d727d62fe55035ced35ceecbcdc3b5a84c52b78267bb1')
+sha256sums_aarch64=('8aa25ca3eb4a35f6b68f132bd7d19847fd235147efc80fe3201679fe49e2a3f8')
install=msodbcsql.install

package() {

neo-clon commented on 2023-10-30 18:40 (UTC)

Thank you!

Was fixed on msodbcsql-18.3.2.1-2

jsimon0 commented on 2023-10-30 18:21 (UTC)

Correct checksum as of this comment.

# Maintainer: Massimiliano Torromeo <massimiliano.torromeo@gmail.com>
# Contributor: Vitor Rodrigues <vitor.rodrigues@gmail.com>
# Contributor: Jorge Cervantes <jorge.cervantes.e@gmail.com>

pkgname=msodbcsql
pkgver=18.3.2.1
pkgrel=1
pkgdesc="Microsoft® ODBC Driver 18 for SQL Server®"
arch=('x86_64')
url="https://techcommunity.microsoft.com/t5/sql-server-blog/bg-p/SQLServer/label-name/SQLServerDrivers"
license=('custom')
depends=('unixodbc' 'krb5' 'curl')
options=('!strip')
source=(https://packages.microsoft.com/rhel/8/prod/msodbcsql18-$pkgver-1.x86_64.rpm)
sha256sums=('ecd8e148138ee72a452a5357e380580e2c19219c5424f4ac9350cbdf3217fad1')
install=msodbcsql.install

package() {
  install -Dm0644 usr/share/doc/msodbcsql18/RELEASE_NOTES "$pkgdir"/usr/share/doc/$pkgname/RELEASE_NOTES
  install -Dm0644 usr/share/doc/msodbcsql18/LICENSE.txt "$pkgdir"/usr/share/licenses/$pkgname/LICENSE.txt
  mv opt "$pkgdir"

  mv "$pkgdir"/opt/microsoft/msodbcsql{18,}
  ln -s msodbcsql "$pkgdir"/opt/microsoft/msodbcsql18

  cd "$pkgdir"/opt/microsoft/msodbcsql
  sed 's/msodbcsql18/msodbcsql/g' -i etc/odbcinst.ini
}

fsyy commented on 2023-10-30 17:41 (UTC)

sha256sum verify failed for msodbcsql18-18.3.2.1-1.x86_64.rpm

Irish commented on 2023-05-10 21:39 (UTC)

diff --git a/PKGBUILD b/PKGBUILD
index 1fdda0f..4cbec70 100644
--- a/PKGBUILD
+++ b/PKGBUILD
@@ -2,7 +2,7 @@
 # Contributor: Vitor Rodrigues <vitor.rodrigues@gmail.com>

 pkgname=msodbcsql
-pkgver=18.1.2.1
+pkgver=18.2.1.1
 pkgrel=2
 pkgdesc="Microsoft® ODBC Driver 18 for SQL Server®"
 arch=('x86_64')
@@ -11,7 +11,7 @@ license=('custom')
 depends=('unixodbc' 'krb5' 'curl')
 options=('!strip')
 source=(https://packages.microsoft.com/rhel/8/prod/msodbcsql18-$pkgver-1.x86_64.rpm)
-sha256sums=('6b873170f9e27babd5d9698ad2f00546101793b8ef747cba52a2d3080b18dde6')
+sha256sums=('857c2e82e5723aa1c5637d0b55fdecb728ba5610f5b3e09bff9df8f034a42a5e')
 install=msodbcsql.install

 package() {

This diff should work to get people updated to the most recent version (as of this comment, anyway).

neo-clon commented on 2023-03-12 22:06 (UTC)

No works with database 2008 R2 and 2012 :(

vS0uz4 commented on 2023-01-28 01:10 (UTC)

Adjusted the url of microsoft's blog and the package path!

LNico commented on 2023-01-28 00:58 (UTC)

Remove '/Packages/m' from the url

vS0uz4 commented on 2023-01-27 13:59 (UTC)

curl: (22) The requested URL returned error: 404 ==> ERRO: Falha ao baixar https://packages.microsoft.com/rhel/8/prod/Packages/m/msodbcsql18-18.1.2.1-1.x86_64.rpm Abortando... -> erro ao construir: msodbcsql

nivaldomcj commented on 2022-11-26 18:10 (UTC)

As @erichoog said, one should edit the source URL to work, otherwise it shows NOT FOUND error when installing package.