ContributionsMost RecentMost LikesSolutionsRe: Scraping data from a desktop application Try having a look in the Object Browser while you have the executable running. You should be able to browse it's object model and have a look at whether the values you're looking for are available to TC. That's where I'd start. Once you find it you can right click and make an alias for it then address it in code as Aliases.Blah.Blah.blah.StuffImLookingFor Re: Testing Destination of Windows Shortcut lnk in Start Menu Win7x64 Thanks for the tips Robert. This is what I ended up with in case anyone else is looking for this later, in javascript function Test_SCExists_GetSCPath() { if (!IsShortcutValid("Programs|Accessories|Paint", "|")) { Log.Error("Shortcut is not valid"); return; } Log.Message("Shortcut is valid"); var target = GetShortcutTarget("Programs|Accessories|Paint", "|"); if (!target) { Log.Error("Shortcut doesn't exist"); return; } Log.Message(target); } function IsShortcutValid(shortcutPath, separator) { var StartDir, path, shortcut; StartDir = "C:\\ProgramData\\Microsoft\\Windows\\Start Menu\\"; path = shortcutPath.split(separator).join("\\") + ".lnk"; if (aqFileSystem.Exists(StartDir + path)) { shortcut = WshShell.CreateShortcut(StartDir + path); return aqFileSystem.Exists(shortcut.TargetPath); } return false; } function GetShortcutTarget(shortcutPath, separator) { var StartDir, path, shortcut; StartDir = "C:\\ProgramData\\Microsoft\\Windows\\Start Menu\\"; path = shortcutPath.split(separator).join("\\") + ".lnk"; if (aqFileSystem.Exists(StartDir + path)) { shortcut = WshShell.CreateShortcut(StartDir + path); return shortcut.TargetPath; } return false; } Testing Destination of Windows Shortcut lnk in Start Menu Win7x64 Hi, I'm trying to get this JScript fromhttps://support.smartbear.com/viewarticle/8967/ working in TestComplete 12.6 on Win7x64. It's to verify the target value of the shortcut (what it's trying to run). This script is throwing an error: JavaScript runtime error ReferenceError: ActiveXObject is not defined Error location: Unit "script unit name" Line 14 Column 18 { if (!IsShortcutValid("Programs|Accessories|Paint", "|")) { Log.Error("Shortcut is not valid"); return; } Log.Message("Shortcut is valid"); } function IsShortcutValid(shortcutPath, separator) { var WshShell, fso, startDir, allUsersStartDir, path, shortcut; WshShell = new ActiveXObject("WScript.Shell"); startDir = WshShell.SpecialFolders("StartMenu") + "\\"; allUsersStartDir = WshShell.SpecialFolders("AllUsersStartMenu") + "\\"; path = shortcutPath.split(separator).join("\\") + ".lnk"; fso = new ActiveXObject("Scripting.FileSystemObject"); if (fso.FileExists(startDir + path)) { shortcut = WshShell.CreateShortcut(startDir + path); return fso.FileExists(shortcut.TargetPath); } if (fso.FileExists(allUsersStartDir + path)) { shortcut = WshShell.CreateShortcut(allUsersStartDir + path); return fso.FileExists(shortcut.TargetPath); } return false; } Any advice greatly appreciated. Pete SolvedRe: Database connection to MS SQL Server 2008 R2 Does the server name you supply resolve to an IP address on the workstation you're running on? Can you setup an ODBC datasource just test that those credentials and details work from that PC? Re: Why Testing Matters: Community Comments LOL!!!! Hows the irony ofusing a dead link to an article about why testing matters:smileylol: Made my day. Re: Find and Replace with Regular Expression in Script using Javascript Thanks tristaanogre, that tipped me off. Needed the gi switch at the end to work and it was using the javascript re syntax not the native testcomplete one.Below is the working code. function UseRegex() { var regex = /\s+/gi; var Instr = " Words with too much space |"; var ResStr = Instr.replace(regex," "); Log.Message(ResStr); } Re: Database Checkpoint For MS Access 2016 Database Sorry I forgot to respond. It was an access database created in a 32bit version of access 2013. Ran it up in the 32bit version of TestComplete and it's working like a charm. Thanks for the advice :) Re: Basic test step with regex (regular expression) is not working Yes, it is a little bit different. Documented here: https://support.smartbear.com/testcomplete/docs/reference/misc/regular-expressions.html Find and Replace with Regular Expression in Script using Javascript Hi, i'm having trouble with doing a find and replace using regex on a string in a script using Javascript. The idea is to get rid of all multiple consecutive white space characters in the string and leave only single spaces in their place .... so.... | this has too much | would become | this has too much | My plan was to just locate anywhere where there's 2 or more whitespaces and replace them with a single whitespace. I couldn't figure out the {2,} style to say 2 or more then I got tangled up and now I'm here. Below is test code to demonstrate: var regEx; var ResStr = ""; var Instr = " Words with too much space |"; regex = "\b+"; ResStr = Instr.replace(regEx,' '); BuiltIn.ShowMessage(ResStr); The result is an unaltered string. The goggles.... they do nothing... Any tips on where I'm going wrong? Pete :) SolvedDatabase Checkpoint For MS Access 2016 Database I'm attempting to create a Database Checkpoint in a TestComplete test. The database is an MS Access 2016 accdb file and I'm running on Win7x64 as an unprivileged user on the corporate domain. In the first dialog (yes, i hit the deck and slid on my face at the first prompt)it prompts for a connection string. I am feeding it: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\SharedData\AccessDatabase.accdb;Persist Security Info=False; and getting error: Unable to connect to the specified data source. The database engine reports: Provider cannot be found. It may not be properly installed. I've had a bit of a dig around online but couldn't find the answer. Any tips guys? Solved