×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

ActiveX component can't create object: 'TDApiOle80.TDConnection'

ActiveX component can't create object: 'TDApiOle80.TDConnection'

ActiveX component can't create object: 'TDApiOle80.TDConnection'

(OP)
I am able to successfully execute the following code as an excel macro. However I wanted to be able to run this code using vbscript. When I run this from my html page I encounter:

Microsoft VBScript runtime error '800a01ad'

ActiveX component can't create object: 'TDApiOle80.TDConnection'

on this line: Set tdc = CreateObject("TDApiOle80.TDConnection")




<BODY onload="vbscript:Call Hello()">

<SCRIPT language=VBScript>
sub Hello()
msgbox "Hello"
Set tdc = CreateObject("TDApiOle80.TDConnection")
tdc.InitConnectionEx "http://server:1234/qcbin"
tdc.Login "admin", "Password"
tdc.Connect "Domain", "Project"
msgbox("Defect Raised")

'============================================
Set BugFactory = tdc.BugFactory
Set BugFilter = BugFactory.Filter
BugFilter.Filter("BG_BUG_ID") = DefectID
Set BugList = BugFilter.NewList
Set myBug = BugList.Item(1)

Set myBug = BugFactory.AddItem(Null)

'Enter values for required fields
myBug.Field("BG_STATUS") = "New" 'Status
myBug.Field("BG_Responsible") = "steveh" 'Assigned to

myBug.Field("BG_Priority") = "Minor"
myBug.Field("BG_User_12") = "ALL"
myBug.Field("BG_User_11") = "Access"
myBug.Field("BG_Subject") = "1"
myBug.Post
msgbox("Defect Raised")
end sub

RE: ActiveX component can't create object: 'TDApiOle80.TDConnection'

A quick google search on TDApiOle80 shows that you may need to use the 32-bit version of wscript (or cscript, whichever you use). These can be found in the c:\Windows\SysWOW64 folder.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close