Jul 15 2021 06:40 AM
Does anyone know why im getting:
DataSource.Error: ODBC: ERROR [S1C00] [Rocket U2][U2ODBC][2301827]Driver not capable.
What is caussing the error. can i find any additional info whats causing the issue?
If i use the same odbc driver with the same query outside excel i get the data no problem.
this is the query im using:
Odbc.Query("dsn=TestServer", "SELECT NR, DEFKENT FROM Table")
The field NR is decimal and the field DEFKENT is Varchar i can query any data from this table without any issue, but as soon as i add a Varchar filed i get "Driver not capable"
Jul 15 2021 08:38 AM
Please check this U2 Universe database ODBC connection - Microsoft Power BI Community old thread if something helps. That's for Power BI Desktop, but Power Query works quite similar in Excel.
Jul 16 2021 02:26 AM
Thanks for the surgestion. I looked into this but unfortunalty didnt help. The strange thing is if i use python with pyodbc and use the same dsn and same query the the server gives the databack. so its kind of unknow for me why excel wont except the data.
Jul 30 2021 06:43 AM
SolutionJul 30 2021 06:43 AM
Solution