Excel Connector Failure

alabastida
alabastida's picture
User offline. Last seen 47 weeks 4 days ago. Offline
Joined: 10/20/2008
Points: 30

Im having the next issue on MS Office Excel 2003.

I was testing the connector for a meeting this afternoon to show it off to a possible customer, i followed the info on the Readme file step-by-step, verifying every single bit of requirements to be achieved, everything seemed to be ok, and then when i tried to configure the presto connection in Excel it throwed up this failure:
************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
   at ExcelPrestoConnect.ConfigurationDlg.ConfigurationDlg_Load(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnLoad(EventArgs e)
   at System.Windows.Forms.Form.OnCreateControl()
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ContainerControl.WndProc(Message& m)
   at System.Windows.Forms.Form.WmShowWindow(Message& m)
   at System.Windows.Forms.Form.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
ExcelPrestoConnect
    Assembly Version: 1.0.3232.18006
    Win32 Version: 1.0.3232.18006
    CodeBase: file:///C:/Archivos%20de%20programa/JackBe/Presto%20Excel%20Connector/Ex...
----------------------------------------
Extensibility
    Assembly Version: 7.0.3300.0
    Win32 Version: 7.00.9466
    CodeBase: file:///C:/WINDOWS/assembly/GAC/Extensibility/7.0.3300.0__b03f5f7f11d50a...
----------------------------------------
Microsoft.Office.Interop.Excel
    Assembly Version: 11.0.0.0
    Win32 Version: 11.0.5530
    CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.Office.Interop.Excel/11.0.0.0_...
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5...
----------------------------------------
office
    Assembly Version: 11.0.0.0
    Win32 Version: 11.0.5530
    CodeBase: file:///C:/WINDOWS/assembly/GAC/office/11.0.0.0__71e9bce111e9429c/office...
----------------------------------------
stdole
    Assembly Version: 7.0.3300.0
    Win32 Version: 7.00.9466
    CodeBase: file:///C:/WINDOWS/assembly/GAC/stdole/7.0.3300.0__b03f5f7f11d50a3a/stdo...
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d...
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/Sy...
----------------------------------------
CustomMarshalers
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/CustomMarshalers/2.0.0.0__b03f5f7f11d...
----------------------------------------
GlassButton
    Assembly Version: 1.2.0.30941
    Win32 Version: 1.2.0.30941
    CodeBase: file:///C:/Archivos%20de%20programa/JackBe/Presto%20Excel%20Connector/Gl...
----------------------------------------
Accessibility
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d5...
----------------------------------------

Thanks for your help.

________________
Adrián Labastida

0
Your rating: None
ivan_mejia
ivan_mejia's picture
User offline. Last seen 8 weeks 5 days ago. Offline
Joined: 09/22/2008
Points: 0

Adrán,

  Can you specify which Windows versions are you using, XP or Vista? My guess that the connector is not being able to read the configuration file, which should be found at the following location per OS version:

Windows XP:

C:\Documents and Settings\<user name>\Application Data\PC4Excel\config.xml

Windows Vista>

C:\Users\<user name>\AppData\Roaming\PC4Excel\config.xml

Ivan

alabastida
alabastida's picture
User offline. Last seen 47 weeks 4 days ago. Offline
Joined: 10/20/2008
Points: 30

Hello Ivan, thanks for your answer.

Im using windows XP, and that path you suggested doesnt even exists, i reinstalled the Presto Excel Connector but still, it doesnt generate a folder like that one, neither in Application Data nor Datos de Programa (since im using XP in spanish),

What could be missing here?

Thanks.

________________
Adrián Labastida

aishmishra
aishmishra's picture
User offline. Last seen 10 weeks 6 days ago. Offline
Joined: 09/24/2008
Points: 3

Hi Adrian,

 1. Maybe you could try using the Everyone and Only Me option once each and see if it makes a difference. It does make a differnce in Vista. Maybe you could try it here.

2. And Application Data is a hidden folder in Windows. I am sure you already know that but better to get it out of the way.

3. Also, any particular setting that would prevent you from creating files on your system?

rohitdugar
User offline. Last seen 2 years 13 weeks ago. Offline
Joined: 10/12/2009
Points: 0

Hi,

 i am facing a similar issue as Ardrian, as per your 3 points mentioned above

 

1. i reinstalled teh connector with "only me" option.

2. Application Data folder is visible

3. Not aware of any setting that would prevent file creation on my system. it would be great if you could specify what kind of settings.

I am using windows XP professional, excel 2003 with service pack 3.. let me know if you need more info.

ivan_mejia
ivan_mejia's picture
User offline. Last seen 8 weeks 5 days ago. Offline
Joined: 09/22/2008
Points: 0

Hi,

   Can you attach here your configuration file, I think you know where to find it, anyway beeing on Windows XP you should find it at the following location:

C:\Documents and Settings\<your user name>\Application Data\PC4Excel\config.xml

Ivan.

rohitdugar
User offline. Last seen 2 years 13 weeks ago. Offline
Joined: 10/12/2009
Points: 0

Thank you for your response,

forgot to mention, there is no such folder as PC4Excel that got created during the installation. hence i dont have any config.xml

ivan_mejia
ivan_mejia's picture
User offline. Last seen 8 weeks 5 days ago. Offline
Joined: 09/22/2008
Points: 0

Ok,

    You have two options: re-install or to manually create the directory and copy the following default configuration file on a file named "config.xml"

<?xml version="1.0" encoding="utf-8"?>
<Configurator xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <ShowToolbar>true</ShowToolbar>
  <CultureId>en-US</CultureId>
  <WebProxyPort>0</WebProxyPort>
  <WebProxyUser />
  <WebProxyPassword />
  <WebProxyEnabled>false</WebProxyEnabled>
  <WebProxyBypassLocalAddresses>false</WebProxyBypassLocalAddresses>
  <Timeout>1</Timeout>
  <UseSelfSignedCertificate>false</UseSelfSignedCertificate>
  <ServerList>
    <ServerEntry>
      <ServerName>localhost</ServerName>
      <Url>http://localhost:8080</Url>
      <User>admin</User>
      <Password>LbOQDaDJ6LATwv9ux9mVRQ==</Password>
    </ServerEntry>
  </ServerList>
  <CurrentServer>
    <ServerName>localhost</ServerName>
    <Url>http://localhost:8080</Url>
    <User>admin</User>
    <Password>LbOQDaDJ6LATwv9ux9mVRQ==</Password>
  </CurrentServer>
</Configurator>

karlm
User offline. Last seen 2 years 4 weeks ago. Offline
Joined: 01/08/2010
Points: 10

Having the same problem - that directory doesn't exist even after several reinstalls with everyone/just me options.  Also noticed that the toolbar is no longer available for use after the first run of excel.  Once you close the app it's gone from the toolbar picklist.

 

Is this ready for production use?

aishmishra
aishmishra's picture
User offline. Last seen 10 weeks 6 days ago. Offline
Joined: 09/24/2008
Points: 3

Hi Karl,

Please provide us with some details about your system.

i. OS and version including service pack version, if any.

ii. Any anti-virus or similar security product or OS based security features like like UAC(User Access Control) enabled on your machine.

Presto Excel Connector has been tested on multiple platforms - I am sure we can get it working on yours.

Do let us know the details.

karlm
User offline. Last seen 2 years 4 weeks ago. Offline
Joined: 01/08/2010
Points: 10

win xp sp2

office 2003 std.

Mcafee AV, though I disabled it.  After the install the directory that the above user mentioned does not exist, nor does the config.xml file.  Creating it manually does nothing to help.