Thread: Inatallation Problem

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/d...displaylang=en

MSXML Parser 3 =
http://www.microsoft.com/downloads/d...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