Accessing FileMaker Data via ODBC from Microsoft Visual Studio 2015

[Christopher Gauntt]

Hello all,

I installed FileMaker Pro ODBC drivers, and was able to access the data with queries from Microsoft Excel.

However, when I tried to access the same data with the same driver using Microsoft Visual Studio 2015, it could see the table occurrences, but it couldn't find any of the data columns.  It came back with the following error:

" Error at Data Flow Task [ODBC Source [1]]: There was an error while trying to get schema information. Table has no columns."

I got the same error, no matter which table occurrence I selected.

Has anyone else run into this and solved it?

I have been google searching without much luck.  Although I found one post of someone who claimed they were able to do it with Microsoft Visual Studio 2017, so maybe an upgrade is in order?

Thanks in advance,

Chris

 

 

 

[SteveW_Carter]

What does your connection syntax/code like, in Visual Studio? We used to run Visual Studio 2015 with FM Pro 2011 then 2015 with no Issues.  Are you on a local domain?