New Custom Fields Aren't Visible

[Baelish]

Hi,

I am using the latest version of dotConnect with the Layer2 Software Salesforce to Sharepoint Cloud Connector.

When I call 'select * from account' I get all the fields (standard and custom) that were in Salesforce as of a week or so ago. I added two new custom fields today, but they do not show up in the select statement.

I have checked my enterprise WSDL within salesforce and I see the fields there, but I cannot specify to the enterprise soap as a connection parameter (https://login.salesforce.com/services/Soap/c/28.0) as the dotConnect system will only accept (https://login.salesforce.com/services/Soap/u/28.0) as a login option.

Has anyone else had issues with custom fields not showing up? Any workarounds?

[Shalex]

You should call salesforceConnectionObject.Cache.RefreshMetadata() in the code to update the local cache after the database schema is changed via web interface.

An alternative way is to remove the C:\Users\YOUR_OS_USER_NAME\Application Data\*.db files. dotConnect for Salesforce will recreate them on the next salesforceConnectionObject.Open().

For more information about cache management, refer to http://www.devart.com/dotconnect/salesf ... Cache.html.

[amitloh]

I have the same issue. I am not using any code but layer2 connector so not sure where to write salesforceConnectionObject.Cache.RefreshMetadata()
I do not see C:\Users\YOUR_OS_USER_NAME\Application Data\*.db
Can you give me exact path?

[Shalex]

I do not see C:\Users\YOUR_OS_USER_NAME\Application Data\*.db
Can you give me exact path?

Replace YOUR_OS_USER_NAME with your actual name. Also check this path: C:\Users\YOUR_OS_USER_NAME\AppData\Roaming\*.db (this is a default path if different paths are not set explicitly via the Data Cache and Metadata Cache connection string parameters).