Installing odbc connection in KDB

https://learninghub.kx.com/forums/topic/installing-odbc-connection-in-kdb

Hi Community,

I was setting up odbc in my window computer following the article https://code.kx.com/q/interfaces/q-client-for-odbc/ but I’m getting an error.

This is how my q directory looks like:

kc.lic
odbc.dll
odbc.k
q.k
 w64

And I’m getting this error:

q)l odbc.k 'The specified module could not be found. [4] C:qodbc.k:2: k){.odbc[x]:`odbc 2:(`$(-"1"=*|$x)_$x;y)}

Anyone knows what is my error here?

Thanks,

Richard

I just found out. So the odbc.k file goes into the q directory and odbc.dll goes into the W64 folder!

Hi Richard,

Thanks for the question, glad to see you found out the answer.

And thanks for leaving the question up for others that might have the same query!

Happy coding,

Laura