From: "Oeschey, Lars (I/ET-83, extern)" <[email protected]> > 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...
Is the script running under the same account under which you tested the ODBC connection? It might be a permissions issue or the DSN was by accident created as a "User DSN", not "System DSN". Jenda ===== [email protected] === http://Jenda.Krynicky.cz ===== When it comes to wine, women and song, wizards are allowed to get drunk and croon as much as they like. -- Terry Pratchett in Sourcery _______________________________________________ ActivePerl mailing list [email protected] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
