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.
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:
I also had the driver installed as below:
Could anyone please help me to fix this connection?
Thanks,
Solved! Go to Solution.
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!
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!
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.
Did you try looking into below links to find out the reason for error
https://knowledgebase.progress.com/articles/Article/7460
Please also try connecting to your database from other sources as well like excel, access or any other just to check if similar issue is faced. Also, please ensure that it is not VPN issue. Some database allows connectivity from secure network.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |