Matthew-Zong / odbc

Automatically exported from code.google.com/p/odbc
BSD 3-Clause "New" or "Revised" License
0 stars 0 forks source link

SQLDescribeParam: {07009} [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index #20

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
I have an "Invalid Descriptor Index" error when I do the query in the attached 
testcase patch.

What steps will reproduce the problem?

D:\rapport\GOPATH\src\code.google.com\p\odbc>go test -v -mssrv=ip -msdb=db 
-msuser=user -mspass=pw -run=MS
=== RUN TestMSSQLCreateInsertDelete
--- PASS: TestMSSQLCreateInsertDelete (0.14 seconds)
=== RUN TestMSSQLTransactions
--- PASS: TestMSSQLTransactions (0.12 seconds)
=== RUN TestMSSQLTypes
--- PASS: TestMSSQLTypes (0.03 seconds)
=== RUN TestMSSQLIntAfterText
--- PASS: TestMSSQLIntAfterText (0.00 seconds)
=== RUN TestMSSQLStmtAndRows
--- PASS: TestMSSQLStmtAndRows (0.03 seconds)
=== RUN TestMSSQLIssue5
--- PASS: TestMSSQLIssue5 (0.27 seconds)
=== RUN TestMSSQLDeleteNonExistent
--- PASS: TestMSSQLDeleteNonExistent (0.02 seconds)
=== RUN TestMSSQLSelectInt
--- FAIL: TestMSSQLSelectInt (0.00 seconds)
        mssql_test.go:886: SQLDescribeParam: {07009} [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index
                {42000} [Microsoft][ODBC SQL Server Driver]Syntax error or access violation
FAIL
exit status 1
FAIL    code.google.com/p/odbc  0.969s

What version of the product are you using? On what operating system?
Windows XP and 7 (64-bits)

Please provide any additional information below.
It works fine on Linux.
Microsoft SQL Server 2005 (9.0.3042)
go version go1.1.2 windows/386

The test passes if I do :
if err := db.QueryRow("select 123456;").Scan(&got); err != nil {

Original issue reported on code.google.com by bigras.b...@gmail.com on 29 Aug 2013 at 6:40

Attachments:

GoogleCodeExporter commented 9 years ago
Let me think about it. Thank you.

Alex

Original comment by alex.bra...@gmail.com on 30 Aug 2013 at 6:31

GoogleCodeExporter commented 9 years ago
Please, review https://codereview.appspot.com/13454045/

Alex

Original comment by alex.bra...@gmail.com on 5 Sep 2013 at 5:48

GoogleCodeExporter commented 9 years ago
This issue was closed by revision d64013ec9967.

Original comment by alex.bra...@gmail.com on 13 Sep 2013 at 2:09