150 reputation
19
bio website establishedtech.net
location Virginia
age
visits member for 2 years, 10 months
seen Jul 10 '12 at 3:38

C# Programmer and architect for modern .NET 4.0 solutions. Business owner of web design and IT support company.


Nov
21
comment 32-bit versus 64-bit ODP.NET to Oracle connection
Thanks for the contribution, sorry I didn't get back to you earlier, had a baby and a bit of a hiatus from this project. However, changing the path hasn't resolved the issue. Thanks for the info though and welcome to stack exchange!
Oct
13
comment Oracle Enterprise Manager (OEM) locking SYSMAN account
Actually, it only removes the SYSMAN password from the enterprise manager console, until you restart it with the last line, emctl start oms, that line prompts you to re-enter the new password, and resets the SYSMAN password in enterprise managers stored credentials. I'll go ahead and edit my answer and accept it as the answer with credit to Benoit tomorrow. Stack Exchange won't let me do it today, says I need to wait until tomorrow.
Oct
13
comment 32-bit versus 64-bit ODP.NET to Oracle connection
I have a 32-bit Windows 7 ODP.NET instance, which connects to our 32-bit Oracle instance, no problem. I have a 32-bit XP ODP.NET instance connects to the 32-bit Oracle instance, no problem. I have a 64-bit Windows 7 ODP.NET instance, that connects to the 32-bit Oracle instance, no problem. However, I have a 32-bit ODP.NET instance, in both Windows 7, and Windows XP, that cannot connect to my 64-bit Oracle instance. I have a 64-bit Windows 7 ODP.NET instance that connects to the 64-bit Oracle instance, no problem. If I use the full client (not Instant Client) instead of ODP.NET, I can connect.
Oct
13
comment 32-bit versus 64-bit ODP.NET to Oracle connection
No, this is a .NET assembly that's being built. The .NET assembly looks for the ODP.NET 64-bit dll, regardless if you you're running 32-bit, or 64-bit. This obviously causes us problems on 32-bit systems. The problem goes away if I use the full oracle client, or if we deploy to a 64-bit machine. Theoretically...it doesn't make any sense.
Oct
13
comment 32-bit versus 64-bit ODP.NET to Oracle connection
To the client it doesn't. To the actual dlls it seems to.