alexbrainman / odbc

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

Cannot connect tibero database with go lang #158

Open ChungHyup opened 3 years ago

ChungHyup commented 3 years ago

I'm using Tibero 6 Database for my project and I've already configured unixODBC.

and I can connect with isql / iodbctest

# Works well! I can query.
$ isql Tibero6
$ iodbctest "DSN=Tibero6"

But I got error when I connect db with go odbc lib.

  # main.go
  db, err := sql.Open("odbc", "DSN=Tibero6")
  #Stdout
2021/06/03 14:02:42 SQLDriverConnect: {IM002} [unixODBC][Driver Manager]Data source name not found, and no default driver specified
exit status 1

what can I check to fix this issue?

alexbrainman commented 3 years ago

I have never used Tibero Database myself. So I do not know.

2021/06/03 14:02:42 SQLDriverConnect: {IM002} [unixODBC][Driver Manager]Data source name not found, and no default driver specified e

Looks like you connection string "DSN=Tibero6" is wrong. You should ask someone who uses that database. Or ask their support.

Alex

reiwav commented 3 years ago

I runing in windows with odbc vs Tibero. But, when running in linux, source not working. Error SQLDriverConnect: {I} [unixODBC]. Please check

alexbrainman commented 3 years ago

I runing in windows with odbc vs Tibero. But, when running in linux, source not working. Error SQLDriverConnect: {I} [unixODBC]. Please check

@reiwav if you are talking to me, then I don't understand what you are saying. Please, try again.

Thank you.

Alex

reiwav commented 3 years ago

Hi. I use your source code with tibero database. The source code runs on the windows operating system. But, when I use Linux OS, the source code doesn't work. I get the SQLDriverConnect unclear error message: {I} [unixODBC]


TRẦN MẠNH LONG Email: @.** **@.**> Phone: 08.1881.3399*

Vào Th 7, 4 thg 9, 2021 vào lúc 08:15 Alex Brainman < @.***> đã viết:

I runing in windows with odbc vs Tibero. But, when running in linux, source not working. Error SQLDriverConnect: {I} [unixODBC]. Please check

@reiwav https://github.com/reiwav if you are talking to me, then I don't understand what you are saying. Please, try again.

Thank you.

Alex

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/alexbrainman/odbc/issues/158#issuecomment-912882729, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALZI56TBY27ROVPUN4N3MDLUAFXLXANCNFSM45775XNQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

alexbrainman commented 3 years ago

@reiwav

Thanks for explaining.

I am glad this package works for you on Windows.

Unfortunately, like I said above, I don't use Tibero database. You cannot expect me to install and learn all things about Tibero database to be able to help you here. You have to debug this problem yourself.

Alex

reiwav commented 3 years ago

Ok. Tks you!


TRẦN MẠNH LONG Email: @.** **@.**> Phone: 08.1881.3399*

Vào Th 7, 4 thg 9, 2021 vào lúc 08:49 Alex Brainman < @.***> đã viết:

@reiwav https://github.com/reiwav

Thanks for explaining.

I am glad this package works for you on Windows.

Unfortunately, like I said above, I don't use Tibero database. You cannot expect me to install and learn all things about Tibero database to be able to help you here. You have to debug this problem yourself.

Alex

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/alexbrainman/odbc/issues/158#issuecomment-912887484, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALZI56QAKGXYSYT2X2UIC4TUAF3JLANCNFSM45775XNQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

reiwav commented 3 years ago

I tried using the for_issue_88 branch, and it works with tibero. But when using order by, there are no rows returned. Did you change anything from the master branch?

alexbrainman commented 3 years ago

I tried using the for_issue_88 branch, and it works with tibero. But when using order by, there are no rows returned. Did you change anything from the master branch?

I don't understand your question. Yes for_issue_88 and master branch codes are different. If that is what you are asking.

Alex