Forum Discussion

skumar_1's avatar
skumar_1
New Contributor
13 years ago

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=MSDAORA.1;User ID=<username>;Password=<password>;Data Source=<dsn name>;Persist Security Info=False"

  Qry.SQL = "Select * FROM <table name> WHERE <column name> = 2"

  Qry.Open()



I am getting an JScript runtime error "Data type is not supported". Could any of you help to overcome this error?
  • pradeep_kamatha's avatar
    pradeep_kamatha
    Contributor
    13 years ago
    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

  • skumar_1's avatar
    skumar_1
    New Contributor
    13 years ago
    I changed my connection string to "Provider=OraOLEDB.Oracle;User ID=<username>;Password=<password>;Data Source=<dsn name>;Persist Security Info=False" and it works fine.



    Thanks.