DSAccountManager Version 1.4
-
Not sure if this will help or not, but a couple things you can check:
- go to: http://sqlitebrowser.sourceforge.net/ and download this applicaiton. once downloaded run it, and open the dsam.db file. verify that the table: CharacterList has actually been created. and contains the following table columns:
CharPath, AccDir,Charame, IsDeleted, Location, Ship, Money, Rank, Created, Updated, OnLineSecs, LastOnline
-
verify that you are running the correct ‘bit depth’ version of dsam.
-
if 2 is correct, verify that the System.Data.SQLite.dll for your bit depth is actually the correct bit depth dll for that version.
if none of the above works for you load the ‘DSAccountManager_2010.sln’ in Visual Studio 2010 (if you do not have VS 2010, download the VS C# Express Edition from Microsoft) , open DataAccess.cs, find the line:
private SQLiteConnection GetConnection()
and set a breakpoint on the first if statement in that function and step through it one line at a time, this will tell you what line is actually barfing the error. Then post here what line number throws the error. This will help narrow down where the problem is.
-
Sushi wrote:
Error ‘Could not load file or assembly ‘System.Data.SQLite, Version=1.0.66.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139’ or one of its dependencies. An attempt was made to load a program with an incorrect format.’ at at DAM.DataAccess.Dispose() at DAM.MainWindow.LoadIt(Object sender, DoWorkEventArgs e)Give it what it wants: 1.0.66.0 version
-
HeIIoween wrote:
Sushi wrote:
Error ‘Could not load file or assembly ‘System.Data.SQLite, Version=1.0.66.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139’ or one of its dependencies. An attempt was made to load a program with an incorrect format.’ at at DAM.DataAccess.Dispose() at DAM.MainWindow.LoadIt(Object sender, DoWorkEventArgs e)Give it what it wants: 1.0.66.0 version
Thanks for the link. Tried it and I got the same issue but with this error
Error 'SQLite error no such table: CharacterList' when updating db Loading player information... Error 'SQLite error no such table: CharacterList' at at DAM.DataAccess.GetConnection() at DAM.DataAccess.GetBanList(BanListDataTable dsTable, Boolean onlyExistent) at DAM.MainWindow.LoadIt(Object sender, DoWorkEventArgs e) -
You’re awesome, M1C. Thanks
-
M1C wrote:
I sent you a link via Skype. You received it, don’t you?Sadly, no. Maybe send it to email? Thanks for working on this so quickly!
-
M1C wrote:
Hmm, I don’t know your e-mail-adress
I sent you a private message
OK. Got it.
Here’s what came up:
Opening database... Loading game data... Error 'Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information.' at at DAM.DataAccess.Dispose() at DAM.MainWindow.LoadIt(Object sender, DoWorkEventArgs e) in C:\Documents and Settings\User\Desktop\DSAccountManager1.4.1\src\MainWindow.cs:line 249 -
M1C fixed it. Not sure what he did, but it works now
-
@M1C perfomance suggestion:
conn = new SQLiteConnection("Data Source=" + AppSettings.Default.setAccountDir + "\\dsam.db; Cache Size=2000;Synchronous=Off;count_changes=0;temp_store=0;"); ```:) -
So is there a fix for this? I keep getting an error
Cannot access database. Check your "Player Accounts Directory’It was doing the same thing with dsam 1.41, but exiting with a runtime error shortly after that. Details showed a
SystemBadFormatImage.So I went to 1.4 and no runtime error, but can’t access the player’s database. FLHook 1.61, DS Process Manager, DSAM 1.4 64 bit, Running Discovery 4.85.
I only have 1 character as my server is still in testing and construction. I delete the dsam.db file and after the run of DSAM it is back, but still says can’t access the player database.
Just about to tear out what little of the hair I have left
-
Well, I finally got it working, but I had to go back to v1.1. I would prefer using the latest version, but they don’t work on my system. Don’t know why, but they just keep saying “Cannot access the player database. Check your ‘Player Account Directory’”.
No matter. It’s working now so I’m happy.
-
KamaZer0 wrote:
I to have this problem with both the 1.4 and 1.41 version of DSAccountManager.We have a disco 4.85 mod and FLhook 1.6
Can anyone lend some assistance on this issue?
Just to let you know that I also had this problem but managed to find the solution.
Running 1.4.1, I received the “Cannot access the player database.” error, as well as the program crashing right after.
Even running 1.4, there was no crash but it was unable to access the database.Looking in the log files, I noticed the error Sushi mentioned, that the System.Data.SQLite file was missing. I noticed that the x64 .dll is different to the x86 .dll file.
It should be noted that I am running win7 x64 [as others with the same problem are also]
The solution which works for me, is to take the System.Data.SQLite.dll file from the 32bit folder, and place it in the x64 folder, replacing the one already there. The program now runs perfectly.In sum, replace the 64bit sqlite dll with the 32bit version, and it works!
