divernut
Occasional Contributor
Joined 15 years ago
User Profile
User Widgets
Contributions
Opening a database cannection to oracle
I am having trouble using the Open() to open a connection to my oracle database. I use AConnection = ADO.CreateConnection(); AConnection.ConnectionString = "Driver=Microsoft ODBC for Oracle;dbq=bluff:1521/fc3;UId=fcsrv;Pwd=fcsrv;"; to set the connection but when I use Aconnection.Open() testcomlete keeps wanting some sort of parameter in the parenthesis. I have put everthing I can think of in them but nothing works.4.8KViews0likes1CommentRe: cannot run Sys. commands from my machine
Just another example is when he uses the //aqFileSystem.DeleteFolder("C:\\Users\\" + Sys.UserName + "\\AppData\\Local\\Flow-Cal, Inc\\CALCit\*", true); I have to use aqFileSystem.DeleteFolder("C:\\Users\\robert.COASTAL\\AppData\\Local\\Flow-Cal, Inc\\CALCit\*", true); in order to acess the users info on my machine. Mine soes not like the Sys.UserName for some reason.2KViews0likes0CommentsRe: cannot run Sys. commands from my machine
I apologies I was wrong. He did not get it from the help but from another post on here. http://smartbear.com/forums/forum/post/?mode=singleThread&thread=c8180fd1-d3bf-4b4b-9495-0a9e28bb1fd8 the following is the actual script we are trying to use. var applicationName = "CALCit x64"; var bCaption = "Uninstall*"; var WshShell = new ActiveXObject("WScript.Shell"); var oExec = WshShell.Exec("RunDll32.exe shell32.dll," + "Control_RunDLL appwiz.cpl,,0"); Delay(2000); Sys.Process("Explorer").Refresh(); //var wnd = Sys.Process("Explorer").FindChild("WndCaption", "Programs and Features"); var wnd = Aliases.Explorer.wndCabinetWClass.ShellTabWindowClass.DUIViewWndClassName.DirectUIHWND.CtrlNotifySink.ShellView.FolderView; if (!wnd.Exists) { Log.Error("The 'Programs and Features' window was not found"); } We have identical machines with the same processor, ram O.S. everything. He can run the code that is commented out above but when I uncomment it and comment the Aliases out it bombs. We have checked our options in testcomplete and they seem to be set the same. We are asigning the FindChild to a var and then use it. If I uncomment the var wnd=Sys.Process line and comment the Aliases.Explorer line I get the following error. The error log says: The 'Programs and Features' window was not found Also you will notice the first Sys.Process("Explorer").Refresh(); is not commented out and Testcomplete does not compolain about it, just the next line. I do not know what you mean by mapping criteria set up in your Alias definition.2KViews0likes0CommentsRe: cannot run Sys. commands from my machine
But we are using the same project from a repository and he has name mapping enabled on his just like mine. But the Sys script works on his but not mine. Our properties and options are set the same so shouldn't the project act the same on both machines?2KViews0likes0Commentscannot run Sys. commands from my machine
We have three people using Testcomplete 8 in our office and two of them can run Sys. commands but my testcomplete won't. I have to use the name mapped script. ex: they can run Sys.Process("Explorer").FindChild("WndCaption", "Programs and Features"); and I have to use Aliases.Explorer.wndCabinetWClass.ShellTabWindowClass.DUIViewWndClassName.DirectUIHWND.CtrlNotifySink.ShellView.FolderView; Is there a setting under properties that I have set that they do not or visa versa? Robert17KViews0likes11Comments