Mirror of forum.nim-lang.org

571 :: How does one use odbcsql?

[2014-09-27T00:32:09+02:00]

StLa (orginal) [2014-09-27T00:32:09+02:00] view original

Hi,

I tried to use odbcsql. Unfortunately there is no example in the documentation. In Python I use odbc(with pyodbc) like this:

import pyodbc

cnxn = pyodbc.connect('DSN=MYDSN;PWD=MYPASSWORD') cursor = cnxn.cursor() query = "SELECT name FROM table" cursor.execute(query) names = cursor.fetchall()

for name in names:

print name

How would I write that in Nim?

Araq (orginal) [2014-09-27T02:03:53+02:00] view original

Don't use odbcsql. Use db_sqlite, db_mysql, db_postgre instead.

StLa (orginal) [2014-09-27T11:58:21+02:00] view original

Thanks for the response.

I want to connect to a Sybase Anywhere 12 database. That is not possible with the libraries you mentioned, isn't it?

Araq (orginal) [2014-09-27T14:59:08+02:00] view original

Indeed, but you're better off to wrap the native library for Sybase Anywhere 12 instead of using a generic interface that loses features or performance or both.