Re: Oracle and VB - How Do I....

From: Dave (Nobody_at_Nowhere.Com)
Date: 01/21/05 

Date: Fri, 21 Jan 2005 14:48:50 -0000

Ralph

Thanks for the quick reply, I've had a look around with Google, lots of
listings but NONE of them said what needs to be referenced so I've been
mucking about with trial and error.

What I have read confirms your suggestion re ADO so once I've worked out
what to reference I'll give that a bash, can ADO and DAO co-exist or will I
need to re-do all the DAO stuff I already have for Access & Excel?

The connections site you linked to looks very helpful

Thanks again
Dave.

"Ralph" <msnews.20.nt_consulting32@spamgourmet.com> wrote in message
news:uNYKwA8$EHA.3256@TK2MSFTNGP11.phx.gbl...
>
> "Dave" <Nobody@Nowhere.Com> wrote in message
> news:uK$bEK7$EHA.3120@TK2MSFTNGP12.phx.gbl...
>> Hello all
>>
>> Im putting something together which marries information from Access 2k,
>> Excel 2k and Oracle 8.1 sources. Using DAO 3.6 I can do all the Excel &
>> Access stuff but I don't have a clue how to connect to the Oracle
> database -
>> I assume I'll be able to query it in a similar manner to Access once I'm
> in.
>> I can make a test connection to it with the Oracle OBDC Test tool so I
> know
>> the connection is possible.
>> Does anyone know of a primer or idiot guide on connecting to Oracle with
>> VB6, also what references are required?
>>
>> TIA
>> Dave.
>>
>
> Communicating with an Oracle database is not essentially different than
> communicating to any other database.
> Check out http://www.connectionstrings.com/ for some examples.
>
> You will, however, run into subtle (,and not so subtle,) differences in
> SQL
> language, datatypes, parameter passing, and database specifics all of
> which
> lie somewhat above the various Data Libraries (DAO, ADO, OO4O).
>
> The best book is "Visual Basic Oracle 8", Dov Trietsch, Wrox Books.
>
> While you can connect to Oracle using DAO and an ODBC driver, in the past
> I
> found it to be rather slow and void of a few features. [Ignore OO4O.
> <g> ]You may want to consider using ADO and the Oracle OLEDB provider.
>
> Getting the right mix of Data Access Library and Driver/Provider was in
> the
> past the hardest part. But most of those problems have been solved with
> the
> newer Libs and Providers, however, you may still need to fish around a bit
> for the best mix for your domain.
>
> hth
> -ralph
>
>

Relevant Pages

  • Re: database project
    ... data connection was created and i entered credentials. ... i am prompted for credentials. ... Another DB reference is (Database References) in DataBase Project. ...
    (microsoft.public.vsnet.ide)
  • RE: ADO.Net Connection Pooling Problem with Oracle
    ... the CLR is releasing the connection to your database. ... the number of database sessions in Oracle seem to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connecting to an Oracle Database
    ... You can also use FrontPage, ... Click Add to Catalog under "Database Connections" ... Put in your Oracle connection string in the custom connections dialog ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Query Oracle, show results (need help!!)
    ... After the DB connection, put this... ... I am trying to log into an Oracle database, ... Prepare the SQL statement for running and it'll be stored in Oracle buffer ...
    (perl.beginners)
  • Re: database project
    ... There are two different DB reference in VS 2005 IDE. ... each connection is encrypted and stored on local for each ... The .dbp file is the Database Project file. ...
    (microsoft.public.vsnet.ide)