Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 18th 05, 08:38 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: May 2005
Posts: 7
Default Connect to Oracle using Microsoft ODBC for Oracle

I am developing an Excel workbook to be sent to many users on our company
network. I want to query our version 8.1.7 Oracle database.
Here is the beginning of the code I am using to make the connection:


Sub Get_Data()

Dim RecordSet As ADODB.RecordSet
Dim ConnectID As New ADODB.Connection
Dim User_ID As String
Dim Database As String
Dim Password As String
Dim Connection_Info As String
Dim i As Integer

On Error GoTo error_handler
Err.Clear

User_ID = DatabaseLogonForm.UserIDTextBox.Value
Password = DatabaseLogonForm.PasswordTextBox.Value

Connection_Info = "Driver={Microsoft ODBC for Oracle}; " & _
"CONNECTSTRING=(DESCRIPTION=" & _
"(ADDRESS=(PROTOCOL=TCP)" & _
"(HOST=server1.ccf.sw.org)(PORT=1521))" & _
"(CONNECT_DATA=(SERVICE_NAME=test))); uid =" & _
User_ID & ";pwd=" & Password & ";"

ConnectID.Open (Connection_Info)


When i run the code I get the following error:

"The Oracle(tm) client and networking components were not found. These
components are supplied by Oracle Corporation and are part of the Oracle
version 7.3 (or greater) client software installation. You will be unable
to use this driver until these components have been installed."

I don't want to have to visit each desktop to load drivers. I assuemd the
Mocrosoft Oracle driver would work. Any suggestions?

Thank you in advance.



  #2   Report Post  
Old November 19th 05, 07:37 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 1,588
Default Connect to Oracle using Microsoft ODBC for Oracle

Your client machines will need the Oracle client/nw files installed.
No way around it I'm afraid.

Tim.




"Kent" wrote in message
...
I am developing an Excel workbook to be sent to many users on our
company network. I want to query our version 8.1.7 Oracle database.
Here is the beginning of the code I am using to make the connection:


Sub Get_Data()

Dim RecordSet As ADODB.RecordSet
Dim ConnectID As New ADODB.Connection
Dim User_ID As String
Dim Database As String
Dim Password As String
Dim Connection_Info As String
Dim i As Integer

On Error GoTo error_handler
Err.Clear

User_ID = DatabaseLogonForm.UserIDTextBox.Value
Password = DatabaseLogonForm.PasswordTextBox.Value

Connection_Info = "Driver={Microsoft ODBC for Oracle}; " & _
"CONNECTSTRING=(DESCRIPTION=" & _
"(ADDRESS=(PROTOCOL=TCP)" & _
"(HOST=server1.ccf.sw.org)(PORT=1521))" & _
"(CONNECT_DATA=(SERVICE_NAME=test))); uid =" &
_
User_ID & ";pwd=" & Password & ";"

ConnectID.Open (Connection_Info)


When i run the code I get the following error:

"The Oracle(tm) client and networking components were not found.
These components are supplied by Oracle Corporation and are part of
the Oracle version 7.3 (or greater) client software installation.
You will be unable to use this driver until these components have
been installed."

I don't want to have to visit each desktop to load drivers. I
assuemd the Mocrosoft Oracle driver would work. Any suggestions?

Thank you in advance.



  #3   Report Post  
Old January 18th 06, 03:53 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2006
Posts: 1
Default Connect to Oracle using Microsoft ODBC for Oracle

Hi Kent,
Tim is correct, the Oracle client software is required. Some folks install
the client on many machines. I usually store the workbook on the network, and
then have someone refresh and distribute the report as required.
--
Todd Magnuson


"Tim Williams" wrote:

Your client machines will need the Oracle client/nw files installed.
No way around it I'm afraid.

Tim.




"Kent" wrote in message
...
I am developing an Excel workbook to be sent to many users on our
company network. I want to query our version 8.1.7 Oracle database.
Here is the beginning of the code I am using to make the connection:


Sub Get_Data()

Dim RecordSet As ADODB.RecordSet
Dim ConnectID As New ADODB.Connection
Dim User_ID As String
Dim Database As String
Dim Password As String
Dim Connection_Info As String
Dim i As Integer

On Error GoTo error_handler
Err.Clear

User_ID = DatabaseLogonForm.UserIDTextBox.Value
Password = DatabaseLogonForm.PasswordTextBox.Value

Connection_Info = "Driver={Microsoft ODBC for Oracle}; " & _
"CONNECTSTRING=(DESCRIPTION=" & _
"(ADDRESS=(PROTOCOL=TCP)" & _
"(HOST=server1.ccf.sw.org)(PORT=1521))" & _
"(CONNECT_DATA=(SERVICE_NAME=test))); uid =" &
_
User_ID & ";pwd=" & Password & ";"

ConnectID.Open (Connection_Info)


When i run the code I get the following error:

"The Oracle(tm) client and networking components were not found.
These components are supplied by Oracle Corporation and are part of
the Oracle version 7.3 (or greater) client software installation.
You will be unable to use this driver until these components have
been installed."

I don't want to have to visit each desktop to load drivers. I
assuemd the Mocrosoft Oracle driver would work. Any suggestions?

Thank you in advance.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Oracle odbc Slinjger Excel Discussion (Misc queries) 1 July 3rd 05 04:35 PM
don't find my message : connect to oracle db (4.2. 19:39) b geber Excel Programming 1 February 11th 05 11:24 AM
connect to an oracle db b geber Excel Programming 1 February 4th 05 07:27 PM
Connect to Oracle Database through ODBC with VBA jamiee Excel Programming 1 April 15th 04 03:31 PM
connect to an oracle server Bill Li Excel Programming 0 August 14th 03 04:31 AM


All times are GMT +1. The time now is 01:19 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017