I am using QTP against Oracle Apps. I have successfully used QTP against one of my Oracle App instances. However I am unable to get a 'connection' between QTP and Oracle in my pre-prod instance. When I do an Object Spy against a form in this instance QTP only see JavaObjects - not Oracle Objects. I have set the ICX:Form Laucher system profile option correctly but still get this error. Any ideas?
I am trying to connect to Oracle in QTP but its not workingI hv written a code as - Set conn = CreateObject("ADODB.Connection")Set rs = CreateObject("ADODB.Recordset")SQL_Statement = "SELECT COUNT(*) FROM ACCOUNTconn.Open "Provider=OraOLEDB.Oracle;Driver={Microsoft ODBC Driver for Oracle};ConnectString=Test.WORLD;Uid=bds_read;Pwd=bds_read;"Its giving me error as - DSN not found or provider not foundBut I have created SYSTEM dsn as Test.WorldCould anybody suggest
Hi,I am new to QTP. I am trying to connect to the database through Database checkpoints and unable to connect to the database. Here we are using IBM DB2. It is giving error "Format of the initialization string does not conform to the OLE DB specification."And the created Connection string is "DRIVER={IBM DB2 ODBC DRIVER};DSN=dsnname;UID=uid;PWD=pid;MODE=SHARE;DBALIAS=dbname;"Can you please resolve my problem.Thanks in advance..
I have made a connection to Access database from QTP using ADODB connection,,,, and also declared a recordset for it....There are 2 rows in the database and i want to fetch the values from all the rows...But the problem is that when the first record is fetched , QTP runs the whole script and again starts for the first line of the QTP code for the second iteration....and in this process it again opens the same connection and fetches the same first row again..... Can anyone tell me how to fetch the
Hi,in my project we are suppossed to start automation. But, we are using backend as DB2 in mmainframes. How will I create the connection string with the back end accessing the database.
Latest Answer : Question back to you: Why is there a need to write/parameterize the database connections? Vugen is a record and playback technology. You don't really need to code the entire script unless there are some constraints and limitations. My suggestion ...
I created my database in SQL Server 2005 and used the following script to connect to my database from QTP. But it didn't workim ObjDBSet ObjDB= Create Object("ADODB Connection")ObjDB.ConnectionString
Latest Answer : Instead of creating an MS Access DSN , create a Sql Server DSN using a SQL Server ODBC driver for connectivity.Hope this helps.THe syntax in the answer to the above question is accurate.Thanks,Aditya. ...
How can you create a test data in oracle and how to fetch the data from it? Explain it with an example.
Latest Answer : we can connect to oracle database through connection string....code for connecting to dbset con=createobject("ADODB.Connection")set rs=createobject("ADODB.Recordset");con.ConnectionString="DRIVER={oracle in orahome92};SERVER=(servername);UID=(username);PWD=(password);DBQ=dbserver"con.openquery="select ...
I am unable to set up an OLEDB connection to from QTP to DB2.Can you please help me out how to set up this connnection .What are the proviers for the same .Please help me out with the porper connection
I have tried this way to export data from a database table to store in an excel sheet, but it is only storing the last record of the received records. Can anyone help me.Set objDB = CreateObject("ADODB.Connection")objDB.ConnectionString
Latest Answer : Set objDB = CreateObject("ADODB.Connection")objDB.ConnectionString = "DSN=mysql_qtp"objDB.OpenIf objDB.state=1 Thenmsgbox("Connection Is Establsihed")elsemsgbox("Connection is not opened")exittestEnd Ifsql_query ...
