Reinhold Don't give up. I use SQLite3 and it worked great with RunRev and the ALTSQL plug in. Now I upgraded to 2.7.4 and after moving my datafile (has to be in the same folder as RunRev main file) and putting the altsqlite plugins where they go it works fine ....
But, I can't help you with the query builder connection fill-out I find that even though it works there is no pop-up for SQLite anymore and it is "MYSQL" that is chosen and which is working even though I'm using SQLite. In any case I highly recommend that you use Trever's library as much as possible instead of the query builder as the query builder behaves more like wine making than science. Trever's library also works faster and you never get weird errors like the "too many connections open" that you get with the query builder. The query builder is not really finished anyway as it does not allow you to insert a new record and the edit record feature doesn't always work (you enter data in a field and be sure to tab to the next field and then refresh to check it). Please try Trevor's library before you give up. Bill On 12/4/06 1:11 PM, "Reinhold Venzl-Schubert" <[EMAIL PROTECTED]> wrote: >> Reinhold, >> >> You should replace the line in your "Database Drivers.txt" file >> >> altSQlite3,dbsqlite3.bundle >> >> with >> >> sqlite3,dbsqlite3.bundle >> >> This combined witht he previous parameters and your test stack >> works fine on >> my machine running Rev 2.7.2 on 10.4.9 >> >> -- >> cb > > Hi Chris, > > I found 5 files "Database Drivers.txt" in the "2.7.4-gm-1"-Folder: > > 1. /2.7.4-gm-1/Externals/Database Drivers/Database Drivers.txt > MySQL,dbmysql.bundle > ODBC,dbodbc.bundle > Oracle,dboracle.bundle > PostgreSQL,dbpostgresql.bundle > Valentina,VXCMD_macho.bundle > altSQLite3,dbsqlite3.bundle <-- this I changed! > > 2. /2.7.4-gm-1/Runtime/Windows/x86-32/Externals/Database Drivers/ > Database Drivers.txt > MySQL,dbmysql.dll > ODBC,dbodbc.dll > Oracle,dboracle.dll > PostgreSQL,dbpostgresql.dll > Valentina,dbvalentina.dll,VXCMD.dll > > 3. /2.7.4-gm-1/Runtime/Mac OS/PowerPC-32/Externals/Database Drivers/ > Database Drivers.txt > MySQL,dbmysql.bundle > ODBC,dbodbc.bundle > Oracle,dboracle.bundle > PostgreSQL,dbpostgresql.bundle > Valentina,VXCMD_macho.bundle > altSQLite3,dbsqlite3.bundle <-- this I changed! > > 4. /2.7.4-gm-1/Runtime/Mac OS/Universal/Externals/Database Drivers/ > Database Drivers.txt > MySQL,dbmysql.bundle > ODBC,dbodbc.bundle > Oracle,dboracle.bundle > PostgreSQL,dbpostgresql.bundle > Valentina,VXCMD_macho.bundle > > 5. /2.7.4-gm-1/Runtime/Mac OS/x86-32/External/Database Drivers/ > Database Drivers.txt > MySQL,dbmysql.bundle > ODBC,dbodbc.bundle > PostgreSQL,dbpostgresql.bundle > > Then I tried it again, but invain! I get the same error message. > I am so frustrated and tired. > > I bought Revolution 2.7.1 and altSQLite3 to use a database but the > QueryBuilder of rev 2.7.1 and 2.7.2 did not support altSQLite3. > The I read, that rev 2.7.4 supports altSQLite3 and I bought rev 2.7.4 > and the Universal Binary Version of altSQLite3. > > It waste my money and my time. > > Reinhold > > > _______________________________________________ > use-revolution mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution | | | )_) )_) )_) )___))___))___)\ )____)____)_____)\\ _____|____|____|____\\\__ -------\ /--------- http://www.bluewatermaritime.com ^^^^^ ^^^^^^^^^^^^^^^^^^^^^ ^^^^ ^^^^ ^^^ ^^ ^^^^ ^^^ 24 hour cell: (787) 378-6190 fax: (787) 809-8426 Blue Water Maritime P.O. Box 2087 Rio Grande, PR 00745 _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
