Hi Jon, Your connection string is wrong; please see
http://jsoftware.com/jwiki/JDD/Methods/Connect Working example: require'data/ddsqlite' db=: ''conew'jddsqlite' ddcon__db'database=',(jpath'~temp/test.db'),';nocreate=0' 4349166272 If you only want to access existing databases, you can drop the nocreate parameter. Best, Marc On Sat, Nov 22, 2014 at 6:26 PM, bill lam <[email protected]> wrote: > try add jpath to supply a real file path. > On Nov 22, 2014 4:50 PM, "Jon Hough" <[email protected]> wrote: > >> I am attempting to use the Sqlite addon (ddsqlite) with J and am >> struggling to get a db connection. >> Environment:Linux Ubuntu 14.x, J802/3Sqlite 3 >> >> My code so far is: >> >> load 'data/ddsqlite' >> >> >> >> >> db =: '' conew 'jddsqlite' >> >> >> >> >> [ch=. ddcon__db '~/j803/testdb' >> >> >> this returns -1. It seems it cannot find my sqlite database, testdb. >> >> >> Of course, the obvious question is 'did I put my database in the correct >> place?'. >> >> >> The answer is yes, as doing >> >> >> >> >> ]d =: fread <'~/j803/db' >> >> >> doesn't fail. >> >> >> Any help appreciated. >> Thanks, >> >> >> Jon >> >> ---------------------------------------------------------------------- >> For information about J forums see http://www.jsoftware.com/forums.htm >> > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
