Re: Interfacing Oracle and Visual Basic

From: Charles Newman <newmanc_at_hotmail.com>
Date: Tue, 28 Nov 2000 20:32:43 GMT
Message-ID: <9014pb$cen$1@nnrp1.deja.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 dual"
ORADC1.DatabaseName = "po8"
ORADC1.Reresh

   "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.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 28 2000 - 14:32:43 CST