Starting with SQLite

[wificon]

Hi,
I want to ask how to connecd sqlite database to zennoposter.
I have DB from other software and want to use it in ZP - take data form it.

 

[rostonix]

http://zennolab.com/discussion/threads/mysql-ne-rabotaet-zapros-v-postere.25054/#post-174021

 

[wificon]

Thanks, helped a lot - worked like charm

 

[rostonix]

Great)

 

[wificon]

One more question about SQL - it seems that i still have little problem:

- when i run my project in Project Project Maker it works
- in Zennoposter i don't

My DB settings in Project Maker:

Connection string:
Dsn=SQLite3 Datasource;database={-Variable.sprawdz_url-};stepapi=0;syncpragma=NORMAL;notxn=0;timeout=100000;shortnames=0;longnames=0;nocreat=0;nowchar=0;fksupport=0;oemcp=0;bigint=0;jdconv=0

Request text:
SELECT adres FROM wlasciwosci where nazwa = '{-Variable.zrodlo_seolight-}'

Any ideas what might be wrong ?

 

[AShaggy]

If your OS is x64, you have to use 64bit SQLite driver in ZP and 32bit driver in PM
example for Access

 

[wificon]

Thanks I've installed 64bit driver and now works