目前已经运行了 FreeTDS 0.92.4 / unixODBC 2.3.1,并成功连接了 MSSQL 服务器,并能够执行查询等操作。
我找到了这个 Go 语言的 ODBC 实现列表,并尝试了其中粗体标出的两个:
- BenoyRNair https://github.com/BenoyRNair/godbc/
- 魏广静 https://github.com/weigj/go-odbc
- Mark Severson https://bitbucket.org/miquella/mgodbc
- Luke Mauldin https://github.com/LukeMauldin/lodbc
- Robert Johnstone https://bitbucket.org/rj/odbc3-go/
- brainman http://code.google.com/p/odbc/
mgodbc
我收到了一堆弃用警告 (从头信息看,它们在OSX 10.8及更高版本中被弃用):
cc1: warnings being treated as errors
mgodbc.go: In function 'mSQLColAttribute':
mgodbc.go:31: warning: 'SQLColAttributeW' is deprecated (declared at /usr/include/sqlucode.h:128)
mgodbc.go: At top level:
mgodbc.go:44: warning: 'SQLDisconnect' is deprecated (declared at /usr/include/sql.h:896)
mgodbc.go:51: warning: 'SQLGetDiagRecW' is deprecated (declared at /usr/include/sqlucode.h:233)
mgodbc.go:62: warning: 'SQLGetInfoW' is deprecated (declared at /usr/include/sqlucode.h:273)
mgodbc.go:67: warning: 'SQLBindParameter' is deprecated (declared at /usr/include/sqlext.h:2519)
mgodbc.go:70: warning: 'SQLDriverConnectW' is deprecated (declared at /usr/include/sqlucode.h:336)
mgodbc.go:73: warning: 'SQLSetEnvAttr' is deprecated (declared at /usr/include/sql.h:1120)
mgodbc.go:74: warning: 'SQLFreeHandle' is deprecated (declared at /usr/include/sql.h:942)
mgodbc.go:75: warning: 'SQLSetConnectAttrW' is deprecated (declared at /usr/include/sqlucode.h:245)
mgodbc.go:78: warning: 'SQLGetDiagFieldW' is deprecated (declared at /usr/include/sqlucode.h:223)
mgodbc.go:82: warning: 'SQLRowCount' is deprecated (declared at /usr/include/sql.h:1076)
mgodbc.go:98: warning: 'SQLGetData' is deprecated (declared at /usr/include/sql.h:975)
mgodbc.go:99: warning: 'SQLEndTran' is deprecated (declared at /usr/include/sql.h:902)
mgodbc.go:102: warning: 'SQLCloseCursor' is deprecated (declared at /usr/include/sql.h:831)
mgodbc.go:103: warning: 'SQLPrepareW' is deprecated (declared at /usr/include/sqlucode.h:239)
mgodbc.go:107: warning: 'SQLNumResultCols' is deprecated (declared at /usr/include/sql.h:1058)
mgodbc.go:113: warning: 'SQLAllocHandle' is deprecated (declared at /usr/include/sql.h:799)
mgodbc.go:114: warning: 'SQLExecute' is deprecated (declared at /usr/include/sql.h:921)
mgodbc.go:115: warning: 'SQLFetch' is deprecated (declared at /usr/include/sql.h:924)
mgodbc.go:119: warning: 'SQLNumParams' is deprecated (declared at /usr/include/sqlext.h:2448)
更新
根据go-nuts irc上mac01021的建议,我已经添加了:
#pragma GCC diagnostic ignored "-Wdeprecated-declarations"
这样做可以消除过时警告,但仍无法针对OS X中包含的iODBC进行构建。
将上述行替换为:
#cgo darwin CFLAGS: -I/opt/local/include
现在mgodbc已经构建完成(使用已安装的unixODBC)
尽管在导入时会出现一个小的段错误 =(
ODBC
我遇到了构建错误:
# code.google.com/p/odbc/api
api/api.go:13: undefined: SQLSMALLINT
api/api.go:14: undefined: SQLUSMALLINT
api/api.go:15: undefined: SQLUSMALLINT
api/api.go:19: undefined: SQLSMALLINT
api/api.go:20: undefined: SQLUSMALLINT
api/api.go:21: undefined: SQLUSMALLINT
api/api.go:22: undefined: SQLUSMALLINT
api/api.go:23: undefined: SQLUSMALLINT
api/api.go:24: undefined: SQLUSMALLINT
api/api.go:25: undefined: SQLUINTEGER
api/api.go:25: too many errors
更新
感谢@alex提供信息。我已经使用以下内容修改了api_unix.go
// Copyright 2012 The Go Authors. All rights reserved.
// Use of this source code is governed by a BSD-style
// license that can be found in the LICENSE file.
// +build linux darwin
// +build cgo
package api
// #cgo linux LDFLAGS: -lodbc
// #cgo darwin LDFLAGS: -lodbc
// #cgo darwin CFLAGS: -I /opt/local/include
// #include <sql.h>
// #include <sqlext.h>
import "C"
在OS X中包含的iODBC有一些被列为弃用的内容(我过去使用unixODBC的运气更好)
我已经将-I /opt/local/include
添加到CFLAGS中,希望指向unixODBC头文件,而不是由Apple提供的那些(其中包含弃用警告等)
运行# go build -x
会给我:
WORK=/var/folders/z2/k9vxn7gn6395vb3y2qc7_1040000gn/T/go-build784364461
mkdir -p $WORK/code.google.com/p/odbc/api/_obj/
mkdir -p $WORK/code.google.com/p/odbc/
cd /Users/jr/Development/go/src/code.google.com/p/odbc/api
/usr/local/go/pkg/tool/darwin_amd64/cgo -objdir $WORK/code.google.com/p/odbc/api/_obj/ -- -I /opt/local/include -I $WORK/code.google.com/p/odbc/api/_obj/ api_unix.go
/usr/local/go/pkg/tool/darwin_amd64/6c -F -V -w -I $WORK/code.google.com/p/odbc/api/_obj/ -I /usr/local/go/pkg/darwin_amd64 -o $WORK/code.google.com/p/odbc/api/_obj/_cgo_defun.6 -D GOOS_darwin -D GOARCH_amd64 $WORK/code.google.com/p/odbc/api/_obj/_cgo_defun.c
gcc -I . -g -O2 -fPIC -m64 -pthread -fno-common -print-libgcc-file-name
gcc -I . -g -O2 -fPIC -m64 -pthread -fno-common -I /opt/local/include -I $WORK/code.google.com/p/odbc/api/_obj/ -o $WORK/code.google.com/p/odbc/api/_obj/_cgo_main.o -c $WORK/code.google.com/p/odbc/api/_obj/_cgo_main.c
gcc -I . -g -O2 -fPIC -m64 -pthread -fno-common -I /opt/local/include -I $WORK/code.google.com/p/odbc/api/_obj/ -o $WORK/code.google.com/p/odbc/api/_obj/_cgo_export.o -c $WORK/code.google.com/p/odbc/api/_obj/_cgo_export.c
gcc -I . -g -O2 -fPIC -m64 -pthread -fno-common -I /opt/local/include -I $WORK/code.google.com/p/odbc/api/_obj/ -o $WORK/code.google.com/p/odbc/api/_obj/api_unix.cgo2.o -c $WORK/code.google.com/p/odbc/api/_obj/api_unix.cgo2.c
gcc -I . -g -O2 -fPIC -m64 -pthread -fno-common -o $WORK/code.google.com/p/odbc/api/_obj/_cgo_.o $WORK/code.google.com/p/odbc/api/_obj/_cgo_main.o $WORK/code.google.com/p/odbc/api/_obj/_cgo_export.o $WORK/code.google.com/p/odbc/api/_obj/api_unix.cgo2.o -lodbc
/usr/local/go/pkg/tool/darwin_amd64/cgo -objdir $WORK/code.google.com/p/odbc/api/_obj/ -dynimport $WORK/code.google.com/p/odbc/api/_obj/_cgo_.o -dynout $WORK/code.google.com/p/odbc/api/_obj/_cgo_import.c
/usr/local/go/pkg/tool/darwin_amd64/6c -F -V -w -I $WORK/code.google.com/p/odbc/api/_obj/ -I /usr/local/go/pkg/darwin_amd64 -o $WORK/code.google.com/p/odbc/api/_obj/_cgo_import.6 -D GOOS_darwin -D GOARCH_amd64 $WORK/code.google.com/p/odbc/api/_obj/_cgo_import.c
gcc -I . -g -O2 -fPIC -m64 -pthread -fno-common -o $WORK/code.google.com/p/odbc/api/_obj/_all.o $WORK/code.google.com/p/odbc/api/_obj/_cgo_export.o $WORK/code.google.com/p/odbc/api/_obj/api_unix.cgo2.o -Wl,-r -nostdlib /usr/llvm-gcc-4.2/bin/../lib/gcc/i686-apple-darwin11/4.2.1/x86_64/libgcc.a
/usr/local/go/pkg/tool/darwin_amd64/6g -o $WORK/code.google.com/p/odbc/api/_obj/_go_.6 -p code.google.com/p/odbc/api -D _/Users/jr/Development/go/src/code.google.com/p/odbc/api -I $WORK ./api.go $WORK/code.google.com/p/odbc/api/_obj/_cgo_gotypes.go $WORK/code.google.com/p/odbc/api/_obj/api_unix.cgo1.go
/usr/local/go/pkg/tool/darwin_amd64/pack grcP $WORK $WORK/code.google.com/p/odbc/api.a $WORK/code.google.com/p/odbc/api/_obj/_go_.6 $WORK/code.google.com/p/odbc/api/_obj/_cgo_import.6 $WORK/code.google.com/p/odbc/api/_obj/_cgo_defun.6 $WORK/code.google.com/p/odbc/api/_obj/_all.o
mkdir -p $WORK/code.google.com/p/odbc/_obj/
mkdir -p $WORK/code.google.com/p/
cd /Users/jr/Development/go/src/code.google.com/p/odbc
/usr/local/go/pkg/tool/darwin_amd64/6g -o $WORK/code.google.com/p/odbc/_obj/_go_.6 -p code.google.com/p/odbc -complete -D _/Users/jr/Development/go/src/code.google.com/p/odbc -I $WORK -I /Users/jr/Development/go/pkg/darwin_amd64 ./column.go ./conn.go ./driver.go ./error.go ./handle.go ./odbcstmt.go ./param.go ./result.go ./rows.go ./stats.go ./stmt.go ./tx.go
# code.google.com/p/odbc
./column.go:22: undefined: api.SQLGetData
./column.go:28: undefined: api.SQLBindCol
./column.go:47: undefined: api.SQLDescribeCol
./conn.go:20: undefined: api.SQLAllocHandle
./conn.go:28: undefined: api.SQLDriverConnect
./conn.go:39: undefined: api.SQLDisconnect
./driver.go:26: undefined: api.SQLAllocHandle
./driver.go:34: undefined: api.SQLSetEnvAttr
./driver.go:43: undefined: api.SQLSetEnvAttr
./driver.go:50: undefined: api.SQLSetEnvAttr
./driver.go:50: too many errors
看起来头文件路径被正确地传递了?
但似乎链接还不太正确?
对于SQLGetData
,我在api.go
中的//sys SQLGetData...
注释中确实看到与/opt/local/include/sql.h
中匹配的定义。
更新
顶部提到的这个库:
brainman http://code.google.com/p/odbc/
现在可在OSX上作为go-gettable软件包使用。甚至有文档介绍如何开始使用odbc/tds部分。