Re: Interfacing Oracle and Visual Basic

From: Charles Newman <newmanc6619_at_softhome.net>
Date: Tue, 28 Nov 2000 12:25:09 -0800
Message-ID: <3a24147d@post.newsfeeds.com>

• post for free via your newsreader at post.newsfeeds.com ***

    How do I set up the Oracle Data Control to use Oracle Listener? My problems can be solved by using ADODB for writes and Oracle Data control for reads. However, I need to be able to get the Oracle Data Control to talk to the Oracle Listender.

In the default "SCOTT" account, I am using

ORADC1.Connect ="scott / tiger"
ORADC1.RecordSource = "select * from item"
ORADC1.DatabaseName = "po8"

   "po8" is the service name (what you would type in, in the "Connect" field in
SQL Plus) in TNSNAMES. However, I can the error telling me the service name cannot be resolved.

This is what is defined in TNSNAMES now for my service name:

po8.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (PROTOCOL = TCP)

          (Host = 127.0.0.1)

          (Port = 1521)

        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )

When logging on, via SQL Plus, this is what would be used:

User Name: scott
Password: tiger
Connect: po8

   which works OK in SQL Plus, and I have no problem with ADO or ADODB, but I cannot get ORADC to use it correctly.

• Post for FREE via your newsreader at post.newsfeeds.com ****

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
*** Newsfeeds.com - The #1 Usenet Newsgroup Service on The Planet! ***
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
  http://www.newsfeeds.com%c2%a0%c2%a0%c2     |         http://www.newsfeeds.com
                                 |
* Anonymous posting server!      | * Totally Uncensored!
* SUPER Servers!                 | * Over 80,000 Newsgroups!
* BINARIES ONLY Servers!         | * 16 seperate Newsgroup Servers!
* SPAM FILTERED Server!          | * Instant access!
* ADULT ONLY Server!             | * Multiple OC 3's and OC 12's!
* MP3 ONLY Server!               | * 99% Article Completion!
* MULTIMEDIA ONLY Server!        | * Months of Retention!
* 7 UNCENSORED Newsgroup Servers | * Lightning FAST downloads!
                                 |
  http://www.newsfeeds.com       |         http://www.newsfeeds.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
        **** Point your newsreader to post.newsfeeds.com ****

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Received on Tue Nov 28 2000 - 14:25:09 CST