Re: Newbie questions

On 8 Apr, 10:08, "Paul" <notha..._at_btopenworld.com> wrote:
> I am completely new to Oracle after 10 years of using MS SQl, and I am
> struggling with the basics.
>
> I need to collect data from an Oracle database, and I have had access to the
> oracle database set up
> I have the following information, with obvious bits changed.
>
> XXXXXXM =
>   (DESCRIPTION =
>
>     (ADDRESS_LIST =
>
>       (ADDRESS = (PROTOCOL = TCP)(HOST = xxxx.xx.xx.147)(PORT = 1521))
>
>     )
>
>     (CONNECT_DATA =
>
>       (SERVICE_NAME = xxxxR1)
>
>       (SRVR = DEDICATED)
>
>     )
>
>   )
>
> I also have the user id and pw
>
> I have installed oracle client 9i, but the SQL+ asks for a host string??
>
> I have also tried to configure a connection using the "Network Configuration
> Assistant" by adding a Oracle Names Servers. But having added this it
> doesn't seem to work, and I cant edit or delete it.
>
> Any help would be appreciated.

[Quoted] What operating system? Received on Tue Apr 08 2008 - 13:27:59 CEST