RE: Vo veci: unable to load lsqlite3

["Weinstein, Jay" <Jay.Weinstein@...>]

Hi,

Finally got it up and running.   Had to copy lsqlite3.dll to \work\lua\bin.   Probably points to my environment isn't setup correctly. :-)   The link https://github.com/is73/Lua-5.3-Portable-Batteries-Windows-10-32bit/blob/master/manual.md#5 was really helpful.

Thanks!!

Jay

-----Original Message-----
From: lua-l-bounces@lists.lua.org [mailto:lua-l-bounces@lists.lua.org] On Behalf Of Pavel Drotar
Sent: Thursday, August 04, 2016 1:04 PM
To: Lua mailing list
Subject: Re: Vo veci: unable to load lsqlite3

Just one thing Jay.

variable sqlite created by this call:

local sqlite = require("lsqlite3")

is not a function it is the Lua table contaning functions and global variables so you can't call it as:

sqlite()

instead try something like this

local sqlite = require("lsqlite3")
local db = sqlite.open("data.db")
... etc, etc,

here is documentation:
http://keplerproject.github.io/luasql/manual.html

all drivers including sqlite3 uses common luasql inteface

I.

> ** Thu, 04 Aug 2016 21:43:57 +0200 - "Lua mailing list" 
> <lua-l@lists.lua.org> **
>
> Hi Jay,
> 
> look into my test.lua and require sqlite3 module as:
> 
> local sqlite = require("lsqlite3") --- first letter is small "L" 
> letter your "require" line is missing this letter
> 
> so run lua.exe and in interpreter enter this:
> > local sqlite = require("lsqlite3")
> 
> :)
> 
> > ** Thu, 4 Aug 2016 17:34:29 +0000 - "Lua mailing list" 
> > <lua-l@lists.lua.org> **
> >
> > Hi Pavel,
> > 
> > This is what I get with lua_ok.   
> > C:\Users\Jay.Weinstein\Downloads\lua_ok\bin>lua.exe
> > Lua 5.3.3  Copyright (C) 1994-2016 Lua.org, PUC-Rio
> > > local sqlite = require("sqlite3")
> > error loading module 'sqlite3' from file 'C:\Users\Jay.Weinstein\Downloads\lua_ok\bin\sqlite3.dll':
> >         The specified procedure could not be found.
> > 
> > stack traceback:
> >         [C]: in ?
> >         [C]: in function 'require'
> >         stdin:1: in main chunk
> >         [C]: in ?
> > > local sqlite = require("lsqlite3")
> > > sqlite()
> > stdin:1: attempt to call a nil value (global 'sqlite') stack 
> > traceback:
> >         stdin:1: in main chunk
> >         [C]: in ?
> > 
> >  I also ran the test.bat and I didn't notice any errors.   I also have installed lua, luarocks, and sqlite using the instructions found at https://github.com/is73/Lua-5.3-Portable-Batteries-Windows-10-32bit.
> > 
> > I don't have LUA_PATH, LUA_CPATH, or any LUA_.... environment parameters set.   My PATH is set as follows:
> > 
> > C:\ProgramData\Oracle\Java\javapath;\\leviton.inc\SysVol\leviton.inc
> > \Policies\{174FEA63-A905-46A3-8A56-88E183EB5AD8}\Machine\Scripts\Sta
> > rtup;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program 
> > Files\Intel\iCLS 
> > Client\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\W
> > indows\System32\WindowsPowerShell\v1.0\;C:\Program Files 
> > (x86)\Java\jre6\bin;C:\Program Files\Intel\Intel(R) Management 
> > Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management 
> > Engine Components\IPT;C:\Program Files (x86)\Intel\Intel(R) 
> > Management Engine Components\DAL;C:\Program Files 
> > (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program 
> > Files (x86)\QuickTime\QTSystem\;O:\;C:\Program 
> > Files\TortoiseSVN\bin:C:\sqlite\sqlite-tools-win32-x86-3130000;C:\Mi
> > nGW\bin:C:\"Program Files"\Java\jdk1.8.0_91\bin;C:\Program Files 
> > (x86)\7-Zip;C:\Program Files 
> > (x86)\GnuWin32\bin;C:\work\lua\bin;C:\work\luarocks
> > 
> > Thanks,
> > Jay
> > 
> > -----Original Message-----
> > From: lua-l-bounces@lists.lua.org 
> > [mailto:lua-l-bounces@lists.lua.org] On Behalf Of Pavel Drotar
> > Sent: Thursday, August 04, 2016 8:04 AM
> > To: Lua mailing list
> > Subject: Re: Vo veci: unable to load lsqlite3
> > 
> > Hi Jay,
> > 
> > you can try my distro
> > https://github.com/is73/Lua-5.3-Portable-Batteries-Windows-10-32bit
> > 
> > > ** Wed, 3 Aug 2016 22:05:30 +0000 - "Lua mailing list" 
> > > <lua-l@lists.lua.org> **
> > >
> > > Thanks, but it didn't work.  
> > > 
> > > Jay
> > > 
> > > -----Original Message-----
> > > From: lua-l-bounces@lists.lua.org 
> > > [mailto:lua-l-bounces@lists.lua.org] On Behalf Of gmc1
> > > Sent: Wednesday, August 03, 2016 1:52 PM
> > > To: Lua mailing list
> > > Subject: Vo veci: unable to load lsqlite3
> > > 
> > > 
> > > try lsqlite3
> > > 
> > > Odosielateľ
> > > 
> > > "Weinstein, Jay" <Jay.Weinstein@leviton.com> napísal:
> > > 
> > > Hi,
> > >  
> > > I’m new to lua and I can’t seem to figure out how to get around the following problem.   
> > >  
> > > Thanks,
> > > Jay
> > >  
> > > > local table = require("sqlite3")
> > > stdin:1: module 'sqlite3' not found:
> > >         no field package.preload['sqlite3']
> > >         no file 'C:\Program Files (x86)\Lua\5.1\sqlite3.lua'
> > >         no file 'C:\Users\Jay.Weinstein\Downloads\Binaries-LuaDist-batteries-0.9.8-Windows-x86\lib\lua\5.1\luasql'
> > > stack traceback:
> > >         [C]: in function 'require'
> > >         stdin:1: in main chunk
> > >         [C]: ? ‘C:\Users\Jay.Weinstein\Downloads\Binaries-LuaDist-batteries-0.9.8-Windows-x86\lib\lua\5.1\luasql'
> > >  
> > > I’ve added C:\Users\Jay.Weinstein\Downloads\Binaries-LuaDist-batteries-0.9.8-Windows-x86\lib\lua\5.1\luasql to lua_cpath and lua_path and sqlite3.dll is in thhe luasql directory.