Forum Discussion

LocNguyen's avatar
LocNguyen
Icon for Advocate I rankAdvocate I
5 years ago
Solved

ODBC connection failure

Hello,   I used to be able to connect ODBC on the same database on Deltek VantagePoint before. However, for some reasons it's not working anymore. Here's my DSN:   And here's my error: ...
Need Help
  • LocNguyen's avatar
    LocNguyen
    5 years ago

    I actually found out the solution. PBI is still aving my old password, thus the ODBC failed to connect since the password was recently changed. I had to clear the permission in the Datasource setting first before reconnect.

    Thanks for all you help!

LocNguyen's avatar
LocNguyen
Icon for Advocate I rankAdvocate I
5 years ago

I'm actually a newbie in ODBC connection, and not familiar with those links.

 

I tried ODBC with excel, but it now returns another error: 

ODBC: ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
ERROR [01S00] [Microsoft][ODBC Excel Driver]Invalid connection string attribute Trusted_Connection

 

Is my ODBC driver wrong? Sorry, this is unfortunately not my specialty. I wish Power BI can cannot directly to Deltek so I did not have to use ODBC.