Category Archives: Oracle

Message=ORA-01843: not a valid month

This short blog is to resolve .NET C# insert a record to Oracle table with date format You will very likely get the error Message=ORA-01843: not a valid month when you insert a record to Oracle table with date format … Continue reading

Posted in .Net, Community, Oracle | Tagged , , | Leave a comment

Oracle Developer Tools for Visual Studio 2017

This short writing is showing you where to get Oracle Developer Tools for Visual Studio 2017. It is test installing successfully. You can see the Tools available after the installation. You will find Oracle.ManageDataAccess which is IIS friendly as compare … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Oracle, Servers | Tagged , , , | Leave a comment

Oracle Provider for OLE DB User Name and Password grey out SSIS

This short blog let you know one of the possible reasons why the User Name and Password grey out in SSIS package. This is because the Oracle Developer Tools for Visual Studio or ODAC. You can download it here  http://www.oracle.com/technetwork/database/windows/downloads/index-101290.html.

Posted in Community, Computers and Internet, Oracle | Tagged , , | Leave a comment

Oracle Enterprise Manager Database Control URL not accessible

This short blog showing you how to access to Oracle Enterprise Manager Database Control URL when you install an Oracle 11g database server in your Windows 10 PC. After you completed the installation of Oracle 11g, you got a link … Continue reading

Posted in .Net, Community, Oracle | Tagged | Leave a comment

ORA-03134: Connections to this server version are no longer supported

By reading this blog you may save sometimes for download the unnecessary Oracle drivers for Visual Studio. If you still have Oracle 9i and you want to download 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual … Continue reading

Posted in .Net, Community, Computers and Internet, Oracle | Tagged , , , | Leave a comment

Oracle sql developer not displaying time

When you send in a sql statement in Oracle SQL Developer you might only see the date but not the time in the datetime field. Go to Tools -> Preferences -> Database – NLS then put in the Date format … Continue reading

Posted in Community, Computers and Internet, Oracle | Tagged , | Leave a comment