Hi Lynn I wish someone had answered your question. I can't find, anymore, the place on the RunRev website where they show the new password and user name you're supposed to use in the database query builder when connecting to the newly integrated SQLite. Presently I can't even get the query builder to say it is connected no matter what I try.
Bill On 10/21/07, Lynn Marie Peterson <[EMAIL PROTECTED]> wrote: > > > Hi folks ~ > > Has anyone else had trouble connecting to an SQLite3 database now that > it's > integrated into the current Rev v2.8.1 gm-3? > > I have no problems connecting and interacting with mySQL databases using > either the Rev Database Query Builder or the Rev commands themselves. It > "appears" as though Rev connects to an SQLite3 database as the Database > Query Builder says it's connected after clicking on the Connect button, > however there is no returned database ID and when I change to the Record > Set > in QB, the popup menu to the tables says the table(s) are not available. > It > says it is connected, even if the full path to the database is not filled > out, so I suspect it's not connected at all. > > If I force type in the name of a table, I get the Rev error message: > An error resulted for the SQL command in the database: employeeInfo > Revdb error: Database Error: SQL error or missing database > Query: SELECT * FROM employeeRecords > > I've used both Terminal and the open source app SQLite3 Database Browser > v1.3 to create a simple SQLite3 database, but am having no luck. I'd > really > like to use SQLite3 for apps that only need single user data > storage/access > that travel with the app. > > Is there something I'm missing? > Thanks to any and all that can end this frustration. > > Lynn Peterson > OS X 10.4.10 [non Intel] > Rev Studio v2.8.1 gm-3 > -- > View this message in context: > http://www.nabble.com/SQLite3---problems-connecting-to-database-tf4667167.html#a13332359 > Sent from the Revolution - User mailing list archive at Nabble.com. > > _______________________________________________ > 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 _______________________________________________ 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
