getredash / redash

Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
http://redash.io/
BSD 2-Clause "Simplified" License
26.12k stars 4.35k forks source link

Can't create mssql_odbc Data Source #4802

Open susodapop opened 4 years ago

susodapop commented 4 years ago

Issue Summary

An attempt to create an ODBC Microsoft SQL Server connection returns a HTTP 400 Bad Request error.

Steps to Reproduce

I use the API here to avoid any unintended connection tests.

curl --request POST \
  --url https://app.redash.io/<slug>/api/data_sources \
  --header 'authorization: Key <your api key>' \
  --data '{
    "name": "Test",
    "type": "mssql_odbc",
    "options": {
        "server": "server.example.com",
        "user": "user@server.example.com",
        "password": "password",
        "db": "example-db"
    }
}'

Returns:

{
  "message": "The browser (or proxy) sent a request that this server could not understand."
}

Checking Redash's logs it looks like an IntegrityError on line 155 of handlers/data_sources.py but I can't debug it past that.

Technical details:

OmarSultan85 commented 3 years ago

Where u ever able to get this to work?

susodapop commented 3 years ago

I'm not able to reproduce this behavior anymore, actually. Seems to be working again normally.