ODBC Connection String

ID

odbc_connection_string

Severity

info

Vendor

-

Family

Data Storage Secret

Description

Open Database Connectivity (ODBC) is a standard application programming interface for accessing database management systems. The designers of ODBC aimed to make it independent of database systems and operating systems.

Security

Any hardcoded ODBC connection string is a potential secret reported by this detector.

Accidentally checking-in the key to source control repositories could compromise your Data Storage resource.

Examples

CONNECTION_STRING1="data source=google.com,5434;Initial Catalog=account;User ID=test;Password=P@ssworD;application name=EntityFramework"

Mitigation / Fix

  1. Remove the hardcoded connection string from the source code or committed configuration file.

  2. Follow your policy for handling leaked secrets, which typically require revoking the secret in the target system(s).

  3. If under a git repository, you may remove unwanted files from the repository history using tools like git filter-repo or BFG Repo-Cleaner. You may follow the procedure listed here for GitHub.

You should consider any sensitive data in commits with secrets as compromised.

Remember that secrets may be removed from history in your projects, but not in other users' cloned or forked repositories.

Reference

https://www.connectionstrings.com/