Forum Discussion

vinodjaju's avatar
vinodjaju
Occasional Contributor
5 years ago
Solved

connection to Database showing error

unable to connect to DB showing [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, not able to fix .

 

Kindly help to update. Thanks.

 

  • Hi,

    Has it been working before? What changed?

    Where does this error occur? 

    32 or 64 bit?

    Some odbc drivers are only for 32 bit apps

     

2 Replies

  • Hi,

    Has it been working before? What changed?

    Where does this error occur? 

    32 or 64 bit?

    Some odbc drivers are only for 32 bit apps

     

    • vinodjaju's avatar
      vinodjaju
      Occasional Contributor

      actually my machine is 64bit, and i have toad installed on it, now i want to connect to db using testcomplete

       

      currently i am using below code to connect

       

      Sqlstring1 = Query
      Set Cnn = CreateObject("ADODB.Connection")
      Cnn.ConnectionString ="Driver={Microsoft ODBC for Oracle};Server=BSCST6.WORLD; Uid=;Pwd=;"
      Cnn.open
      Set Rs = CreateObject("ADODB.Recordset")
      Rs.open Sqlstring1,Cnn
      msgbox Rs(1)