Go 1.1.1和ODBC与MSSQL

huangapple
go评论119阅读模式
英文:

Go 1.1.1 and ODBC with MSSQL

问题

目前已经安装并运行了FreeTDS 0.92.4 / unixODBC 2.3.1，可以连接到MSSQL服务器并执行查询等操作。

我找到了这个Go的ODBC实现列表，并尝试了其中两个：

mgodbc

我得到了一堆弃用警告（根据头文件来看，它们在OSX 10.8及更高版本中被弃用）：

  1. cc1: warnings being treated as errors
  2. mgodbc.go: In function 'mSQLColAttribute':
  3. mgodbc.go:31: warning: 'SQLColAttributeW' is deprecated (declared at /usr/include/sqlucode.h:128)
  4. mgodbc.go: At top level:
  5. mgodbc.go:44: warning: 'SQLDisconnect' is deprecated (declared at /usr/include/sql.h:896)
  6. mgodbc.go:51: warning: 'SQLGetDiagRecW' is deprecated (declared at /usr/include/sqlucode.h:233)
  7. mgodbc.go:62: warning: 'SQLGetInfoW' is deprecated (declared at /usr/include/sqlucode.h:273)
  8. mgodbc.go:67: warning: 'SQLBindParameter' is deprecated (declared at /usr/include/sqlext.h:2519)
  9. mgodbc.go:70: warning: 'SQLDriverConnectW' is deprecated (declared at /usr/include/sqlucode.h:336)
  10. mgodbc.go:73: warning: 'SQLSetEnvAttr' is deprecated (declared at /usr/include/sql.h:1120)
  11. mgodbc.go:74: warning: 'SQLFreeHandle' is deprecated (declared at /usr/include/sql.h:942)
  12. mgodbc.go:75: warning: 'SQLSetConnectAttrW' is deprecated (declared at /usr/include/sqlucode.h:245)
  13. mgodbc.go:78: warning: 'SQLGetDiagFieldW' is deprecated (declared at /usr/include/sqlucode.h:223)
  14. mgodbc.go:82: warning: 'SQLRowCount' is deprecated (declared at /usr/include/sql.h:1076)
  15. mgodbc.go:98: warning: 'SQLGetData' is deprecated (declared at /usr/include/sql.h:975)
  16. mgodbc.go:99: warning: 'SQLEndTran' is deprecated (declared at /usr/include/sql.h:902)
  17. mgodbc.go:102: warning: 'SQLCloseCursor' is deprecated (declared at /usr/include/sql.h:831)
  18. mgodbc.go:103: warning: 'SQLPrepareW' is deprecated (declared at /usr/include/sqlucode.h:239)
  19. mgodbc.go:107: warning: 'SQLNumResultCols' is deprecated (declared at /usr/include/sql.h:1058)
  20. mgodbc.go:113: warning: 'SQLAllocHandle' is deprecated (declared at /usr/include/sql.h:799)
  21. mgodbc.go:114: warning: 'SQLExecute' is deprecated (declared at /usr/include/sql.h:921)
  22. mgodbc.go:115: warning: 'SQLFetch' is deprecated (declared at /usr/include/sql.h:924)
  23. mgodbc.go:119: warning: 'SQLNumParams' is deprecated (declared at /usr/include/sqlext.h:2448)

更新

根据go-nuts irc上mac01021的建议，我添加了以下内容：

  1. #pragma GCC diagnostic ignored "-Wdeprecated-declarations"

这样就消除了弃用警告，但仍无法构建与OS X附带的iODBC一起使用的mgodbc。

将上述行替换为：

  1. #cgo darwin CFLAGS: -I/opt/local/include

然后，mgodbc现在可以构建（使用已安装的unixODBC）了，但是在导入时会出现一个小的段错误。

odbc

我得到了构建错误：

  1. # code.google.com/p/odbc/api
  2. api/api.go:13: undefined: SQLSMALLINT
  3. api/api.go:14: undefined: SQLUSMALLINT
  4. api/api.go:15: undefined: SQLUSMALLINT
  5. api/api.go:19: undefined: SQLSMALLINT
  6. api/api.go:20: undefined: SQLUSMALLINT
  7. api/api.go:21: undefined: SQLUSMALLINT
  8. api/api.go:22: undefined: SQLUSMALLINT
  9. api/api.go:23: undefined: SQLUSMALLINT
  10. api/api.go:24: undefined: SQLUSMALLINT
  11. api/api.go:25: undefined: SQLUINTEGER
  12. api/api.go:25: too many errors

更新

感谢@alex提供的cgo信息。我已经使用以下内容修改了api_unix.go：

  1. // Copyright 2012 The Go Authors. All rights reserved.
  2. // Use of this source code is governed by a BSD-style
  3. // license that can be found in the LICENSE file.
  5. // +build linux darwin
  6. // +build cgo
  8. package api
  10. // #cgo linux LDFLAGS: -lodbc
  11. // #cgo darwin LDFLAGS: -lodbc
  12. // #cgo darwin CFLAGS: -I /opt/local/include
  13. // #include <sql.h>
  14. // #include <sqlext.h>
  15. import "C"

OS X附带的iODBC有一些被列为弃用的东西（我过去在unixODBC上运行得更好）。

我将-I /opt/local/include添加到CFLAGS中，希望指向unixODBC的头文件，而不是Apple提供的头文件（其中包含弃用警告等）。

运行# go build -x给我：

  1. WORK=/var/folders/z2/k9vxn7gn6395vb3y2qc7_1040000gn/T/go-build784364461
  2. mkdir -p $WORK/code.google.com/p/odbc/api/_obj/
  3. mkdir -p $WORK/code.google.com/p/odbc/
  4. cd /Users/jr/Development/go/src/code.google.com/p/odbc/api
  5. /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
  6. /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
  7. gcc -I . -g -O2 -fPIC -m64 -pthread -fno-common -print-libgcc-file-name
  8. 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
  9. 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
  10. 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
  11. 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
  12. /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
  13. /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
  14. 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
  15. /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
  16. /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
  17. mkdir -p $WORK/code.google.com/p/odbc/_obj/
  18. mkdir -p $WORK/code.google.com/p/
  19. cd /Users/jr/Development/go/src/code.google.com/p/odbc
  20. /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
  21. # code.google.com/p/odbc
  22. ./column.go:22: undefined: api.SQLGetData
  23. ./column.go:28: undefined: api.SQLBindCol
  24. ./column.go:47: undefined: api.SQLDescribeCol
  25. ./conn.go:20: undefined: api.SQLAllocHandle
  26. ./conn.go:28: undefined: api.SQLDriverConnect
  27. ./conn.go:39: undefined: api.SQLDisconnect
  28. ./driver.go:26: undefined: api.SQLAllocHandle
  29. ./driver.go:34: undefined: api.SQLSetEnvAttr
  30. ./driver.go:43: undefined: api.SQLSetEnvAttr
  31. ./driver.go:50: undefined: api.SQLSetEnvAttr
  32. ./driver.go:50: too many errors

看起来头文件路径包含被正确传递了？
但是似乎链接还不太正确？

对于SQLGetData，我在/opt/local/include/sql.h中看到了与api.go中的//sys SQLGetData...注释相匹配的定义。

UPDATE

顶部提到的库：
> brainman http://code.google.com/p/odbc/

现在可以在OSX上作为可获取的go包使用了。甚至有文档可以帮助您开始使用odbc/tds部分。

英文:

Currently have FreeTDS 0.92.4 / unixODBC 2.3.1 up and running, connecting with a MSSQL server and able to execute queries etc.

I've found this list of ODBC implementations for Go, and have tried the two in bold:

mgodbc

I'm getting a bunch of deprecation warnings (looking at the headers they're deprecated for OSX 10.8 and later):

  1. cc1: warnings being treated as errors
  2. mgodbc.go: In function &#39;mSQLColAttribute&#39;:
  3. mgodbc.go:31: warning: &#39;SQLColAttributeW&#39; is deprecated (declared at /usr/include/sqlucode.h:128)
  4. mgodbc.go: At top level:
  5. mgodbc.go:44: warning: &#39;SQLDisconnect&#39; is deprecated (declared at /usr/include/sql.h:896)
  6. mgodbc.go:51: warning: &#39;SQLGetDiagRecW&#39; is deprecated (declared at /usr/include/sqlucode.h:233)
  7. mgodbc.go:62: warning: &#39;SQLGetInfoW&#39; is deprecated (declared at /usr/include/sqlucode.h:273)
  8. mgodbc.go:67: warning: &#39;SQLBindParameter&#39; is deprecated (declared at /usr/include/sqlext.h:2519)
  9. mgodbc.go:70: warning: &#39;SQLDriverConnectW&#39; is deprecated (declared at /usr/include/sqlucode.h:336)
  10. mgodbc.go:73: warning: &#39;SQLSetEnvAttr&#39; is deprecated (declared at /usr/include/sql.h:1120)
  11. mgodbc.go:74: warning: &#39;SQLFreeHandle&#39; is deprecated (declared at /usr/include/sql.h:942)
  12. mgodbc.go:75: warning: &#39;SQLSetConnectAttrW&#39; is deprecated (declared at /usr/include/sqlucode.h:245)
  13. mgodbc.go:78: warning: &#39;SQLGetDiagFieldW&#39; is deprecated (declared at /usr/include/sqlucode.h:223)
  14. mgodbc.go:82: warning: &#39;SQLRowCount&#39; is deprecated (declared at /usr/include/sql.h:1076)
  15. mgodbc.go:98: warning: &#39;SQLGetData&#39; is deprecated (declared at /usr/include/sql.h:975)
  16. mgodbc.go:99: warning: &#39;SQLEndTran&#39; is deprecated (declared at /usr/include/sql.h:902)
  17. mgodbc.go:102: warning: &#39;SQLCloseCursor&#39; is deprecated (declared at /usr/include/sql.h:831)
  18. mgodbc.go:103: warning: &#39;SQLPrepareW&#39; is deprecated (declared at /usr/include/sqlucode.h:239)
  19. mgodbc.go:107: warning: &#39;SQLNumResultCols&#39; is deprecated (declared at /usr/include/sql.h:1058)
  20. mgodbc.go:113: warning: &#39;SQLAllocHandle&#39; is deprecated (declared at /usr/include/sql.h:799)
  21. mgodbc.go:114: warning: &#39;SQLExecute&#39; is deprecated (declared at /usr/include/sql.h:921)
  22. mgodbc.go:115: warning: &#39;SQLFetch&#39; is deprecated (declared at /usr/include/sql.h:924)
  23. mgodbc.go:119: warning: &#39;SQLNumParams&#39; is deprecated (declared at /usr/include/sqlext.h:2448)

Update

Following a suggestion from mac01021, from go-nuts irc, I've added

  1. #pragma GCC diagnostic ignored &quot;-Wdeprecated-declarations&quot;

This gets rid of the deprecation warnings, but still doesn't build against the included iODBC of OS X

Replacing the above line with:

  1. #cgo darwin CFLAGS: -I/opt/local/include

and voila, mgodbc builds now (using the installed unixODBC)
although now a nice little segfault occurs upon import =(

odbc

I'm getting build errors:

  1. # code.google.com/p/odbc/api
  2. api/api.go:13: undefined: SQLSMALLINT  
  3. api/api.go:14: undefined: SQLUSMALLINT  
  4. api/api.go:15: undefined: SQLUSMALLINT  
  5. api/api.go:19: undefined: SQLSMALLINT  
  6. api/api.go:20: undefined: SQLUSMALLINT  
  7. api/api.go:21: undefined: SQLUSMALLINT  
  8. api/api.go:22: undefined: SQLUSMALLINT  
  9. api/api.go:23: undefined: SQLUSMALLINT  
  10. api/api.go:24: undefined: SQLUSMALLINT  
  11. api/api.go:25: undefined: SQLUINTEGER  
  12. api/api.go:25: too many errors

Update

Thanks @alex for the cgo info. I've modified api_unix.go with the below

  1. // Copyright 2012 The Go Authors. All rights reserved.  
  2. // Use of this source code is governed by a BSD-style  
  3. // license that can be found in the LICENSE file.  
  5. // +build linux darwin  
  6. // +build cgo  
  8. package api  
  10. // #cgo linux LDFLAGS: -lodbc  
  11. // #cgo darwin LDFLAGS: -lodbc  
  12. // #cgo darwin CFLAGS: -I /opt/local/include  
  13. // #include &lt;sql.h&gt;  
  14. // #include &lt;sqlext.h&gt;  
  15. import &quot;C&quot;

The iODBC included with OS X has some things that are listed as deprecated (and I've had better luck with unixODBC in the past)

I've added the -I /opt/local/include to the CFLAGS to, hopefully, point to the unixODBC headers, and not the ones included by Apple (which have the deprecation warnings etc.)

Running # go build -x gives me:

  1. WORK=/var/folders/z2/k9vxn7gn6395vb3y2qc7_1040000gn/T/go-build784364461  
  2. mkdir -p $WORK/code.google.com/p/odbc/api/_obj/  
  3. mkdir -p $WORK/code.google.com/p/odbc/  
  4. cd /Users/jr/Development/go/src/code.google.com/p/odbc/api  
  5. /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  
  6. /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  
  7. gcc -I . -g -O2 -fPIC -m64 -pthread -fno-common -print-libgcc-file-name
  8. 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  
  9. 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  
  10. 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  
  11. 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
  12. /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  
  13. /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  
  14. 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  
  15. /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  
  16. /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  
  17. mkdir -p $WORK/code.google.com/p/odbc/_obj/  
  18. mkdir -p $WORK/code.google.com/p/  
  19. cd /Users/jr/Development/go/src/code.google.com/p/odbc  
  20. /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  
  21. # code.google.com/p/odbc  
  22. ./column.go:22: undefined: api.SQLGetData  
  23. ./column.go:28: undefined: api.SQLBindCol  
  24. ./column.go:47: undefined: api.SQLDescribeCol  
  25. ./conn.go:20: undefined: api.SQLAllocHandle  
  26. ./conn.go:28: undefined: api.SQLDriverConnect  
  27. ./conn.go:39: undefined: api.SQLDisconnect  
  28. ./driver.go:26: undefined: api.SQLAllocHandle  
  29. ./driver.go:34: undefined: api.SQLSetEnvAttr  
  30. ./driver.go:43: undefined: api.SQLSetEnvAttr  
  31. ./driver.go:50: undefined: api.SQLSetEnvAttr  
  32. ./driver.go:50: too many errors

It looks like the header path include is being passed correctly?
But still looks like things are not quite linking correctly?

for SQLGetData I do see a matching definition from the //sys SQLGetData... comment from api.go within /opt/local/include/sql.h

UPDATE

The library mentioned at the top:
> brainman http://code.google.com/p/odbc/

Now works as a go-gettable package on OSX. There's even documentation to get you started with the odbc/tds portions.

答案1

得分: 3

在Windows上：

  1. &gt;go version
  2. go version devel +edd229b63fa4 Wed Jun 26 11:36:18 2013 -0700 windows/amd64
  3. &gt;go get -v code.google.com/p/odbc
  4. code.google.com/p/odbc (下载)
  5. code.google.com/p/odbc/api
  6. code.google.com/p/odbc
  7. &gt;go get -v bitbucket.org/miquella/mgodbc
  8. bitbucket.org/miquella/mgodbc (下载)
  9. bitbucket.org/miquella/mgodbc
  10. &gt;

在Linux上：

  1. $ go version
  2. go version devel +65e2aba21abe Wed Jun 26 13:14:11 2013 -0700 linux/amd64
  3. $ sudo apt-get install unixodbc unixodbc-dev
  4. 读取软件包列表... 完成
  5. 构建依赖树       
  6. 读取状态信息... 完成
  7. unixodbc 已经是最新版本。
  8. unixodbc-dev 已经是最新版本。
  9. 0 升级，0 新安装，0 用于删除和 10 未升级。
  10. $ go get -v code.google.com/p/odbc
  11. code.google.com/p/odbc (下载)
  12. code.google.com/p/odbc/api
  13. code.google.com/p/odbc
  14. $ go get -v bitbucket.org/miquella/mgodbc
  15. bitbucket.org/miquella/mgodbc (下载)
  16. bitbucket.org/miquella/mgodbc
  17. $

在Darwin上，您似乎遇到了SQL头文件的问题。

  1. /usr/include/sql.h
  2. /usr/include/sqlext.h
  3. /usr/include/sqltypes.h
  4. /usr/include/sqlucode.h

请联系odbc软件包的作者报告这些问题。

更新：

当您告诉我们错误

  1. mgodbc.go:180: cannot convert &amp;state[0] (type *uint16) to type *_Ctype_SQLWCHAR

您没有告诉我们_Ctype_SQLWCHAR的类型。我们只能猜测！我猜它应该是这样的

  1. package main
  3. func main() {
  4. 	type _Ctype_ushort uint16
  5. 	type _Ctype_WCHAR _Ctype_ushort
  6. 	type _Ctype_SQLWCHAR _Ctype_WCHAR
  7. 	var state [6]uint16
  8. 	// (*C.SQLWCHAR)(&amp;state[0])
  9. 	_ = (*_Ctype_SQLWCHAR)(&amp;state[0])
  10. }

这个代码可以编译通过，没有错误。

更新：

使用系统化的方法解决问题。

阅读有关Go构建约束的文档：Build Constraints, Package build。

阅读code.google.com/p/odbc/api中的文件。

在code.google.com/p/odbc/api中搜索文件。

  1. $ grep -r &#39;linux&#39; *
  2. api_unix.go:// +build linux
  3. api_unix.go:// #cgo linux LDFLAGS: -lodbc
  4. Makefile:	GOOS=linux ./mksyscall_unix.pl $^ \
  5. mksyscall_unix.pl:// +build linux
  6. mksyscall_unix.pl:// #cgo linux LDFLAGS: -lodbc
  7. zapi_unix.go:// +build linux
  8. zapi_unix.go:// #cgo linux LDFLAGS: -lodbc
  9. $

显然，在阅读了api_unix.go、zapi_unix.go、mksyscall_unix.pl和Makefile文件之后，当修改了api_unix.go文件时，应该同时修改zapi_unix.go文件。您可能没有这样做。因此，darwin没有包含在zapi_unix.go的构建约束中。您显示为未定义的api包名称在zapi_unix.go中有定义。

  1. api.SQLGetData
  2. api.SQLBindCol  
  3. api.SQLDescribeCol  
  4. api.SQLAllocHandle  
  5. api.SQLDriverConnect  
  6. api.SQLDisconnect  
  7. api.SQLAllocHandle  
  8. api.SQLSetEnvAttr
英文:

On Windows:

  1. &gt;go version
  2. go version devel +edd229b63fa4 Wed Jun 26 11:36:18 2013 -0700 windows/amd64
  3. &gt;go get -v code.google.com/p/odbc
  4. code.google.com/p/odbc (download)
  5. code.google.com/p/odbc/api
  6. code.google.com/p/odbc
  7. &gt;go get -v bitbucket.org/miquella/mgodbc
  8. bitbucket.org/miquella/mgodbc (download)
  9. bitbucket.org/miquella/mgodbc
  10. &gt;

On Linux:

  1. $ go version
  2. go version devel +65e2aba21abe Wed Jun 26 13:14:11 2013 -0700 linux/amd64
  3. $ sudo apt-get install unixodbc unixodbc-dev
  4. Reading package lists... Done
  5. Building dependency tree       
  6. Reading state information... Done
  7. unixodbc is already the newest version.
  8. unixodbc-dev is already the newest version.
  9. 0 upgraded, 0 newly installed, 0 to remove and 10 not upgraded.
  10. $ go get -v code.google.com/p/odbc
  11. code.google.com/p/odbc (download)
  12. code.google.com/p/odbc/api
  13. code.google.com/p/odbc
  14. $ go get -v bitbucket.org/miquella/mgodbc
  15. bitbucket.org/miquella/mgodbc (download)
  16. bitbucket.org/miquella/mgodbc
  17. $

On Darwin, you seem to have issues with SQL header files.

  1. /usr/include/sql.h
  2. /usr/include/sqlext.h
  3. /usr/include/sqltypes.h
  4. /usr/include/sqlucode.h

Contact the odbc package authors to report these problems.

UPDATE:

When you tell us about the error

  1. mgodbc.go:180: cannot convert &amp;state[0] (type *uint16) to type *_Ctype_SQLWCHAR

you don't tell us what the type of _Ctype_SQLWCHAR is. We can only guess! My guess would be that it should look like this

  1. package main
  3. func main() {
  4. 	type _Ctype_ushort uint16
  5. 	type _Ctype_WCHAR _Ctype_ushort
  6. 	type _Ctype_SQLWCHAR _Ctype_WCHAR
  7. 	var state [6]uint16
  8. 	// (*C.SQLWCHAR)(&amp;state[0])
  9. 	_ = (*_Ctype_SQLWCHAR)(&amp;state[0])
  10. }

which compiles with no errors.

UPDATE:

Use a systematic approach to problem solving.

Read about Go build contraints: Build Constraints, Package build.

Read the files in code.google.com/p/odbc/api.

Grep the files in code.google.com/p/odbc/api.

  1. $ grep -r &#39;linux&#39; *
  2. api_unix.go:// +build linux
  3. api_unix.go:// #cgo linux LDFLAGS: -lodbc
  4. Makefile:	GOOS=linux ./mksyscall_unix.pl $^ \
  5. mksyscall_unix.pl:// +build linux
  6. mksyscall_unix.pl:// #cgo linux LDFLAGS: -lodbc
  7. zapi_unix.go:// +build linux
  8. zapi_unix.go:// #cgo linux LDFLAGS: -lodbc
  9. $

Clearly, after reading the api_unix.go, zapi_unix.go, mksyscall_unix.pl, and Makefile files, when the api_unix.go file is modified, the zapi_unix.go file should be modified too.

You probably didn't do that. Therefore, darwin is not included in the zapi_unix.go build constraints. The package api names that you show as undefined are defined in zapi_unix.go.

  1. api.SQLGetData
  2. api.SQLBindCol  
  3. api.SQLDescribeCol  
  4. api.SQLAllocHandle  
  5. api.SQLDriverConnect  
  6. api.SQLDisconnect  
  7. api.SQLAllocHandle  
  8. api.SQLSetEnvAttr

huangapple
  • 本文由 发表于 2013年6月27日 03:28:45
  • 转载请务必保留本文链接：https://go.coder-hub.com/17328798.html
  • go
  • odbc
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定