Hi,
Upon attempting to connect to Salesforce, I receive the following Database Error:
MySQL Database Error
Incorrect information in file: ‘.\mysql\proc.frm’
Thanks,
Rick
You need to reinitialize Local Storage.
We use the Local Storage when connecting to Non-Relational data sources like Salesforce, and the error here tells me that it somehow got corrupted. We would need to reset it, but do keep in mind that you may lose whatever data you have stored.
First, start up TDP (DO NOT connect to Salesforce yet!), and go to Tools->Options->Local Storage->General
Find this folder and rename it. Then try connecting to Salesforce.
If something goes wrong, you can clear out whatever folder this generates and rename the former local storage folder to its old name.
Ryan,
Thank You Very Much.
J
That did the trick.
Thanks Again,
Rick
Rick Girardi
Business Intelligence Analyst
Enterprise Risk Management
Wilbur-Ellis Company
345 California Street, 27th Floor
San Francisco, CA 94104
Office: 415-772-4029
Fax: 415-772-4011
From: Ryan Johnson [mailto:bounce-RyanJohnson@toadworld.com]
Sent: Tuesday, November 18, 2014 2:08 PM
To: toaddatapoint@toadworld.com
Subject: RE: [Toad Data Point - Discussion Forum] Data Point 3.5 Error: Incorrect information in file: ‘.\mysql\proc.frm’
RE: Data Point 3.5 Error: Incorrect information in file: '.\mysql\proc.frm’
Reply by Ryan Johnson
You need to reinitialize Local Storage.
We use the Local Storage when connecting to Non-Relational data sources like Salesforce, and the error here tells me that it somehow got corrupted. We would need to reset it, but do keep in mind
that you may lose whatever data you have stored.
First, start up TDP (DO NOT connect to Salesforce yet!), and go to Tools->Options->Local Storage->General
Find this folder and rename it. Then try connecting to Salesforce.
If something goes wrong, you can clear out whatever folder this generates and rename the former local storage folder to its old name.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad Data Point - General notifications altogether.
Toad Data Point - Discussion Forum
Flag
this post as spam/abuse.
Are you having difficulties to find AppData folder? Please try show hidden files options in your windows explorer.
Here is my suggestion:
Go to the Local Storage - General tab in options, click on the ‘…’ button, and select a folder to move the Local Storage data into. Restart TDP, and attempt to start local storage again.
Close TDP and see if there are any files in that folder you moved it to. If so, then rename that folder and attempt to start TDP and local storage again.
Hi,
I’m not seeing one of my Salesforce Objects in TDP.
I have tried selecting my Salesforce connect while connected and going to View and selecting Refresh All without positive results.
I tried following these instruction however, I’m unable to rename folder because I’m in the folder.
I can’t see the folder outside of TOAD.
Any suggestions?
Thanks,
Rick
Rick Girardi
Business Intelligence Analyst
Enterprise Risk Management
Wilbur-Ellis Company
345 California Street, 27th Floor
San Francisco, CA 94104
Office: 415-772-4029
Fax: 415-772-4011
From: Ryan Johnson [mailto:bounce-RyanJohnson@toadworld.com]
Sent: Tuesday, November 18, 2014 2:08 PM
To: toaddatapoint@toadworld.com
Subject: RE: [Toad Data Point - Discussion Forum] Data Point 3.5 Error: Incorrect information in file: ‘.\mysql\proc.frm’
RE: Data Point 3.5 Error: Incorrect information in file: '.\mysql\proc.frm’
Reply by Ryan Johnson
You need to reinitialize Local Storage.
We use the Local Storage when connecting to Non-Relational data sources like Salesforce, and the error here tells me that it somehow got corrupted. We would need to reset it, but do keep in mind that you may lose whatever data you have stored.
First, start up TDP (DO NOT connect to Salesforce yet!), and go to Tools->Options->Local Storage->General
Find this folder and rename it. Then try connecting to Salesforce.
If something goes wrong, you can clear out whatever folder this generates and rename the former local storage folder to its old name.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad Data Point - General notifications altogether.
Toad Data Point - Discussion Forum
Flag
this post as spam/abuse.
If this does not work. Please open a support ticket and they will help debug this.