+- CarTechnoloGY (https://cartechnology.co.uk)
+-- Forum: Discussions All about Software and Hardware (https://cartechnology.co.uk/forumdisplay.php?fid=310)
+--- Forum: Automotive Help & Discussions / Software and Hardware (https://cartechnology.co.uk/forumdisplay.php?fid=40)
+---- Forum: BMW - Mini - Rolls Royce (https://cartechnology.co.uk/forumdisplay.php?fid=61)
+---- Thread: Looking for help extracting trouble code database from SQLdb files (/showthread.php?tid=20622)
Looking for help extracting trouble code database from SQLdb files - cryptocar - 30-12-2016
I'm looking to manually browse the SQL DBs that contain the diagnostic trouble code database, and then extract those tables to make a standalone DTC lookup tool. I have general SQL experience, but am no pro, and don't know German well. My first obstacle has been not knowing the password for the SQL DB files to just open them in a SQL browser.
If anyone has experience working directly with the SQL DBs please respond!
Also if anyone knows the password that would help greatly as well!
Thanks!
RE: Looking for help extracting trouble code database from SQLdb files - aknight720 - 31-12-2016
DiagDocDb 4.03.21 password is 6505EFBDC3E5F324
RE: Looking for help extracting trouble code database from SQLdb files - CATAHA - 31-12-2016
Not to discourage anybody but GOOD LUCK
Here is why.....
Couple of weeks ago i was testing for Fuel Mix Code....
The procedure was as follows:
Check low fuel pump, Activate, input value
Check return pressure with sensor. Activate low Fuel Pump,
Check High Fuel pressure pump, at no engine running, at engine running idle
Check MAF, when engine not running, when engine running at idle and under load,
Check for Vacuum Leak intake, fuel tank
Check OS/2 sensors 4 each, per test, check wiring, input data
Check Engine Compression (when fuel or spark been cut and engine just spins freely with starter)
Looking for help extracting trouble code database from SQLdb files - cryptocar - 31-12-2016
(31-12-2016, 18:17 PM)CATAHA Wrote: Not to discourage anybody but GOOD LUCK
Here is why.....
Couple of weeks ago i was testing for Fuel Mix Code....
The procedure was as follows:
Check low fuel pump, Activate, input value
Check return pressure with sensor. Activate low Fuel Pump,
Check High Fuel pressure pump, at no engine running, at engine running idle
Check MAF, when engine not running, when engine running at idle and under load,
Check for Vacuum Leak intake, fuel tank
Check OS/2 sensors 4 each, per test, check wiring, input data
Check Engine Compression (when fuel or spark been cut and engine just spins freely with starter)
Thanks for the well wishes, but I'm a bit confused about what is discouraging? I'm looking to extract the tables for the codes and the short description.
(31-12-2016, 12:12 PM)aknight720 Wrote: DiagDocDb 4.03.21 password is 6505EFBDC3E5F324
Hey man thanks for the pass, I'm having trouble getting in still, it's not working in my SQLlite DB browser, is there any other info (page size) I need to access it properly?
I'm using 4.03.21 DiagDocDb.
Any recommended SQL DB browsers for these DBs?
RE: Looking for help extracting trouble code database from SQLdb files - aboulfad - 02-01-2017
Let me save you the trouble... SQLite DB browser won't work with password encrypted DBs although it says it supports it. You'll need to write a small utility that decrypts the DB, and when you do that you'll have to traverse multiple DBs to get all the info you need and that you see displayed in ISTA.
Definitely doable but most likely you won't be able to do it if you don't have serious DB knowledge and programming experience.good luck!
Looking for help extracting trouble code database from SQLdb files - cryptocar - 03-01-2017
(02-01-2017, 12:58 PM)aboulfad Wrote: Let me save you the trouble... SQLite DB browser won't work with password encrypted DBs although it says it supports it. You'll need to write a small utility that decrypts the DB, and when you do that you'll have to traverse multiple DBs to get all the info you need and that you see displayed in ISTA.
Definitely doable but most likely you won't be able to do it if you don't have serious DB knowledge and programming experience.good luck!
Thanks for the advice aboulfad. I'm gonna play around with it myself but will also probably outsource it to a buddy who is very fluent in SQL.
If anyone else here knows what they're doing or have any other hints they'd be greatly appreciated and I always love to tip good Devs for their hard work.
Sent from my iPhone using Tapatalk
RE: Looking for help extracting trouble code database from SQLdb files - aboulfad - 04-01-2017
Here's a small crude utility I wrote 1/2 year ago to decrypt SQL dBs. Need VS to build and .net 4.x.