Forum Discussion

rbcbasic's avatar
rbcbasic
Regular Visitor
6 years ago

ODBC error 22007 with Pervasive SQL: Date/time data issue

Hi All.   Hopefully someone can help me with a suitable solution / tip. I have successfully setup a 64bit ODBC connection to PSQLv13 which I intent to use with the Power BI Gateway. However, when I...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi rbcbasic 

Could you show me what format of your date column from data source?

Please check if you turn on the "Auto detect column type" and set a proper locale.

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Seamark's avatar
    Seamark
    New Member
    6 years ago

    v-juanli-msft I have the exact same issue and have tried with and without automatically detect column settings and get the same error.

    rbcbasic Have you found a solution to this issue yet?

     

    Kind Regards