Have error api/api_unix.go:15:11: fatal error: 'sql.h' file not found

[tayalone]

I got the error
api/api_unix.go:15:11: fatal error: 'sql.h' file not found

OS: OS X
unixODBC: 2.3.12

[alexbrainman]

This error comes from cgo. If you installed unixODBC libraries, then cgo should be able to find unixODBC sql.h file. Can you build small C program that uses unixODBC package?

Alex

[bdgca-wjp]

You need install unixodbc package. For example, on Ubuntu you would need to do:

sudo apt install unixodbc-dev

[hut8]

I'm getting the same error and am rather confused by it...

go get github.com/alexbrainman/odbc/api # works fine
go get github.com/alexbrainman/odbc # works fine

Then if I execute:

mkdir odbctest
cd odbctest
go mod init odbctest

then put this in main.go in that folder:

package main

import (
	"database/sql"

	_ "github.com/alexbrainman/odbc"
)

func querySources() {
	sourceDB, err := sql.Open("odbc", "DSN=my_dsn_goes_here")
	if err != nil {
		panic(err)
	}
	defer sourceDB.Close()
}

func main() {
  querySources()
}

Then run go build from that directory, it fails with:

# github.com/alexbrainman/odbc/api
../../go/pkg/mod/github.com/alexbrainman/odbc@v0.0.0-20240810052813-bcbcb6842ce9/api/api_unix.go:15:11: fatal error: 'sql.h' file not found
 #include <sql.h>
          ^~~~~~~
1 error generated.

Here's proof that I have it:

$ find /opt/homebrew -iname 'sql.h'                                                                                                                                                     
/opt/homebrew/include/sql.h
/opt/homebrew/Cellar/mailutils/3.17/include/mailutils/sql.h
/opt/homebrew/Cellar/zig/0.13.0/lib/zig/libc/include/any-windows-any/sql.h
/opt/homebrew/Cellar/unixodbc/2.3.12/include/sql.h

$ brew info unixodbc
==> unixodbc: stable 2.3.12 (bottled)
ODBC 3 connectivity for UNIX
https://www.unixodbc.org/
Conflicts with:
  virtuoso (because both install `isql` binaries)
Installed
/opt/homebrew/Cellar/unixodbc/2.3.12 (47 files, 2.3MB) *
  Poured from bottle using the formulae.brew.sh API on 2023-08-16 at 16:35:33
From: https://github.com/Homebrew/homebrew-core/blob/HEAD/Formula/u/unixodbc.rb
License: LGPL-2.1-or-later
==> Dependencies
Required: libtool ✔
==> Analytics
install: 18,758 (30 days), 57,966 (90 days), 304,584 (365 days)
install-on-request: 2,108 (30 days), 6,370 (90 days), 34,881 (365 days)
build-error: 5 (30 days)

[hut8]

Running this command gets me a working executable, but prints out warnings:

$ CGO_CFLAGS="-I/opt/homebrew/Cellar/unixodbc/2.3.12/include" CGO_LDFLAGS="-L/opt/homebrew/Cellar/unixodbc/2.3.12/lib" go build
# inventory
ld: warning: ignoring duplicate libraries: '-lodbc'
ld: warning: search path '/usr/local/opt/unixodbc/lib' not found

[alexbrainman]

@hut8

I don't use Mac OS myself.

But try following https://github.com/alexbrainman/odbc/wiki/GettingStartedOnOSX , perhaps it will help.

Alex

[hut8]

I appreciate you writing that page for us Mac users 😄 Unfortunately I did actually follow those directions, and the weird part that really confuses me is that go get succeeded without errors but then actually trying to use the package only partly succeeded (with warnings).

However, the actual issue is now immaterial for me because Informix, which I am burdened with using, stopped making the ODBC driver for Mac, and the latest one they have doesn't work with recent versions of OSX 😓

[FACorreiaa]

I am having a similar error

# command-line-arguments
ld: warning: ignoring duplicate libraries: '-lodbc'
ld: warning: search path '/usr/local/opt/unixodbc/lib' not found

Some env variables I have added:

export CGO_CFLAGS="-I/opt/homebrew/opt/unixodbc/include"
export CGO_LDFLAGS="-L/opt/homebrew/opt/unixodbc/lib"

my files do exist:

❯ ls /opt/homebrew/opt/unixodbc/lib

libodbc.2.dylib     libodbc.dylib       libodbccr.a         libodbcinst.2.dylib libodbcinst.dylib
libodbc.a           libodbccr.2.dylib   libodbccr.dylib     libodbcinst.a       pkgconfig

pkg-config also seems to return the right path.

❯ pkg-config --libs odbc

-L/opt/homebrew/Cellar/unixodbc/2.3.12/lib -lodbc

I am on the most recent version of macos. And I think that will be an issue too. go run