On Thu, Mar 10, 2011 at 4:32 PM, Octavian Rasnita <[email protected]>wrote:
> *From:* Rohan M <[email protected]> > > Dear All, > > I'm trying to use Oracle database as a back-end database for Catalyst > application. (I tried MySQL and its working properly for me ). > > At first, I tried the following command - > > perl script/testapp_create.pl model DB DBIC::Schema DB::Schema * > create=static* 'dbi:Oracle:sid=TEST1;host=192.168.100.107; port=1521' > 'user' 'pass' > Have you tried with sid=test.abcd.com? > > Yes. I tried this also. > > perl script/testapp_create.pl model DB DBIC::Schema DB::Schema > create=static dbi:Oracle:sid=test.abcd.com;host=192.168.100.107;port=1521 > user pass > > Octavian > > > > _______________________________________________ > List: [email protected] > Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst > Searchable archive: > http://www.mail-archive.com/[email protected]/ > Dev site: http://dev.catalyst.perl.org/ > > The complete error is "DBI Connection failed: DBI connect('sid=test.abcd.com;host=192.168.100.107;port=1521','user',...) ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach) at /usr/local/share/perl/5.10.1/DBIx/Class/Storage/DBI.pm line 1262 " -- Rohan M
_______________________________________________ List: [email protected] Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/[email protected]/ Dev site: http://dev.catalyst.perl.org/
