Page 1 of 4 123 ... LastLast
Results 1 to 10 of 39

Thread: Com Error & Asp.net

  1. #1
    keroed1 Guest

    Default Com Error & Asp.net

    i have a aspx page that i use to generate a excel sheet but on my computer at home it works, but wheni carry it to another computer i get this error
    ::::::::::::
    COM OBject with CLSID {0002E541-0000-0000-C000-000000000046} is either not valid or not registered
    Last edited by keroed1; May 17, 2006 at 10:24 PM.

  2. #2
    keroed1 Guest

    Default

    Question guys how can i use asp.net to connect to a access database and sum up the values of a column in a specifc table, can any one jus give me an example of how u would do this

  3. #3
    keroed1 Guest

    Default

    dont worry guys have been researching and i found out how to do the second one but i have'nt found any solution as yet for the com error?? any help

  4. #4
    Join Date
    Sep 2004
    Posts
    1,905
    Rep Power
    21

    Default

    The client computer does not have
    0002E541-0000-0000-C000-000000000046
    registered

    You can try other versions on the client
    0002E551-0000-0000-C000-000000000046
    0002E510-0000-0000-C000-000000000046

    See hoe here
    http://p.ulh.as/xploitsdb/NT/5254.html
    Let's act on what we agree on now, and argue later on what we don't.
    Black men leave Barbeque alone if Barbeque don't trouble you

  5. #5
    Join Date
    Feb 2005
    Posts
    73
    Rep Power
    0

    Default

    Again it is a good idea to post seperate questions in seperate posts, I am glad you worked out the second question through though. An example of why this is a good idea is, I have never used excel with asp.net, so I might not even look at this post, if I do I might miss the second question becaue if I had looked at it before you posted the second question I would not look at it again because I wouldnt think I could help and I would find think the topic was irrelivent to me. However I do use access so I may have been able to help with that question.

  6. #6
    keroed1 Guest

    Default

    Quote Originally Posted by crosswire
    The client computer does not have
    0002E541-0000-0000-C000-000000000046
    registered

    You can try other versions on the client
    0002E551-0000-0000-C000-000000000046
    0002E510-0000-0000-C000-000000000046

    See hoe here
    http://p.ulh.as/xploitsdb/NT/5254.html
    I am reading the page you sent me to but i am unsure of wati should do, initially in my code all i did was in my Mypage.aspx.vb i had this code

    Imports OWC10

    Sub ExportToExcel()
    Dim xlSheet As SpreadsheetClass
    Dim numberCols As Integer

    xlSheet = New SpreadsheetClass()

    conAcc = New OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0; DATA Source=" & Locate_Database() & " ")
    conAcc.Open()
    cmdSelect = New OleDbCommand(GetQuery(), conAcc)
    If Not (extension.Text = "") Then
    cmdSelect.Parameters.Add("@ext", extension.Text)
    End If
    cmdSelect.Parameters.Add("@startdate", From_Date.Value)
    cmdSelect.Parameters.Add("@enddate", To_Date.Value)
    Dim dtrResults As OleDbDataReader = Me.cmdSelect.ExecuteReader()
    numberCols = dtrResults.FieldCount
    Dim row As Integer = 1
    Dim colCount As Integer = 0

    'write headings
    xlSheet.Cells(1, 1) = "Extension"
    xlSheet.Cells(1, 2) = "Code Used"
    xlSheet.Cells(1, 3) = "Date of Call"
    xlSheet.Cells(1, 4) = "Time of Call"
    xlSheet.Cells(1, 5) = "Number Dialled"
    xlSheet.Cells(1, 6) = "Call To"
    xlSheet.Cells(1, 7) = "Duration"
    xlSheet.Cells(1, 8) = "Cost $"
    row = 2

    While dtrResults.Read()
    Dim i As Integer = 0
    While i < numberCols
    If dtrResults.GetValue(i).ToString.IndexOf("!") > 0 Then
    Dim x As Integer
    x = dtrResults.GetValue(i).ToString().LastIndexOf("!")
    xlSheet.ActiveSheet.Cells(row, i + 1) = dtrResults.GetValue(i).ToString().Substring(0, x)
    Else
    xlSheet.ActiveSheet.Cells(row, i + 1) = dtrResults.GetValue(i).ToString()
    End If
    i += 1
    End While
    row += 1
    End While

    With xlSheet.Range("A1")
    .Font.Bold = True
    .Font.Color = "Blue"
    .EntireColumn.AutoFit()
    End With

    With xlSheet.Range("B1")
    .Font.Bold = True
    .Font.Color = "Blue"
    .EntireColumn.AutoFit()
    End With

    With xlSheet.Range("C1")
    .Font.Bold = True
    .Font.Color = "Blue"
    .EntireColumn.AutoFit()
    .EntireColumn.NumberFormat = "dd-MMM-yyyy"
    End With

    With xlSheet.Range("D1")
    .Font.Bold = True
    .Font.Color = "Blue"
    .EntireColumn.NumberFormat = "hh:mm:ss AM/PM"
    .EntireColumn.AutoFit()
    End With

    With xlSheet.Range("E1")
    .Font.Bold = True
    .Font.Color = "Blue"
    .EntireColumn.AutoFit()
    End With

    With xlSheet.Range("F1")
    .Font.Bold = True
    .Font.Color = "Blue"
    .EntireColumn.AutoFit()
    End With

    With xlSheet.Range("G1")
    .Font.Bold = True
    .Font.Color = "Blue"
    .EntireColumn.AutoFit()
    .EntireColumn.NumberFormat = "h:mm:ss"
    End With

    With xlSheet.Range("H1")
    .Font.Bold = True
    .Font.Color = "Blue"
    .EntireColumn.AutoFit()
    .EntireColumn.NumberFormat = "Currency"
    End With

    dtrResults.Close()
    conAcc.Close()

    Stored_File_Name = Name_File()
    lbl_location.Text = ("<a href='" + "\CallAccounting\Reports\Long Distance Calls\Long Distance Calls" & Stored_File_Name + ".xls" + "'>" + "Long_Distant_Calls" + Stored_File_Name + ".xls")
    xlSheet.Export("C:\Inetpub\wwwroot\CallAccounting\ Reports\Long Distance Calls\Long Distance Calls" & Stored_File_Name & ".xls", OWC10.SheetExportActionEnum.ssExportActionNone)

    end sub

    so i not tooo sure where i should be trying to put the "0002E510-0000-0000-C000-000000000046" u were telling me about

  7. #7
    keroed1 Guest

    Default

    Question right since the diiferent offices use different owc's, whaty i getting is that iguess owc9 is microsoft office 2000 and the next one owc10 that i use i guess is office 2003.........so the machine that i getting the error on, could a solution be that they install office 2003???????

  8. #8
    keroed1 Guest

    Default

    still not sure guys any one out there can help??????

  9. #9
    Join Date
    May 2003
    Posts
    108
    Rep Power
    0

    Default

    You dont need to install the entire Office XP, just OWC10.msi.

  10. #10
    Join Date
    Feb 2005
    Posts
    73
    Rep Power
    0

    Default

    11/10/2004 11:24:14 AM Re: Error: COM object with CLSID {0002E542-0000-0000-C000-000000000046} is either not valid or not registered.
    this is an undocumented service pack 3 guid. so you must first install owc

    and then add the required service packs
    http://66.102.7.104/search?q=cache:M...n&ct=clnk&cd=1

    I believe that this is owc10 so I think you are correct that you need to update your new server or make your code backward compatable. Though I have no clue how you would do that or even if it is possible with what you want to do.

    Edit: So I agree agree with fatta77. I just was no where near as clear

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •