SQL Excel

Hi !

I'm using Windows XP Professional 5.1 SP2 with Excel 2003 SP3.
I have installed SQL Excel with sucsses ( no error messages), but when I open excel I got an error message : 'ActiveX component can't create object (AddButton)'

The SQL Excel buttons are created anyway but, trying to open it (SQL button) shows another error message: 'There appears to be a problem with the installation of the Addin. Please check that you have the Connection.Settings.xml file in the same folder as the DLL. Please try reinstalling and report this problem.'

I have tryed to reinstall more than twice with the same result. The connection.Settings.xml file is in the c:\program files\sql excel\ and so is the SQLExel.dll.

I wonder if someone else ever reported something like that, and if you can give me a help on that.

Thanks

Hi Marco

Sorry for the problem. Please can you check the following

(1) Please can you make sure you have the most recent package - Version 1.3. You can check it by hitting the "Coffe Cup" on the right hand side of the toolbar (will show the about form and you can see the version there..)
Previous versions would have the connection_settings.xml fil in "C:\Program Files\SQL Excel" but version 1.3 should have the connection_settings.xml file in
C:\Documents and Settings\[USERNAME]Application Data\sqlexcel

If you have an older version please close out of Excel, uninstall from the control panel and then download the new version here http://www.sqlexcel.net/dload/sql_excel_setup.zip
Sorry to ask you to do that but normally with the new version (1.3) you would not have the connection_settings.xml file in the location it shows on your machine.

(2) Please try to manually register the DLL. It is possible the file was not correctly registered (would be weird but it can happen).
To do so, you can select START and then RUN and then enter and run this command
regsvr32 "C:\Program Files\SQL Excel\SQLExcel.dll"
You should get a message that the registration succeeded.

If the admin registers the file for your account. The add-in should be available.
Please let me know how this goes. I hope this fixes the problem

Al

Hi Marco !

Hope all is fine. Just wondering if you got the addin working ?

I hope the registration of the dll worked out for you.

Have a nice night,
Al

Hi

Sorry to say it didn't work. I have updated the version but it changed nothing. Trying to register the dll returns error code 0x80004005.
Guess it might be something with my windows installation.
Thanks any way.

Sorry you are having the problems Marco.

If you want to try to fix it, I would first check to see if your installation of the MSXML parser is ok.

Here is a test routine (call it from Office VBA module) you could run to see if the parser is ok on your machine. If this routine fails you need to look into your installation of the msxml parser.

Code:

Sub TestMSXMLParser() Dim oXMLDoc As Object Set oXMLDoc = CreateObject("MSXML2.DOMDocument") Set oXMLDoc = Nothing End Sub

If you are not familiar with VBA - you need to paste the routine into a vba module (ALT F11, then use the insert from the menu to create a new module, and then select the empty module and then paste in the routine..) Then you could use the F5 key after selecting a line within the routine to run it.. If this does not run, you should try to reinstall the same version of MSXML that you have now. You could run the "fix" from the ccntrol panel I think to do this the easy way. Here are some links on the MSXML parser if you want to check more on it. MSXML Parser 4 = http://www.microsoft.com/downloads/details.aspx?familyid=3144B72B-B4F2-46DA-B4B6-C5D7485F2B42&displaylang=en MSXML Parser 3 = http://www.microsoft.com/downloads/details.aspx?familyid=28494391-052b-42ff-9674-f752bdca9582&displaylang=en Sorry again for this problem. It is something strange as this is the first time that I am aware of that someone had a problem that was not fixable by re-registering the DLL... So it seems like one of the dependencies has a problem. I would bet it is the MSXML parser but could not say for sure... I will be happy to try to help as much as I can.. Al

Hi !!

It's working!! And it is really a grate tool. Congratulations !!

Thanks a lot for your help. It was really a trouble with my msxml2. I fixed it using old regmon to identify 'access denied' event when trying to register the sqlexcel.dll. Once identified the registers I changed permission and reinstalled sqlexcel, this time with success.

Thanks Again

Great you got it working man !
Hope all goes smooth with it from now on.
Thanks,
Al