About SQLite and MS

General Macro Scheduler discussion

Moderators: Dorian (MJT support), JRL

Post Reply
Reimon
Pro Scripter
Posts: 55
Joined: Wed Mar 31, 2004 4:46 pm

About SQLite and MS

Post by Reimon » Mon Jan 11, 2010 10:23 am

Hi,

Has someone ever treated a SQLite database with Macro Scheduler? Please could you give me any examples?

Thanks and Regards,

Reimon

User avatar
Marcus Tettmar
Site Admin
Posts: 7378
Joined: Thu Sep 19, 2002 3:00 pm
Location: Dorset, UK
Contact:

Post by Marcus Tettmar » Mon Jan 11, 2010 11:13 am

I haven't used it myself but as long as there is a connection provider available you should be fine with the native database functions.

Found this:
http://www.connectionstrings.com/sqlite

I also found various references to other ODBC drivers via google.

http://www.google.com/search?q=SQLLite+ ... on+strings
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar

Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?

User avatar
Bob Hansen
Automation Wizard
Posts: 2475
Joined: Tue Sep 24, 2002 3:47 am
Location: Salem, New Hampshire, US
Contact:

Post by Bob Hansen » Tue Jan 12, 2010 1:06 am

I haven't used this with SQLite either.

But if you need one for testing, I believe that Firefox versions 3.5.x use SQLite as their database for form field histories.

There is also a SQLite front end AddOn for Firefox, SQLIte Manager 0.5.7, that you may be able to use with Macro Scheduler also.
Hope this was helpful..................good luck,
Bob
A humble man and PROUD of it!

rullbandspelare
Pro Scripter
Posts: 149
Joined: Tue Mar 23, 2004 9:11 pm

Re: About SQLite and MS

Post by rullbandspelare » Thu Feb 13, 2020 7:16 pm

I am using sqlite3.exe to manipulate a text db. works well.
Here: https://www.sqlite.org/2020/sqlite-tool ... 310100.zip

But I realy need help to get the DLL working.
here: https://www.sqlite.org/2020/sqlite-dll- ... 310100.zip

I can LibLoad it, but LibFunc> gives this error:
Line: 5 - Error Calling DLL: Possible wrong number or type of parameters? Message: Access violation at address 00000000. Read of address 00000000

LibLoad>sqlite3.dll,hDll
LibFunc>hDll,sqlite3_open,result,test.db,myDB
LibFunc>hDll,sqlite3_prepare,result,myDB, "SELECT * FROM files", -1, NULL, NULL
LibFree>hDll


Any input is welcome!
Thanks!
Rullbandspelare

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts