David
David

Reputation: 5525

Get sql statements from an exe (no source code)

I have an exe written in Delphi a decade or more ago, with no source code. It calls a ms sql database, maybe more than 1 to retrieve data. I have read only access to one of the databases, I don't have rights to run sql profiler on it.

Is there a way to get the sql calls that are being made like how fiddler does it for http requests. I'm hoping that there is an app that I can run.

Thank you.

Upvotes: 0

Views: 589

Answers (1)

GuidoG
GuidoG

Reputation: 12059

Older versions of Delphi store string properties inside the executable file, at the end of the file.
If the developers did not take action to obscure this, than chances are you can retrieve them there.

It is not always easy to read though, I opened an old delphi program here and searched for the text "select distinct" and this is what came up

enter image description here

some more queries I found, they are there but as I said, not easy to read.

enter image description here

Upvotes: 1

Related Questions