Re: [GENERAL] Trying to connect to an Oracle instance...

2006-07-13 Thread Joe Conway
A.M. wrote: On Thu, July 13, 2006 11:03 am, Tony Caduto wrote: Spendius wrote: I've been trying to perform a connection to an Oracle DB for a while, to no avail. Here is what I get at my psql prompt: postdb=# Select dblink_connect('login','hostaddr= port=1521 \ If you are trying to connect t

Re: [GENERAL] Trying to connect to an Oracle instance...

2006-07-13 Thread A.M.
On Thu, July 13, 2006 11:03 am, Tony Caduto wrote: > Spendius wrote: > >> Hi, >> I've been trying to perform a connection to an Oracle DB for a while, >> to no avail. Here is what I get at my psql prompt: postdb=# Select >> dblink_connect('login','hostaddr= port=1521 \ >> > If you are trying to con

Re: [GENERAL] Trying to connect to an Oracle instance...

2006-07-13 Thread Michael Fuhr
On Thu, Jul 13, 2006 at 05:46:55AM -0700, Spendius wrote: > I've been trying to perform a connection to an Oracle DB for a while, > to no avail. Here is what I get at my psql prompt: > postdb=# Select dblink_connect('login','hostaddr= port=1521 \ > dbname=orasid user=mylogin password=mypwd'); > ERR

Re: [GENERAL] Trying to connect to an Oracle instance...

2006-07-13 Thread Tony Caduto
Spendius wrote: Hi, I've been trying to perform a connection to an Oracle DB for a while, to no avail. Here is what I get at my psql prompt: postdb=# Select dblink_connect('login','hostaddr= port=1521 \ If you are trying to connect to a Oracle DB, don't you need to be using DBI Link instead o

[GENERAL] Trying to connect to an Oracle instance...

2006-07-13 Thread Spendius
Hi, I've been trying to perform a connection to an Oracle DB for a while, to no avail. Here is what I get at my psql prompt: postdb=# Select dblink_connect('login','hostaddr= port=1521 \ dbname=orasid user=mylogin password=mypwd'); ERROR: could not establish connection DETAIL: server closed the c