You need to sign in to do that
Don't have an account?
Kris Ryan SA
ODBC--connection to '{{Salesforce}}' failed.
Hi,
I am trying to connect to Salesforce via MS Access. When I try to login, I get an error message 'ODBC--connection to '{{Salesforce}}' failed'. When I look at my login history in Salesforce, it says 'Partner Product, Invalid Password, SimbaTechnologies/ODBCDriver/'. However, I can login from another application with exactly the same credentials and I get connected.
It is not the ODBC driver, as other people can connect from MS Access to Salesforce on my laptop.
What am I missing?
Thanks!
Kris
I am trying to connect to Salesforce via MS Access. When I try to login, I get an error message 'ODBC--connection to '{{Salesforce}}' failed'. When I look at my login history in Salesforce, it says 'Partner Product, Invalid Password, SimbaTechnologies/ODBCDriver/'. However, I can login from another application with exactly the same credentials and I get connected.
It is not the ODBC driver, as other people can connect from MS Access to Salesforce on my laptop.
What am I missing?
Thanks!
Kris
a) add Profile to permitted Profiles - for all Connected Apps requiring Admin approval
https://i.stack.imgur.com/HPsMg.png
b) and possibly also pay attention to History Login of User: here I've needed to reset SF password (and hence token) of User
https://gxcuf89792.i.lithium.com/t5/image/serverpage/image-id/19066i5C5E830F642AD97F/image-size/large?v=1.0&px=999
See if this helps.
Also, check your login history to make sure MS Access is establishing a connection with Salesforce. You should see an error or success message similar to below.
Additional Connection String Parameters:
URL=https://test.salesforce.com