Contributions
Could not find installable ISAM error.
I'm using TC10 on windows 7 with Office 2010 and I'm trying to connect to Excel and select the data with an SQL statement.When my Excel file was still .xls and I used the Jet4 connection string, it worked fine. So Isaved myfile as Excel 2010 (.xlsx) and updated the connection string to what's shown below and it started to fail. We are running the 32bit office so I installed the 32bit access piece from Microsoft but I still get the error. The error comes on the connection.open line. ConnStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strDatabase + "; [Sheet$1]" + _ ";Extended Properties=Excel 12.0 Xml;HDR=No;IMAX=1;" Set Connection = Sys.OleObject("ADODB.Connection") Connection.Open(ConnStr)3.3KViews0likes3CommentsRe: Can I make TestComplete not log an error?
Thanks. If yousaw my full function you would see that my code and yours are doing the same thing, except I'm looping through an array of objects starting at the page level down through the final control on the page.Your comment about "can't don't waitchild if the object doesn't exist" made me realize that in my case I'm getting to an object like SELECT and there are none on the page. Therefore when I try to do SELECT.waitchild(cmbStates,100) I'm getting my error. So I need to put a check for exists in my loop and as soon as I hit a false I need to exit my loop. Thanks again. JJ789Views0likes0CommentsCan I make TestComplete not log an error?
I'm using this line of code "Set TempObj = TempObj.WaitChild(NamesArr(i),10)" to get an object to test with and I know sometimes it isn't going to exist so I would like to stop TestComplete from logging "The object does not exist. See Additional Information for details. You are trying to call the "WaitChild" method or property of an object that does not exist." I have code in place to check when to report a missing object error based on what I'm testing. Does anyone know if I can turn off this error? John18KViews0likes2CommentsRe: Problems with Code Explorer in TC 8
I'm sorry I don't have any IDs to give you. All I did was let the system send in the info it collected when the software crashed. I think I did attach a message to one of them so you should have my email address. The crashes happened around 12/20 or 12/21 when I was working on the code explore page. I could probably reproduce the issue as it was happening almost every time I typed something. Let me know if you want me to recreate the situation and collect any info for you. John1KViews0likes0Comments