In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.

Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.

Not able to connect to Sqlite Database

Xailer professional forum in English
Responder
Milan Mehta
Mensajes: 140
Registrado: Dom Dic 27, 2009 9:54 am

Not able to connect to Sqlite Database

Mensaje por Milan Mehta »

I am using Professional version of Xailer.
When I try to connect, I get the message : Readonly Set, 'AddNew' not
allowed {#0]
I have attached the source and test data.
Can you please guide ?
TIA
Milan.


Attached files Main.prg (3 KB)Â Test.db (3 KB)Â xSqlLite.prg (284 B)Â
Milan Mehta
Mensajes: 140
Registrado: Dom Dic 27, 2009 9:54 am

Not able to connect to Sqlite Database

Mensaje por Milan Mehta »

Let me add that this problem I am facing in one computer where Xailer is
registered.
However it works fine in Xailer Demo mode on other computer.
Can you guide me, what am I doing wrong ?
TIA
Milan.
Avatar de Usuario
ignacio
Site Admin
Mensajes: 9442
Registrado: Lun Abr 06, 2015 8:00 pm
Ubicación: Madrid, Spain
Contactar:

Not able to connect to Sqlite Database

Mensaje por ignacio »

Hi,
You need the Enterprise version in order to access natively to SQLite databases. On DEMO mode it works as expected.
Regards
Ignacio Ortiz de Zúñiga
[OZ Software]
https://www.ozs.es
--
[Equipo de Xailer / Xailer team]
https://www.xailer.com
Milan Mehta
Mensajes: 140
Registrado: Dom Dic 27, 2009 9:54 am

Not able to connect to Sqlite Database

Mensaje por Milan Mehta »

Oh yes. I forgot that.
But I think I can connect to Sqlite datasource by coding.
Am I right ?
TIA
Milan.
"Ignacio Ortiz de Zúñiga" <nonametoavoidspam@xailer.com> wrote in
message news:520ce873$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
> Hi,
> You need the Enterprise version in order to access natively
> to SQLite databases. On DEMO mode it works as expected.
> Regards --
> Ignacio Ortiz de Zúñiga
> [Equipo de Xailer/Xailer team]
> http://www.xailer.com
> http://www.xailer.info
Avatar de Usuario
ignacio
Site Admin
Mensajes: 9442
Registrado: Lun Abr 06, 2015 8:00 pm
Ubicación: Madrid, Spain
Contactar:

Not able to connect to Sqlite Database

Mensaje por ignacio »

Hi Milan,
I'm afraid you can not, sorry.
Regards,
Ignacio Ortiz de Zúñiga
[OZ Software]
https://www.ozs.es
--
[Equipo de Xailer / Xailer team]
https://www.xailer.com
Milan Mehta
Mensajes: 140
Registrado: Dom Dic 27, 2009 9:54 am

Not able to connect to Sqlite Database

Mensaje por Milan Mehta »

Any work around possible ? Like use of AdoDataSource or something like that
?
TIA
Milan.
"Ignacio Ortiz de Zúñiga" <nonametoavoidspam@xailer.com> wrote in
message news:5210f80d$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
> Hi Milan,
> I'm afraid you can not, sorry.
>
> Regards, --
> Ignacio Ortiz de Zúñiga
> [Equipo de Xailer/Xailer team]
> http://www.xailer.com
> http://www.xailer.info
Avatar de Usuario
jfgimenez
Site Admin
Mensajes: 5718
Registrado: Lun Abr 06, 2015 8:48 pm
Contactar:

Not able to connect to Sqlite Database

Mensaje por jfgimenez »

Milan,
> Any work around possible ? Like use of AdoDataSource or something like that
> ?
There are several enhancements (included SQLite, MySQL and MariaDB
datasources) that are reserved to enterprise version only, sorry. Of
course, you could write your own sqlite datasource, but you'll miss some
features like perfect Xailer dataset/datacontrols integration, fast and
transparent DB encryption, full compatability with integrated IDE
database viewer, and so on.
Regards,
Jose F. Gimenez
http://www.xailer.com
http://www.xailer.info
José F. Giménez
[Equipo de Xailer / Xailer team]
http://www.xailer.com
http://www.xailer.info
Responder