Unfortunately we do not accept new members for free, Now Registration cost 30€, if you are interesting Send Email to [email protected]

Looking for help extracting trouble code database from SQLdb files
30-12-2016, 20:37 PM,
Post: #1
Looking for help extracting trouble code database from SQLdb files
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!

If this post helped you in anyway please use the thanks and/or REP buttons down here.under Thanks!
Quote this message in a reply
[+] 2 users say Thank You to cryptocar for this post
31-12-2016, 12:12 PM,
Post: #2
RE: Looking for help extracting trouble code database from SQLdb files
DiagDocDb 4.03.21 password is 6505EFBDC3E5F324
Reputation: +1 - cryptocar [+1]
Quote this message in a reply
[+] 2 users say Thank You to aknight720 for this post
31-12-2016, 18:17 PM,
Post: #3
XZBMW  RE: Looking for help extracting trouble code database from SQLdb files
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)

If any of my posts or current one helps then don't forget to press thanks and add a reputation thankyou
Visit this user's website
Quote this message in a reply
31-12-2016, 23:33 PM, (This post was last modified: 01-01-2017, 01:37 AM by cryptocar.)
Post: #4
Looking for help extracting trouble code database from SQLdb files
(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?

If this post helped you in anyway please use the thanks and/or REP buttons down here.under Thanks!
Quote this message in a reply
02-01-2017, 12:58 PM,
Post: #5
RE: Looking for help extracting trouble code database from SQLdb files
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!
Quote this message in a reply
03-01-2017, 07:42 AM,
Post: #6
Looking for help extracting trouble code database from SQLdb files
(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

If this post helped you in anyway please use the thanks and/or REP buttons down here.under Thanks!
Quote this message in a reply
04-01-2017, 03:04 AM, (This post was last modified: 01-05-2017, 14:42 PM by aboulfad.)
Post: #7
RE: Looking for help extracting trouble code database from SQLdb files
Here's a small crude utility I wrote 1/2 year ago to decrypt SQL dBs. Need VS to build and .net 4.x.
Reputation: +1 - cryptocar [+1]
Quote this message in a reply
[+] 2 users say Thank You to aboulfad for this post


Possibly Related Threads…
Thread Author Replies Views Last Post
XZBMW FSC Code for Route Maps Bimmer540 229 32,544 26 minutes ago
Last Post: nikisard
XZBMW REQUEST FSC CODE muskatas 4,242 347,291 11 hours ago
Last Post: Kareta_BMW
  G05 KAFAS4 enable code missing after Retrofit ACC 6ergsm 19 2,288 26-03-2024, 12:33 PM
Last Post: Hodgsonp
XZBMW ISTA+ 4.46.3x Install Files - MEGA shawnsheridan 9 1,682 22-03-2024, 22:13 PM
Last Post: 2013m5
XZBMW ISTA Czech Database ( 4.40.XX - 4.46.XX) inspi1981 63 7,390 22-03-2024, 14:52 PM
Last Post: inspi1981
XZBMW BMW Navigation Maps FSC activation code (request) rogerkj71 75 10,443 19-03-2024, 10:31 AM
Last Post: evaldazj
  Sharing PSDZdata files between istaP and ESYS BMWlad 23 9,842 16-03-2024, 18:09 PM
Last Post: kuno24
XZBMW ISTA+ 4.46.2x Install Files - MEGA shawnsheridan 6 1,215 16-03-2024, 11:27 AM
Last Post: simo2k
XZBMW How to change VIN code in VCM via Esys? vipsha 5 1,335 14-03-2024, 22:20 PM
Last Post: tcp443
XZBMW ISTA+ 4.46.1x Install Files - MEGA shawnsheridan 83 9,227 06-03-2024, 02:43 AM
Last Post: weinerbarn

Forum Jump:


Users browsing this thread:
1 Guest(s)

Return to TopReturn to Content