string type : sql: converting argument $1 type: invalid type given

[l-we]

	"database/sql"

	_ "github.com/thda/tds"
)

func main() {
	cnxStr := "tds://my_user:my_password@dbhost.com:5000/pubs?charset=utf8"
	db, err := sql.Open("tds", cnxStr)
	if err != nil {
		log.Fatal(err)
	}

	id := "1"
	rows, err := db.Query("select * from authors where id = ?", id)
	…
}

[thda]

Hi,

I've published a fix in the relax-int-types branch.
Can you please let me know if it works for you?

Thanks

[l-we]

No, My table
id varchar(255)

[thda]

Could you please give the the output of: select @@version

please ?

[l-we]

SAP IQ/16.0.110.2707/10870/P/sp11.18 INSTRUMENTED/Enterprise Linux64 - x86_64 - 2.6.18-194.el5/64bit/2018-08-03 01:59:49

[thda]

Thanks. I will update the readme stating that prepared statement do not work with IQ.
I do not have access to sybase iq anymore, as my company has stopped using it.

[thda]

Do you know where I can find a docker image with IQ ?

[l-we]

rows, err := db.Query(`select * from authors where id = '` + id + `' `)

is ok

[ISim]

Hi all,
unfortunately I have to work with very old sybase (select @@Version shows ver: 12.0.1.3827). I've tried pure go driver github.com/SAP/go-ase, but this doesn't support encryption methods below TDS_MSG_SEC_ENCRYPT4. So I was glad to find this driver but I ran into the same bug:

err := db.QueryRow("select name from subscriptions where subscriber_name = ?", "A29983").Scan(&name)

hangs up indefinitely. I was a little bit perplexed because

err := db.QueryRow("select name from subscriptions where subscriber_name = 'A29983'").Scan(&name)

works like a charm. I added readTimeout=5 to connection string and after five seconds the error pops up:

sql: converting argument $1 type: invalid type given

The name column type is 'R' and base_type is 'varchar(64)' - according to information retrieved from systabcol

Can I gather another info to help you to fix this bug?

I.