Contributions
Connection string galore
Good morning, I’m having a hard time finding documentation on how to properly get a connection string to execute a stored procedure contained in an Oracle Database package through ODBC… Using the interface, I can create database checkpoints no problem and the connection to the database is working properly. There is some connection string utility that can create it from scratch and test the connexion. So far all those works fine. However, if I use the connection string provided by TC and then paste it into a JScript Routine using the ADOCommand object, I get the following error: Parameter object is improperly defined. Inconsistent or incomplete information was provided. I’ve been trying several alternatives but they aren’t working… Here is what I’m trying to do (connections string are commented): Thank you, function testDB(status, batch_seq) { try { var result, isBatchReady; var sp = ADO.CreateADOCommand(); //var extendedProperties = aqString.Quote("DSN=ABCDEFGH;UID=ABCDEFGH;PWD=ABCDEFGH;DBQ=ABCDEFGH;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BNF=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O;MLD=0;ODA=F;"); //sp.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;Extended Properties=" + extendedProperties; //sp.ConnectionString = "Driver={Oracle in OraClient11g_home1};Dbq=ABCDEFGH;Uid=ABCDEFGH;Pwd=ABCDEFGH;"; sp.CommandType = adCmdStoredProc; sp.CommandText = "PK_TEST_API.isBatchAtStatus"; sp.Parameters.CreateParameter("status", adVarChar, adParamInput, 3, status); sp.Parameters.CreateParameter("batch_seq", adInteger, adParamInput, 6, batch_seq); result = sp.Execute(); // Oracle doesn't handle properly BOOLEAN type... SP as a VARCHAR2 return // type which need to be converted to a boolean value isBatchReady = result == "TRUE" ? true:false; if(isBatchReady) { Log.Message("Batch #" + batch_seq + " at " + status); } else { Log.Error("Batch #" + batch_seq + " not at " + status); } } catch(ex) { Log.Error("Exception in testDB - " + ex.name, ex.description); } }20KViews0likes0CommentsRe: Functional Testing using a VM
Thanks for the info. I did installed it on my VM this morning and keyword registration seems fine. However, my application is closing by itself upon interacting with it. What is mean by that is that i can launch the application just fine and interact with it but when I try recording tests all I can automate is the launch of the tested app. Does it have something to do with TestComplete or am I in front of some sort of design flaw on my end ? To give everyone a background check of my situation, I recently got hired by a company that want to incorporate Automated testing... so I may be dealing with a lot of legacy systems. Thanks for the help!980Views0likes0CommentsFunctional Testing using a VM
Greetings, I'm currently looking into using Testcomplete 9 for automating functional tests. I'm running a VM with my database and application that need to be tested on it. If I record a test by clicking on the various controls outside de VM, I get the outputted test the way I want it (Action are binded to the control directly instead of record the position of the click on the screen). However, when I start interacting with my application via the VM, Testcomplete doesn't record any key stroke whatsoever and bind my action to a position on the screen instead of binding it directly to the control. Is there a way to have the same behavior inside the VM for recording my test that I get recording the test outside ? (See attached image)21KViews0likes3Comments