Consulting

Results 1 to 1 of 1

Thread: Creating Procedures in Oracle

  1. #1
    VBAX Regular
    Joined
    Apr 2008
    Posts
    51
    Location

    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
  •