search

alexbrainman / odbc

odbc driver written in go
BSD 3-Clause "New" or "Revised" License
356 stars 141 forks source link

an error of SQL syntax error #163

Open hyeinkwon798 opened 3 years ago

hyeinkwon798 commented 3 years ago

Hi I'm trying to use odbc driver to connect Altibase using Golang I have installed unixODBC and go get this odbc driver Finally there is no error with the connection between db and golang using sql.Open( ) but the test dosen't work having error below

SQLPrepare: {42000} SQL syntax error line 1: parse error select * from TEST

I have used query := fmt.Sprintf("select * from %s", "TEST" ) rows, err := adb.Query("query)

there is nothing wrong with the query (I have checked in the command)

Need some help! thank you

alexbrainman commented 3 years ago

@hyeinkwon798 the error message you provided is coming from ODBC driver code not from github.com/alexbrainman/odbc. I don't know why the driver complains. It is hard to guess without me trying your code. And I don't plan to try, because I don't use Altibase myself. So you have to try and debug this yourself.

Alex