Re: Interfacing Oracle and Visual Basic
Date: Tue, 28 Nov 2000 12:25:09 -0800
Message-ID: <3a24147d_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   | 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 - 21:25:09 CET