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.  
  • mikakoistinen's avatar
    mikakoistinen
    5 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

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
5 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)