SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,062 questions
ODBC DSN (SQL Server 18 driver) can't connect to Azure hosted database using ActiveDirectoryServicePrincipal
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 41%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Michael Aiello
0
Reputation points
I have an ODBC DSN set up using SQL Server ODBC driver 2018.184.01.01. I can connect to my Azure hosted database using this DSN in Python, with the DSN, UID, PWD in the connection string. However attempting the same connection string using the C language SQLDriverConnect() function always fails, reporting:
State: CE275
[Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Error requesting access token, HTTP status 400, expected 200
I am also able to create a working JDBC connection with the same credentials. Only fails from C code.
{count} votes
-
Erland Sommarskog 112.8K Reputation points MVP2024-11-20T22:07:04.1466667+00:00 Without seeing any code etc, it is difficult to comment. But could the UID or the PWD include characters that needs escaping in the C code?
Sign in to comment
Sign in to answer