redpanda-data / redpanda-data/connect
Update mssql ADO connection strings to the Documentation.
Nobody has claimed this yet.
- Dominant language
- Go
- Stars
- 8.8k
- Forks
- 969
- Avg merge
- 1d 13h
- Merged PRs (30d)
- 64
Description
Hello,
currently I am trying to read data from an mssql database via Benthos.
The database is secured with a password that contains special characters like "!" and "#"
I was unable to establish a connection to the database using the dsn provided in the documentation since the password was interpreted as the port.
I got it working by having a look at the sources of Benthos and seeing that it uses go-mssqldb. Which in its documentation provided an ADO connection string that worked for me.
Since this is usefull to know, but not documented in the Benthos documentation I am starting this issue in hope the documentation gets updated with a link to the ADO connection strings of the go-mssqldb project.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the SQL select DSN documentation at docs/components/inputs/sql_select/ and compare its MSSQL connection-string guidance with the go-mssqldb ADO connection-string documentation linked in the issue. Update the Benthos documentation to mention or link to the ADO format, then verify that the documented guidance covers passwords containing special characters.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- go, sql
- Domain
- databases, documentation
- Issue type
- Documentation
- Difficulty
- 1/5
- Estimated time
- Under an hour
- Activity status
- Stale
- Clarity
- Clearly specified
- Newbie friendliness
- 45/100