ODBC behavior error

[twinrabbits]

Using the enterprise gateway I am getting an error when using ODBC with DRIVER={InterSystems ODBC}. Has anyone had this issue before and resolved it?  

ODBC: ERROR [08S01] [Cache ODBC][State : 08S01][Native Code 461] [C:\Program Files\On-premises data gateway\Microsoft.Mashup.Container.NetFX40.ex] Communication link failure ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).

[twinrabbits · Accepted solution]

Hi Qiuyun Yu,

              It turns out that I needed to upgrade to the latest ODBC driver for my database. Now it is working.

Thanks,

twinrabbits

[Anonymous]

Hi, could help me.

I have a similar problem.  I use "Intersystem ODBC Driver" version 1.00.0000 , what's version do you use?

Thanks  

[twinrabbits · Accepted solution]

I am using version 2016.02.01.803

[Anonymous]

I try use ODBC with base Caché - intersystem

[v-qiuyu-msft]

Hi @twinrabbits,

Have you tried to connect to this ODBC data source in Power BI Desktop? What's the version of ODBC did you create, 32 bit or 64 bit? Please try to check the on-premises data gateway service logs ( C:\Users\PBIEgwService\AppData\Local\Microsoft\on-premises data gateway\Gateway*.log ) around the time error throws out, share it with us if possible.

 
Best Regards,

Qiuyun Yu

[twinrabbits · Accepted solution]

Hi Qiuyun Yu,

              It turns out that I needed to upgrade to the latest ODBC driver for my database. Now it is working.

Thanks,

twinrabbits