Re: Recommended way to connect Oracle Databases

2007-01-05 Thread Michael van der Westhuizen
Hi, On 1/5/07, vizcayno <[EMAIL PROTECTED]> wrote: [snip discussion of "lite" connection strings vs. TNS] To properly specify a database connection you'd also need provision for a port number (the listener port). While that seems like a reasonable idea, TNS is a better mechanism as it abstra

Recommended way to connect Oracle Databases

2007-01-05 Thread vizcayno
Hello: Assuming I have an Oracle database with next connection info: user = scott pass = tiger host = Oracle host Name or IP address ORCL = Name of database with no tnsnames.ora file 1) From command line I can do: sqlplus scott/[EMAIL PROTECTED]/ORCL 2) From a Python script: import