Ask a Question

connection to Database showing error

SOLVED
vinodjaju
Occasional Contributor

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
mikakoistinen
Contributor

Re: connection to Database showing error

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

 

Jeemly - Dream Big
https://jeemly.com/

View solution in original post

2 REPLIES 2
mikakoistinen
Contributor

Re: connection to Database showing error

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

 

Jeemly - Dream Big
https://jeemly.com/

View solution in original post

vinodjaju
Occasional Contributor

Re: connection to Database showing error

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)

cancel
Showing results for 
Search instead for 
Did you mean: