-
Creating Procedures in Oracle
Hi
I would like to connect to Oracle Server which is located remotely and want to create the procedures and Run them.
I have the following piece of code
[VBA]Set cnn = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.RecordSet")
connect_string = "DRIVER={ORACLE ODBC DRIVER};Password=xxxx;UID=xxxxxx;Data Source=ral;"
cnn.ConnectionString = connect_string
cnn.ConnectionTimeout = 30
cnn.Open
[/VBA]
but it throws me 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."
Any help would be greatly appreciated.
Regards
Krrishna
Last edited by gopi09_m; 05-29-2009 at 02:41 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules