Search for connection strings in code programmatically

Question

It seems like a pretty simple problem. I want to browse around 6 GB of content and classic asp code and find everything that looks like a connection string. The problem is that the connection strings are formatted in a dozen different ways.

I was thinking about using regular expressions to search for specific properties, such as "catalog =" or "password =" etc.

Answer 1

Can't you use this regex?

@"^([^=;]+=[^=;]*)(;[^=;]+=[^=;]*)*;?$"

http://social.msdn.microsoft.com/Forums/en-US/regexp/thread/48bf2a4f-7312-4a32-b874-b77a27f7c5d0

Answer 2

- ?

regex/grep-like - . .

Answer 3

, . ( ) , . 6 .

Answer 4

, :

x = "Provider=xyz;Initial Catalog=bdf;Database=pdq;"

:

x = "Provider=xyz;" & _
    "Initial Catalog=bdf;" & _
    "Database=pdq;"

:

x = "Provider=xyz;"
x = x & "Initial Catalog=bdf;"
x = x & "Database=pdq;"

dotnet ConnectionBuilder

SqlConnectionStringBuilder x = newSqlConnectionStringBuilder();
x.Add("Data Source", "pdq");
x.Add("Initial Catalog", "xyz");

, ?

"SQLConnection | odbcconnect | OleDbConnection | ConnectionString"