Connect Excel to SQL developer without client installed

[Dhiya]

Hi All,

I have successfully connected excel to SQL developer using the below VBA code. I have oracle client and oracle dc drive in my machine.


Dim con As ADODB.connection
Dim rs As ADODB.Recordset
Dim Cmd As New ADODB.Command
Dim query As String
Dim strsql As String
Dim a As Integer
'Dim db As Dao.Database
Set con = New ADODB.connection
Set rs = New ADODB.Recordset
Application.ScreenUpdating = True
Cmd.CommandType = adCmdText
'--- Replace below highlighted names with the corresponding values
strCon = "Driver={Microsoft ODBC for Oracle}; " & _
"CONNECTSTRING=(DESCRIPTION=" & _
"(ADDRESS=(PROTOCOL=TCP)" & _
"(HOST=hostname)(PORT=portnum))" & _
"(CONNECT_DATA=(SERVICE_NAME=ser_name))); uid=username; pwd=password;"
'--- Open the above connection string.
con.Open (strCon)
***sql query*****
rs.Open strsql, con
Sheets(1).Range("A2").CopyFromRecordset rs

Now all I wanted to do is to connect DB without having client installed in my machine. Can any one pls guide me

 

[Kyle123]

Does that not work?

 

[Dhiya]

That works well. But only with oracle client. When I run it in a machine where oracle client is not installed, I am getting error. I want it to run on the machines where client is not installed.

 

[Kyle123]

You'll need to install an oracle driver on each machine. Most windows computers will not come with a driver for connecting to an oracle database.

 

[Dhiya]

Yeah I've installed odbc driver for oracle and tried but still no luck

 

[Kyle123]

which driver?

 

[Dhiya]

Oracle ODBC drivers version 8.1.7.4

am connecting to oracle sql developer. kindly let me know if that needs any other driver