New topic: Opening a SQLite database encrypted using a password
<http://forums.realsoftware.com/viewtopic.php?t=29191> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message Ammu Post subject: Opening a SQLite database encrypted using a passwordPosted: Thu Jul 23, 2009 10:08 am Joined: Mon Jun 22, 2009 11:59 pm Posts: 17 Hi, I have a created a SQLite database with a password. When i try to open the SQLite database from the application specifying the password, the application is not able to open the SQLite database. It throws an exception that the File is encrypted or protected using a password. Following is the code snippet of it: TestDB = New REALSQLDatabase TestDB.databaseFile = GetFolderItem("C:\Test.sqlite") TestDB.Password = "12345678" If TestDB.databaseFile.exists = True then // The database file already exists, so we want to connect to it. If TestDB.Connect() = False then // there was an error connecting to the database 'DisplayDatabaseError( False ) MsgBox "Database Connection Failed" MsgBox TestDB.ErrorMessage Quit Return Else MsgBox "Database Connection Succeeded" Dim rs As RecordSet Dim sql As String sql = "select Name from TestTable" rs = TestDB.SQLSelect(sql) Dim name as Integer name = rs.RecordCount MsgBox str(name) End if End If Just wondering if the password can be set only for the RealSQLiteServer or passwords can be set for the individual database. Please help me to track why i am not able to open the database with the password. Thanks. Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
