redpanda-data / redpanda-data/connect

Update mssql ADO connection strings to the Documentation.

Open
#2,273 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

documentation effort: lower enhancement ux
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

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.