Re: HELP
From: K Dales (anonymous_at_discussions.microsoft.com)
Date: 10/08/04
- Next message: Myrna Larson: "Re: Trying to identify what is not there"
- Previous message: RandyJ: "Please help with programming"
- In reply to: PO: "Re: HELP"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 8 Oct 2004 13:29:58 -0700
Not familiar with specs for Oracle Client, so can't say
for sure - but in general with ODBC you can access the
data with no additional client software (other than the
ODBC driver).
Licensing may also be an issue, though - better check.
>-----Original Message-----
>Hi
>
>I have knowledge of all the below. I already extract
information from the
>Oracle DB. My problem is that I have to install Oracle
Client on about 100
>client machines. Therefore my question is - can I do all
of the below not
>using Oracle Client (or only use ONE version on a
separate server)?
>
>Regards
>PO
>
>
><anonymous@discussions.microsoft.com> wrote in message
>news:096201c4ad51$805fe160$a501280a@phx.gbl...
>> Here's what you need to connect (and it sounds like you
>> have, or can have it all):
>>
>> 1) Network access to the server/drive where the Oracle
>> database resides.
>> 2) The ODBC driver installed and set up on each machine
>> (through the ODBC Administrator in Control Panel). This
>> requires knowledge of the port and TCP/IP settings.
>> 3) Knowledge of the database User ID and password that
you
>> need to access the data.
>> 4) Any other connection settings - in other words, you
>> need to know the ODBC connection string.
>> 5) Knowledge of SQL to query the database.
>> 6) Knowledge of ActiveX Data Objects (especially the
>> Connection and Recordset Objects) in order to use ODBC
>> within VBA. You can set up the connection and use an
SQL
>> string to retrieve your data into the recordset. Do a
>> search of the MSDN Library for "ADO" and you should
find a
>> good reference to the ADO object model and how to use
it.
>>
>> Those are the basics, but it sounds like you should be
>> able to do what you want as long as you have or can get
>> the required User ID, password, etc...
>>
>> K Dales
>>
>>
>> >-----Original Message-----
>> >Hi!
>> >I have the same problem as "sarasta" (posted 7/10). I
>> have a great number of
>> >client machines which need to connect to an Oracle 8
DB.
>> But the majority
>> >don't have Oracle Client installed. I have however
access
>> to one of our
>> >servers which has a server version of Oracle Client
>> installed.
>> >
>> >I have two questions:
>> >
>> >1. Is it possible, using Excel VBA, to connect to an
>> Oracle 8 DB without
>> >having Oracle Client installed on the PC? All clients
>> have "Microsoft ODBC
>> >for Oracle" installed.
>> >
>> >2. If not, is it possible for the clients to connect to
>> the Oracle DB using
>> >the server and it's Oracle Client installation?
>> >
>> >TIA
>> >PO
>> >
>> >
>> >.
>> >
>
>
>.
>
- Next message: Myrna Larson: "Re: Trying to identify what is not there"
- Previous message: RandyJ: "Please help with programming"
- In reply to: PO: "Re: HELP"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
