DMXzone Database Connector PHP Support Product Page

Solved

Sqlite Table Viewing Issues

Reported 04 Oct 2013 15:29:58
1
has this problem
04 Oct 2013 15:29:58 Jay Blaze posted:
I'm having Sqlite issues, I can connect to the DB fine but none of my tables are shown in the dropdown. I can see them fine in my database tool or if I query the db myself. It's as if it can't read the main table in the sqlite file and I've used both an sqlite 2 and 3 db to test. Thanks for the help

edit:
My system specs.
Dreamweaver CC, Windows 8

Replies

Replied 08 Oct 2013 10:19:23
08 Oct 2013 10:19:23 Teodor Kuduschiev replied:
Hello Jay,

Are you using the latest versions of DMXzone Database Connector and HTML5 Data bindings?
Replied 09 Oct 2013 16:08:01
09 Oct 2013 16:08:01 Jay Blaze replied:
Hey Teodor,

Yes I am,
DMXzone Database Connector 1.0.1
HTML5 Data Bindings 1.2.0
Replied 10 Oct 2013 14:17:22
10 Oct 2013 14:17:22 Teodor Kuduschiev replied:
Can you please check with your hosting provider if the remote access to your database is enabled?
Replied 10 Oct 2013 14:24:11
10 Oct 2013 14:24:11 Jay Blaze replied:
I'm on a local install on my machine using the latest xampp
Replied 10 Oct 2013 14:28:58
10 Oct 2013 14:28:58 Teodor Kuduschiev replied:
Please send me your sqlite database file to
Replied 10 Oct 2013 14:51:48
10 Oct 2013 14:51:48 Jay Blaze replied:
File sent Thanks
Replied 10 Oct 2013 15:06:49
10 Oct 2013 15:06:49 Teodor Kuduschiev replied:
I think the issue is with the path you are entering in the database file field. It should be absolute - the full *nix path.
Replied 10 Oct 2013 15:21:19
10 Oct 2013 15:21:19 Jay Blaze replied:
Funny it's working now only change I did was click "Apply" instead of just "OK".

Thanks for your help
Replied 10 Oct 2013 15:23:26
10 Oct 2013 15:23:26 Jay Blaze replied:
For help for others could you change the "Use Database Path" from a text box to have a browse for file option to ease use?
Replied 10 Oct 2013 15:26:01
10 Oct 2013 15:26:01 Teodor Kuduschiev replied:
Hello Jay,

Thank you for your suggestion, i will pas it to our developers.

Reply to this topic