unable to load lsqlite3

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.