ODBC DB connect fails after switching to Oracle

2009-03-24 Thread Oeschey, Lars (I/ET-83, extern)
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

Re: ODBC DB connect fails after switching to Oracle

2009-03-24 Thread Jenda Krynicky
From: Oeschey, Lars (I/ET-83, extern) extern.lars.oesc...@audi.de 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:

RE: ODBC DB connect fails after switching to Oracle

2009-03-24 Thread Oeschey, Lars (I/ET-83, extern)
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. yeah, found it... it's running as a service, and therefor under the system account. We have our oracle