function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Kris Ryan SAKris 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
Florent GUIGNARD 7Florent GUIGNARD 7
Any solution? Same issue here
Kris Ryan SAKris Ryan SA
Nope. I have not had any responses in regards to this issue.
Florent GUIGNARD 7Florent GUIGNARD 7
Hi Kris, I might have a solution here - still to be confirmed. I'll keep you informed if possible. Do not hesitate to ask again
Kris Ryan SAKris Ryan SA
That would be great! Just let me know what you find. Thanks!
Florent GUIGNARD 7Florent GUIGNARD 7
Hi Kris. Problem resolved here. Not sure about the root-cause, but the following actions unblocked user:
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.
Kris Ryan SAKris Ryan SA
Thank you, Florent! I must have had a bad token. Although, I could swear I had tried resetting it along the way. I tried just about everything. I could login as another user, just not my own.
Florent GUIGNARD 7Florent GUIGNARD 7
If it still doesn't work, then make sure your Profile is added to all the Connected Apps. Who knows...
Carrie Mantione 19Carrie Mantione 19
You must first reset your password and then the security token (in that order) to successfully login.

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.
 
Login TypeStatusApplicationLogin URL
Partner ProductSuccessSimbaTechnologies/ODBCDriver/login.salesforce.com
Partner ProductInvalid PasswordSimbaTechnologies/ODBCDriver/login.salesforce.com
Carrie Mantione 19Carrie Mantione 19
If you are connecting to a Sandbox, you need to include the test url in the additional parameters.

Additional Connection String Parameters:
URL=https://test.salesforce.com