Hi,
I have to switch databases for some applications, before we had MSSQL, and now
it's oracle. I used DBI::ODBC for this, so I only changed the ODBC connection
to be an Oracle one, and it *should* work. However I get this error:
Tue Mar 24 14:08:35 2009 Datatransfer started *********************
!!!!!!!!!!!!!!!!!!!!!!!!!!Tue Mar 24 14:08:35 2009
[Oracle][ODBC][Ora]ORA-12154: TNS: Angegebener Connect Identifier konnte nicht
aufgelöst werden
(SQL-08004)(DBD: db_login/SQLConnect err=-1)
(it means it can't resolve TNS)
I have seen that error before, when making the ODBC connection in Windows and I
didn't use a "fqdn" Name for the database. But I have done that now, and I can
successfully test the ODBC connection from it's setup window.
Just using it from my script won't work...
the code itself is simple:
$msdbh = DBI->connect("dbi:ODBC:BTETRANSFER", "user", "pass", { RaiseError =>
0, PrintError => 1, AutoCommit => 1 } ) or do {print LOG
"!!!!!!!!!!!!!!!!!!!!!!!!!!$now $DBI::errstr\n" ; $seconds=300 ; next MAINLOOP};
any ideas where to check what?
Lars
_______________________________________________
ActivePerl mailing list
ActivePerl@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
