[Python] [ADBC_DRIVER] [FlightSQL] flight: no authorization header on the response (Unknown; AuthenticateBasicToken) when creating new connection.

### Describe the usage question you have. Please include as many useful details as possible.

Below is my python code to connect to my flight sql jdbc server.

```
with flight_sql.connect(uri="grpc+tls://192.168.140.77:32222",
db_kwargs={
"username": "username",
"password": "Password",
"adbc.flight.sql.client_option.tls_skip_verify": "true"
}
) as conn:
```
My python client code throws an exception and it does get the data.

```
Traceback (most recent call last):
File "/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap
self.run()
File "/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/multiprocessing/process.py", line 108, in run
self._target(*self._args, **self._kwargs)
File "/Users/a.bashir/Desktop/python_codes/newproj/venv/arrow_py_client.py", line 19, in execute_arrow_query
with flight_sql.connect(uri="grpc+tls://192.168.140.77:32222",
File "/Users/a.bashir/Desktop/python_codes/newproj/venv/lib/python3.10/site-packages/adbc_driver_flightsql/dbapi.py", line 120, in connect
conn = adbc_driver_manager.AdbcConnection(db, **(conn_kwargs or {}))
File "adbc_driver_manager/_lib.pyx", line 644, in adbc_driver_manager._lib.AdbcConnection.__init__
File "adbc_driver_manager/_lib.pyx", line 385, in adbc_driver_manager._lib.check_error
adbc_driver_manager._lib.OperationalError: ADBC_STATUS_UNKNOWN (1): [FlightSQL] [FlightSQL] flight: no authorization header on the response (Unknown; AuthenticateBasicToken)
```

This issue is also part of below issue:
https://github.com/apache/arrow-java/issues/117

### Component(s)

Java, Python

Commencez par l’extrait de connexion Python et le traceback, en particulier adbc_driver_flightsql/dbapi.py, puis comparez avec l’arrow-java issue #117 associé. Reproduisez la connexion grpc+tls vers le Flight SQL server indiqué ; c’est terminé lorsque la création de la connexion ne déclenche plus l’erreur signalée de missing authorization-header tout en conservant l’accès aux données.

Rédigé par le modèle d'indexation à partir du texte de l'issue.