Using SQLite

Software technical issues not related to any of the other categories

Moderators: Georges, milos, NiceLabel Support Team

Post Reply
ricardo
Enthusiast
Posts: 8
Joined: Mon Nov 14, 2011 8:14 pm
Location: Porto, Portugal
Contact:

Using SQLite

Post by ricardo » Fri Nov 22, 2019 12:19 pm

Hi, is it possible to use SQLite as database on labels or forms?

Any idea how?

Regards

User avatar
Kyleodonnell
NiceLabel Support
NiceLabel Support
Posts: 470
Joined: Mon Aug 28, 2017 3:07 pm

Re: Using SQLite

Post by Kyleodonnell » Fri Nov 22, 2019 1:49 pm

Ricardo,

There may be ODBC connections to connect to SQLLite, what is your use case of using SQL lite rather than SQLEXPRESS?

ricardo
Enthusiast
Posts: 8
Joined: Mon Nov 14, 2011 8:14 pm
Location: Porto, Portugal
Contact:

Re: Using SQLite

Post by ricardo » Fri Nov 22, 2019 2:01 pm

SQL Express requires installation and is heavy for some of the Panel PCs in this customer.

As we want a temporary solution to log some information of the labels it would be great to use a light software that does not require installation (15 panel PCs, half of them XP machines with limited hardware).

User avatar
Kyleodonnell
NiceLabel Support
NiceLabel Support
Posts: 470
Joined: Mon Aug 28, 2017 3:07 pm

Re: Using SQLite

Post by Kyleodonnell » Fri Nov 22, 2019 3:08 pm

Ricardo,

SQLlite has not been tested as source to connect to the software, you can try to find an ODBC connection that will support it. Pleas also note NiceLabel 2017/2019 is not compatible with Windows XP

User avatar
Mytch
NiceLabel Support
NiceLabel Support
Posts: 103
Joined: Fri Jul 13, 2018 10:26 pm
Location: Milwaukee, Wisconsin
Contact:

Re: Using SQLite

Post by Mytch » Fri Nov 22, 2019 5:36 pm

Hi,

I have tested this driver and it works fine:
http://www.ch-werner.de/sqliteodbc/

Regards,
Mytch

Post Reply