cancel
Showing results for 
Search instead for 
Did you mean: 

ODBC Can't see tables in Navigator

I am trying to connect to Cygnet (Database) using ODBC. I can successfully connect to it in MS Access using ODBC. When I try in Power BI I get as far as the Navigator screen. I can see the Cygnet database that I am trying to connect to but none of the tables are shown. Any ideas?

Status: Accepted
Comments
Visitor

I'm having the same issue.  I installed PBI Desktop 32 bit so that I could use a 32 bit ODBC connector that works with SAP Crystal Reports.  Connection appears in Navigator but no tables visible for selection.

 

What is the fix for this???  Must I continue using SAP products???

 

Here's the error section of my  Trace Log

 

Microsoft.Mashu efc-195c ENTER SQLGetInfoW
  HDBC                0x00585A80
  UWORD                      173 <unknown>
  PTR                 [Unknown attribute 173]
  SWORD                        4
  SWORD *             0x00000000

 

Microsoft.Mashu efc-195c EXIT  SQLGetInfoW  with return code -1 (SQL_ERROR)
  HDBC                0x00585A80
  UWORD                      173 <unknown>
  PTR                 [Unknown attribute 173]
  SWORD                        4
  SWORD *             0x00000000

  DIAG [HYC00] [MySQL][ODBC 5.1 Driver]Unsupported option: 173 to SQLGetInfo (4000)

 

 

Idea Statuses