Unable to execute a query
Hi, I have the below code in my scripts which is establish a connection with db and execute a query. var Qry Qry = ADO.CreateADOQuery() Qry.ConnectionString = "Provider=MSDAO...
Forum Discussion
Hope the below will help you..
var LC_ConnectionString = "Provider=OraOLEDB.Oracle.1;" + "Data Source=DFLY-FT.MDMR01;User ID=ami_admin;Password=ami_admin";
var lQuery = ADO.CreateADOQuery(); // Creates a query
lQuery.ConnectionString = LC_ConnectionString;
lQuery.SQL = pSQLQuery;
lQuery.Open();
return lQuery
var LC_ConnectionString = "Provider=OraOLEDB.Oracle.1;" + "Data Source=DFLY-FT.MDMR01;User ID=ami_admin;Password=ami_admin";
var lQuery = ADO.CreateADOQuery(); // Creates a query
lQuery.ConnectionString = LC_ConnectionString;
lQuery.SQL = pSQLQuery;
lQuery.Open();
return lQuery