|
oh.... tested:
* ODP.NET version 2.111.6.20
* Oracle 11g
* .NET 3.5
try {
...
using (oScope = new TransactionScope(TransactionScopeOption.Required, TimeSpan.FromSeconds(60)))
{
...
DoFirstDatabaseOperation(...); << Application just exited!! No exception!
...
} catch(Exception ex)
{
}
I enabled ODP.NET tracing by adding to app.config:
<br />
<oracle.dataaccess.client><br />
<settings><br />
<add name="TraceFileName" value="c:\odpnet1.trc"/><br />
<add name="TraceLevel" value="63"/><br />
</settings><br />
</oracle.dataaccess.client><br />
It looks like we've a "System.AccessViolationException" while "Oracle.DataAccess.Client.ConnectionDispenser.CreateConnectionPool" is invoked. ODP.NET assigned to it the following error code:
"ODP error code=-3000; ODP message=Data provider internal error"
Help anyone? I been haunted by this last few days and looks like it will continue and ruin my Easter holiday.
Here's the trace:
<br />
TIME:2009/04/10-17:40:18:578 TID: 80c (REGISTRY) (CheckConStatus : 1)<br />
TIME:2009/04/10-17:40:18:578 TID: 80c (REGISTRY) (DynamicEnlistment : 0)<br />
TIME:2009/04/10-17:40:18:578 TID: 80c (REGISTRY) (FetchSize : 65536 bytes)<br />
TIME:2009/04/10-17:40:18:578 TID: 80c (REGISTRY) (PerformanceCounters : 0)<br />
TIME:2009/04/10-17:40:18:578 TID: 80c (REGISTRY) (PSPE : promotable)<br />
TIME:2009/04/10-17:40:18:578 TID: 80c (REGISTRY) (StatementCacheSize : 10)<br />
TIME:2009/04/10-17:40:18:578 TID: 80c (REGISTRY) (StatementCacheWithUdts : 1)<br />
TIME:2009/04/10-17:40:18:578 TID: 80c (CONFIG) (TraceFileName : c:\odpnet1.trc)<br />
TIME:2009/04/10-17:40:18:578 TID: 80c (CONFIG) (TraceLevel : 63)<br />
TIME:2009/04/10-17:40:18:578 TID: 80c (REGISTRY) (TraceOption : 0)<br />
TIME:2009/04/10-17:40:18:578 TID: 80c (REGISTRY) (UdtCacheSize : 4096 KB)<br />
TIME:2009/04/10-17:40:18:578 TID: 80c (CONFIG) (MetaDataXml : <none>)<br />
TIME:2009/04/10-17:40:18:578 TID: 80c (CONFIG) (DbNotificationPort : -1)<br />
TIME:2009/04/10-17:40:18:578 TID: 80c (REGISTRY) (ThreadPoolMaxSize : -1 [Original: 500; Set: -1; Post-Set: 500])<br />
TIME:2009/04/10-17:40:18:578 TID: 80c (REGISTRY) (DllPath : D:\OracleODPNET\bin)<br />
TIME:2009/04/10-17:40:18:578 TID: 80c (REGISTRY) (MetadataPooling : 1)<br />
TIME:2009/04/10-17:40:18:578 TID: 80c (ENTRY) OracleCommand::OracleCommand(1)<br />
TIME:2009/04/10-17:40:18:578 TID: 80c (EXIT) OracleCommand::OracleCommand(1)<br />
TIME:2009/04/10-17:40:18:578 TID: 80c (ENTRY) OracleCommand::CommandText(): set<br />
TIME:2009/04/10-17:40:18:578 TID: 80c (EXIT) OracleCommand::CommandText(): set<br />
TIME:2009/04/10-17:40:18:609 TID: 80c (ENTRY) OracleConnection::OracleConnection(1)<br />
TIME:2009/04/10-17:40:18:609 TID: 80c (EXIT) OracleConnection::OracleConnection(1)<br />
TIME:2009/04/10-17:40:18:625 TID: 80c (ENTRY) OracleConnection::Open()<br />
TIME:2009/04/10-17:40:18:625 TID: 80c (ENTRY) OpsConAllocValCtx()<br />
TIME:2009/04/10-17:40:18:625 TID: 80c (EXIT) OpsConAllocValCtx(): RetCode=0 Line=355<br />
TIME:2009/04/10-17:40:20:656 TID: 80c (ENTRY) OpsConOpen()<br />
TIME:2009/04/10-17:40:20:671 TID: 80c (ENTRY) OpsConEnlist(): (40d16c8)=0<br />
TIME:2009/04/10-17:40:20:671 TID: 80c (ENTRY) OpsTraceGetLastErrorCode()<br />
TIME:2009/04/10-17:40:20:671 TID: 80c (EXIT) OpsTraceGetLastErrorCode(): RetCode=0 Line=1389<br />
TIME:2009/04/10-17:40:20:671 TID: a44 (ENTRY) OpsTraceCreateMiniDump()<br />
TIME:2009/04/10-17:40:20:671 TID: a44 (EXIT) OpsTraceCreateMiniDump(): None created: TraceLevel=0 Line=1306<br />
TIME:2009/04/10-17:40:20:671 TID: 80c (EXCPT) Lvl0: (Type=System.AccessViolationException) (Msg=Attempted to read or write protected memory. This is often an indication that other memory is corrupt.) (Win32Err=203) (Code=c0000005) (Stack= at Oracle.DataAccess.Client.OpsCon.Open(IntPtr& opsConCtx, IntPtr& opsErrCtx, OpoConValCtx* pOpoConValCtx, OpoConRefCtx& pOpoConRefCtx)<br />
at Oracle.DataAccess.Client.ConnectionDispenser.CreateConnectionPool(OpoConCtx& opoConCtx))<br />
TIME:2009/04/10-17:40:20:765 TID: 80c (ERROR) ODP error code=-3000; ODP message=Data provider internal error<br />
TIME:2009/04/10-17:40:20:765 TID: 80c (ENTRY) OpsConRelRef(): (0)=1<br />
TIME:2009/04/10-17:40:20:765 TID: 80c (WARN) OpsConRelRef(): Null ptr: (0)=1<br />
TIME:2009/04/10-17:40:20:765 TID: 80c (EXIT) OpsConRelRef(): RetCode=1 Line=2590 (0)=0<br />
dev
modified on Friday, April 10, 2009 5:53 AM
|
|
|
|
|
I am unable to get HDD serial number in Windows Vista.
Please help me to do that with a sample program.
Pankaj Chakraborty
email: pchakraboty_99@yahoo.com
|
|
|
|
|
Have a look at the System.Management Namespace.
Excellence is doing ordinary things extraordinarily well.
|
|
|
|
|
|
hello sir this the first time I am messaging u.
my problem is tht, i want make a s/w tht automatically pick d data from excel sheet
and than automaticlly fill the web form given one by one n get saved.
plz help me how to do tht?
one more problem is tht, the given web form has 3-4 checks.
plz guide me its my first project.
|
|
|
|
|
kapilsahrawat wrote: plz guide me its my first project.
Then I would suggest that it is too complicated, for a first project.
It is a well established fact that all first projects, regardless of the technology/language being used, MUST be a 'Hello World!' app.
You might also consider that one of the CP fora that deals with Webby things, might get you a better answer than this one.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
hi friends
i want to retrive hard disk serial no.
i use this code
Dim strMotherBoardID As String = String.Empty
Dim query As New SelectQuery("Win32_BaseBoard")
Dim search As New ManagementObjectSearcher(query)
Dim info As ManagementObject
For Each info In search.Get()
strMotherBoardID = info("SerialNumber").ToString()
Next
Return strMotherBoardID
but this code does not work properly.
this error show
Object reference not set to an instance of an object.
|
|
|
|
|
|
hi
this code work on normal hard disk.
but on sata hard disk this code does not work.
|
|
|
|
|
Hi. This is a C# forumn. Try the VB forumn for VB help.
Excellence is doing ordinary things extraordinarily well.
|
|
|
|
|
dear
i have solution in C#
plz tell me
|
|
|
|
|
If you are using VS2008 and .net 3.5 you can use the System.Management namespace. Have a look at this link.
Search HDD Serial Number[^]
Excellence is doing ordinary things extraordinarily well.
|
|
|
|
|
Hi All,
I have an Object collection on which I would like to use Linq query based upon the some criteria.
Can anybody please give me any links or a small code snippet to complete this task.
Thanks,
Md. Abdul Aleem.
Thanks & Regards,
Md. Abdul Aleem
NIIT technologies
|
|
|
|
|
|
I suggest you post this in the linq forum - you will get a more positive response.
This site was useful to me as well msdn[^]
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi Guys,
I have created a text file 'sample.txt' using FileStreamWriter property of C#, where I have entered this following sample HTML code:
<title>Sample WebPage
This is a sample webpage created using Filestream
However, the following code is in Notepad and wont be converted into a WebPage untill I change the extension of the File from .txt to .html.
Therefore, my question is, how can I convert a .txt file to .html, programatically? I also want to rename the filename 'Sample.txt' to 'Mypage.html'. Is there any 'rename' function in C#? Please help me.
Your help will truly be appreciated,
Thanx for taking interest in my question,
Rajdeep.NET
|
|
|
|
|
U need to use a fileInfo class..
FileInfo fln = new FileInfo(fl); //Here the fl is the string containing the location of your text
file.
//Now you have two options either copy to another file using this function
string temp = fl.Split('.')[0]; //This will remove .txt from file address.
fln.CopyTo(temp + ".html"); //This will create a new file with .html extension.
fln.Delete(); //Deletes the .txt file.
// OR you can do is use replace function
fln.Replace(fl,temp + ".html");
//But i am not sure this 2nd one works ..
|
|
|
|
|
Hi Jay,
Thanx for posting the code. Everything is fine except the System namespace. I am using System.IO; as the system namespace, but an error is displayed saying, "System.IO.FileInfo does not contain a definition for 'Split' ". Please provide me the appropriate namespace.
Thanx
Rajdeep.NET
|
|
|
|
|
Use all this...
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.IO;
|
|
|
|
|
Hi Jay,
Can u please explain me why shall I use the Using System.Windows.Forms; in my console application?
However, it worked fine for me. But, take a look at this code:
System.IO.File.Move(@"C:/from.txt", @"C:/to.html");
This one is a short one but workd overwhelmingly fine. We have to use the Move function because, C# doesn't support 'rename' function like C.
Thanx for your help again,
Happy programming and wish u a successful programming career,
Rajdeep.NET
|
|
|
|
|
I thought you are asking for a windows application ??
|
|
|
|
|
Yep, that one line of code is all you need to what you want. I'd ignore some of the poor advice about including numerous irrelevant namespaces and manipulating strings and copying files....
Regards,
Rob Philpott.
|
|
|
|
|
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.IO;
namespace Extensionchanges
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
OpenFileDialog OpenFileDialog1 = new OpenFileDialog();
OpenFileDialog1.ShowDialog();
string fl = OpenFileDialog1.FileName;
FileInfo fln = new FileInfo(fl);
string temp = fl.Split('.')[0];
fln.CopyTo(temp + ".html");
}
|
|
|
|
|
The above windows application code show an error:
The type or namespace name 'Linq' does not exist in the namespace 'System' (are you missing an assembly reference?)
Why so?
|
|
|
|
|
Its of framework 3.5
remove it if you use 3.0 framework
|
|
|
|