Before your perl script can run on Linux and connect to the database on Windows, you need to have the Oracle client software successfully installed on the Linux box - and verify that it works by using the sql*plus utility, which means you need a tnsnames.ora file on the Linux box.
The perl/dbi connectivity is also verified when you install DBD::Oracle on linux and you run 'make test'. -Joe --- Angelo Marcos Rigo <[EMAIL PROTECTED]> wrote: > So i am thinking that my linux will display the perl script > and that will be located by the windows/oracle tnsnames.ora > that´s it? > > The tnsnames.ora is stored on the windows/oracle? if he does not > exists > how can i create it? > > thank´s in advance > > Ângelo Marcos Rigo > Webmaster Colégio Anchieta > http://www.colegioanchieta.g12.br > > > -----Original Message----- > From: Joe Raube [mailto:[EMAIL PROTECTED]] > Sent: quarta-feira, 11 de setembro de 2002 9:25 > To: [EMAIL PROTECTED] > Subject: RE: perl and Oracle > > > > there is no need to point the hostname or ip adress of the > > windows/oracle machine? > > > my $dbh = DBI->connect( > > 'dbi:Oracle:testdb','USERNAME','PASSWORD',) > > || die "Database connection not made: $DBI::errstr"; > > The connect does this via the tnsnames.ora file, which has an alias > called testdb, which points to the appropriate database on the > appropriate host. > > -Joe > > > __________________________________________________ > Yahoo! - We Remember > 9-11: A tribute to the more than 3,000 lives lost > http://dir.remember.yahoo.com/tribute > > -- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > __________________________________________________ Yahoo! - We Remember 9-11: A tribute to the more than 3,000 lives lost http://dir.remember.yahoo.com/tribute -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
