[cryptocar]

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!

[aknight720]

DiagDocDb 4.03.21 password is 6505EFBDC3E5F324

[CATAHA]

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)

[cryptocar]

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.

---

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?

[aboulfad]

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!

[cryptocar]

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

[aboulfad]

Here's a small crude utility I wrote 1/2 year ago to decrypt SQL dBs. Need VS to build and .net 4.x.