Page 1 of 2
Salesforce with dotConnect for MySql
Posted: Wed 07 Jan 2015 01:26
by emp51302
Can dotConnect for Salesforce be used in conjunction with dotConnect for MySql? We use dotConnect for MySql in our projects and need Salesforce access withing our applications.
Please advise.
Re: Salesforce with dotConnect for MySql
Posted: Thu 08 Jan 2015 14:25
by Shalex
emp51302 wrote:Can dotConnect for Salesforce be used in conjunction with dotConnect for MySql?
Yes, it can.
Devart ADO.NET data providers use a common assembly (Devart.Data.dll), so it is necessary to install compatible providers versions. We release our ADO.NET data providers in a single pack, thus releases from the same date should be compatible:
http://www.devart.com/dotconnect/mysql/ ... story.html
http://www.devart.com/dotconnect/salesf ... story.html
To download the licensed version of our provider, please use the credentials (URL, account name, and password) that were sent to you after the purchase of our product.
You can find any previous version in Registered Users' Area in the following way: click "Previous versions" on the "Download" page > the list of all versions should include a particular build you may look for as well.
Updated: pointed to the dotConnect for Salesforce revision history page.
Re: Salesforce with dotConnect for MySql
Posted: Thu 08 Jan 2015 20:57
by emp51302
Hi Thanks. We don't use SQLite. All we use is dotConnect for MySQL. So we want to download the latest version of Salesforce dotConnect and then use it in conjunction with our current dotConnect with MySQL. We are using a little older version of dotConnect for MySQL and not the latest one. Will current Salesforce for dotConnect still work?
Thank you
Re: Salesforce with dotConnect for MySql
Posted: Fri 09 Jan 2015 08:29
by Shalex
I have corrected my original message.
emp51302 wrote:We are using a little older version of dotConnect for MySQL and not the latest one. Will current Salesforce for dotConnect still work?
Only compatible (released from the same date) providers versions will work smoothly on the same workstation.
Re: Salesforce with dotConnect for MySql
Posted: Fri 09 Jan 2015 16:02
by emp51302
Thanks. I have both the correct versions installed successfully.
I am trying to test the DemoCenter app which comes with the Salesforce dotConnect Trial, But when I try to login with my credentials, I get an error.
The credentials I am using are correct. Please help. See attached image.
Thank you.
Re: Salesforce with dotConnect for MySql
Posted: Mon 12 Jan 2015 09:55
by Shalex
We cannot reproduce the issue at the moment. Please specify the following information:
1) the exact build of your dotConnect for Salesforce (via the Tools > Salesforce > About menu of Visual Studio)
2) the call stack of the error with all inner exceptions
For this:
a) create a Class Library project
b) navigate to its Properties > Debug, select the "Start external program" option and specify the path to Demo Center (e.g.: C:\Program Files (x86)\Devart\dotConnect\Salesforce\DemoCenter\DemoCenter.exe )
c) go to Tools->Options...->Debugging, and disable the Enable Just My Code (Managed Only) check box
d) navigate to Debug->Exceptions and enable Common Language Runtime Exceptions check box
e) now press Start Debugging (F5) and catch the inner exception with a detailed call stack
Re: Salesforce with dotConnect for MySql
Posted: Thu 29 Jan 2015 18:11
by emp51302
Hi - This is how the CallStack looks. Also the login url I am using to login is: login.salesforce.com/services/Soap/u/32.0
I entered all other details like username, pwd and security token except the Proxy Address.
Please advise, why I am getting the exception. I am using the latest dotConnect for Salesforce released Jan 29, 2015.
Thank you,
Code: Select all
Devart.Data.Salesforce.dll!Devart.Data.Salesforce.SalesforceConnection.Open() Unknown
DemoCenter.exe!DemoCenter.DemoContext.ApplyConnectionString(string serverUrl, string user, string password, string securityToken, string proxyAddress) Unknown
DemoCenter.exe!DemoCenter.Pages.ConnectionPage.ProceedButton_Click.AnonymousMethod__0() Unknown
DemoCenter.exe!DemoCenter.UIUtils.InvokeAction(System.Action a) Unknown
DemoCenter.exe!DemoCenter.Pages.ConnectionPage.ProceedButton_Click(object sender, System.Windows.RoutedEventArgs e) Unknown
PresentationCore.dll!System.Windows.EventRoute.InvokeHandlersImpl(object source, System.Windows.RoutedEventArgs args, bool reRaised) Unknown
PresentationCore.dll!System.Windows.UIElement.RaiseEventImpl(System.Windows.DependencyObject sender, System.Windows.RoutedEventArgs args) Unknown
PresentationFramework.dll!System.Windows.Controls.Button.OnClick() Unknown
PresentationFramework.dll!System.Windows.Controls.Primitives.ButtonBase.OnMouseLeftButtonUp(System.Windows.Input.MouseButtonEventArgs e) Unknown
PresentationCore.dll!System.Windows.RoutedEventArgs.InvokeHandler(System.Delegate handler, object target) Unknown
PresentationCore.dll!System.Windows.EventRoute.InvokeHandlersImpl(object source, System.Windows.RoutedEventArgs args, bool reRaised) Unknown
PresentationCore.dll!System.Windows.UIElement.ReRaiseEventAs(System.Windows.DependencyObject sender, System.Windows.RoutedEventArgs args, System.Windows.RoutedEvent newEvent) Unknown
PresentationCore.dll!System.Windows.RoutedEventArgs.InvokeHandler(System.Delegate handler, object target) Unknown
PresentationCore.dll!System.Windows.EventRoute.InvokeHandlersImpl(object source, System.Windows.RoutedEventArgs args, bool reRaised) Unknown
PresentationCore.dll!System.Windows.UIElement.RaiseEventImpl(System.Windows.DependencyObject sender, System.Windows.RoutedEventArgs args) Unknown
PresentationCore.dll!System.Windows.UIElement.RaiseTrustedEvent(System.Windows.RoutedEventArgs args) Unknown
PresentationCore.dll!System.Windows.Input.InputManager.ProcessStagingArea() Unknown
PresentationCore.dll!System.Windows.Input.InputProviderSite.ReportInput(System.Windows.Input.InputReport inputReport) Unknown
PresentationCore.dll!System.Windows.Interop.HwndMouseInputProvider.ReportInput(System.IntPtr hwnd, System.Windows.Input.InputMode mode, int timestamp, System.Windows.Input.RawMouseActions actions, int x, int y, int wheel) Unknown
PresentationCore.dll!System.Windows.Interop.HwndMouseInputProvider.FilterMessage(System.IntPtr hwnd, MS.Internal.Interop.WindowMessage msg, System.IntPtr wParam, System.IntPtr lParam, ref bool handled) Unknown
PresentationCore.dll!System.Windows.Interop.HwndSource.InputFilterMessage(System.IntPtr hwnd, int msg, System.IntPtr wParam, System.IntPtr lParam, ref bool handled) Unknown
WindowsBase.dll!MS.Win32.HwndWrapper.WndProc(System.IntPtr hwnd, int msg, System.IntPtr wParam, System.IntPtr lParam, ref bool handled) Unknown
WindowsBase.dll!MS.Win32.HwndSubclass.DispatcherCallbackOperation(object o) Unknown
WindowsBase.dll!System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate callback, object args, int numArgs) Unknown
WindowsBase.dll!MS.Internal.Threading.ExceptionFilterHelper.TryCatchWhen(object source, System.Delegate method, object args, int numArgs, System.Delegate catchHandler) Unknown
WindowsBase.dll!System.Windows.Threading.Dispatcher.LegacyInvokeImpl(System.Windows.Threading.DispatcherPriority priority, System.TimeSpan timeout, System.Delegate method, object args, int numArgs) Unknown
WindowsBase.dll!MS.Win32.HwndSubclass.SubclassWndProc(System.IntPtr hwnd, int msg, System.IntPtr wParam, System.IntPtr lParam) Unknown
[Native to Managed Transition]
[Managed to Native Transition]
WindowsBase.dll!System.Windows.Threading.Dispatcher.PushFrameImpl(System.Windows.Threading.DispatcherFrame frame) Unknown
PresentationFramework.dll!System.Windows.Application.RunInternal(System.Windows.Window window) Unknown
PresentationFramework.dll!System.Windows.Application.Run() Unknown
DemoCenter.exe!DemoCenter.App.Main() Unknown
Re: Salesforce with dotConnect for MySql
Posted: Fri 30 Jan 2015 12:09
by Shalex
Try the following:
1. Please reinstall dotConnect for Salesforce in the following way:
a) uninstall dotConnect for Salesforce and other Devart ADO.NET products
b) make sure that there are no Devart.* and policy.*.Devart.* files in the following folders:
* \Program Files (x86)\Microsoft Visual Studio XX.X\Common7\IDE\PrivateAssemblies\Devart\
* GAC 2.0 (\Windows\assembly\)
* GAC 4.0 (\Windows\Microsoft.NET\assembly\)
* \Program Files (x86)\Devart\
* \Program Files (x86)\Common Files\Devart\
* \Documents and Settings\All Users\Devart\ (clear the folder)
c) run installation of dotConnect for Salesforce v 2.4.563 via its right click > Run as administrator menu
2. Specify "login.salesforce.com" instead of "login.salesforce.com/services/Soap/u/32.0" in your connection string.
Notify us about the result.
Re: Salesforce with dotConnect for MySql
Posted: Mon 23 Feb 2015 21:29
by emp51302
Hi Shalex - I am still trying to test the trial version of Salesforce. It says my trial period is expired. Do you think I can get another 30 days please? I cannot check if the steps you told me would work and only then I can purchase it.
Thank you,
Re: Salesforce with dotConnect for MySql
Posted: Tue 24 Feb 2015 08:51
by Shalex
We have just sent an extended trial (30 days more) to the email address specified in your forum profile.
Re: Salesforce with dotConnect for MySql
Posted: Tue 24 Feb 2015 17:08
by emp51302
Thank you for the 30 days extension. Ia m getting the same error "Object Reference Not set to an instance of an object"
Ia m filing in all the fields except the Proxy filed in the demo app. Do I need the proxy settings?
I just want to make the sample demo app work so that I can explore.
Best,
Re: Salesforce with dotConnect for MySql
Posted: Thu 26 Feb 2015 15:37
by emp51302
Hi Shalex - Any update on this? I am now kind of getting impatient to know if there is any solution to Salesforce Login issue. We are doing everything correct from our end, including the login credentials and Security Token. Clean installed on a brand new machine, still the same issue.
Please advise.
Thank you
Re: Salesforce with dotConnect for MySql
Posted: Fri 27 Feb 2015 17:14
by Shalex
1. Please remove the c:\Users\your_OS_user\AppData\Roaming\Devart\Salesforce\DemoCenter\Settings.xml file and try DemoCenter again. Does this help?
2. Go to Tools->Options...->Debugging, and disable the Enable Just My Code (Managed Only) check box. Then go to Debug->Exceptions and enable Common Language Runtime Exceptions check box. Now create a simple console application and call
conn.Open(). When exception occurs with a popup window, click "Copy exception detail to the clipboard" and
send us the obtained information.
3. Navigate to Tools > Salesforce > About and specify your current (x.x.x) build.
Re: Salesforce with dotConnect for MySql
Posted: Fri 27 Feb 2015 18:32
by emp51302
Hi Shalex - I have already sent the call stack before. Please see the chain of messages.
Also I have done both the steps 2 weeks back and also replied with the CallStack. It just doesn't work. I did a fresh install too on a brand new machine and still no luck. Its bizzare that why on connection.open() it crashes!!! Username, Password, Security token all are correct! But the Demo Apps don;t even login at all!
Please advise and please help.
Re: Salesforce with dotConnect for MySql
Posted: Mon 02 Mar 2015 11:33
by Shalex
1. The call stack specified at
http://forums.devart.com/viewtopic.php?t=31047#p107172 is not complete and doesn't allow us to identify the reason of the problem at your side (we cannot reproduce the issue in our environment). Please perform the following steps and specify a detailed information about the exception thrown on conn.Open() in console application:
Shalex wrote:Go to Tools->Options...->Debugging, and disable the Enable Just My Code (Managed Only) check box. Then go to Debug->Exceptions and enable Common Language Runtime Exceptions check box. Now create a simple console application and call conn.Open(). When exception occurs with a popup window, click "Copy exception detail to the clipboard" and send us the obtained information.
2. Navigate to Tools > Salesforce > About and specify your current (x.x.x) build.