Forum Discussion

vinodjaju's avatar
vinodjaju
Occasional Contributor
6 years ago

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.  
  • mikakoistinen's avatar
    mikakoistinen
    6 years ago

    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

     

mikakoistinen's avatar
mikakoistinen
Contributor
6 years ago

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
    6 years ago

    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)