NeoDBpro and sqlite3
Quote from Phil78 on January 2, 2024, 1:58 pmHello and happy new year to everybody.
I am testing neodbpro with sqlite3. I use the sample database viewer, I open a database, in the table list I see my database name and users (which is the 2 database in the same folder) but not the table names ? If I select on I receive the error message could not open the table.
Is there a problem with sqlite3 ?
Hello and happy new year to everybody.
I am testing neodbpro with sqlite3. I use the sample database viewer, I open a database, in the table list I see my database name and users (which is the 2 database in the same folder) but not the table names ? If I select on I receive the error message could not open the table.
Is there a problem with sqlite3 ?
Quote from Phil78 on January 2, 2024, 4:48 pmI've finally succeeded using Avanced Conection String and the wizard, but the result is not exactly like described on help.
dbpOpenDatabase "DB1" "Provider=MSDASQL.1;Persist Security Info=False;Extended Properties=[#34]DSN=SQLite3 Datasource;Database=E:\Philippe\Documents\VisualNeoWeb\Projets\MeleeTournante-Web\MeleeTournante.db;StepAPI=0;SyncPragma=NORMAL;NoTXN=0;Timeout=100000;ShortNames=0;LongNames=0;NoCreat=0;NoWCHAR=0;FKSupport=0;JournalMode=;OEMCP=0;LoadExt=;BigInt=0;JDConv=0;AttachAs=;ILike=0[#34]"
I've finally succeeded using Avanced Conection String and the wizard, but the result is not exactly like described on help.
dbpOpenDatabase "DB1" "Provider=MSDASQL.1;Persist Security Info=False;Extended Properties=[#34]DSN=SQLite3 Datasource;Database=E:\Philippe\Documents\VisualNeoWeb\Projets\MeleeTournante-Web\MeleeTournante.db;StepAPI=0;SyncPragma=NORMAL;NoTXN=0;Timeout=100000;ShortNames=0;LongNames=0;NoCreat=0;NoWCHAR=0;FKSupport=0;JournalMode=;OEMCP=0;LoadExt=;BigInt=0;JDConv=0;AttachAs=;ILike=0[#34]"