Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Jacksj12

ODBC Can't see tables in Navigator

Submitted by on ‎02-13-2017 10:14 AM

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
See more ideas labeled with:
11 Comments (11 New)
Comments
Anonymous
Not applicable
‎10-31-2017 09:08 AM

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