oradirect 3.2 on x64

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
tom

oradirect 3.2 on x64

Post by tom » Sun 19 Mar 2006 05:54

hi

can I use oradirect 3.2 with vs2005 (vc++8.0) on windows xp x64 ?

it tell me licence error.

thank u

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Mon 17 Apr 2006 08:25

Please try OraDirect .NET 3.50. We fixed this problem there.

tom_jht
Posts: 16
Joined: Sat 18 Mar 2006 06:24

vs2005,oracle10g,connection error

Post by tom_jht » Tue 25 Apr 2006 01:32

hi,
I install 3.5,
I try to connect with oracle 10g on windows xp 64 with vs2005 on one machine, souce code like this:
CoreLab::Oracle::OracleConnection ^oracleConnection1=gcnew CoreLab::Oracle::OracleConnection ();
oracleConnection1->ConnectionString ="User ID=scott; Password=tiger; Data Source=testdb";
oracleConnection1->Open ();

it tell me:
arithmetic operation ...overflow

why?

thank u

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Tue 25 Apr 2006 07:47

What version of Oracle client do you use? Try to connect to Oracle server with "Direct=true" in ConnectionString. Try to reproduce this problem with OraDirect .NET sample projects.

tom_jht
Posts: 16
Joined: Sat 18 Mar 2006 06:24

Post by tom_jht » Wed 26 Apr 2006 02:06

I use 10.2.0.1

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Wed 26 Apr 2006 08:49

Try to connect to Oracle server with "Direct=true" in ConnectionString. Try to reproduce this problem with OraDirect .NET sample projects.
Notify us on the results.

tom_jht
Posts: 16
Joined: Sat 18 Mar 2006 06:24

Post by tom_jht » Thu 27 Apr 2006 02:35

hi,

Direct Mode can do well.

but i want to use "loader",it have to use undirect mode ,how to to ?

I use oracle 10g (10.2.0.1) client ,windows xp 64,vs2005 vc++8 on my machine, souce code like this:
CoreLab::Oracle::OracleConnection ^oracleConnection1=gcnew CoreLab::Oracle::OracleConnection ();
oracleConnection1->ConnectionString ="User ID=scott; Password=tiger; Data Source=testdb";
oracleConnection1->Open ();

when i do ,it tell me:

An unhandled exception of type 'System.OverflowException' occurred in mscorlib.dll
Additional information: Arithmetic operation resulted in an overflow.

thank u

tom_jht
Posts: 16
Joined: Sat 18 Mar 2006 06:24

x64

Post by tom_jht » Tue 09 May 2006 02:35

I use oracle 10g (10.2.0.1) client ,windows xp 64,vs2005 vc++8 on my machine.

can i use oradirect.net in undirect mode?

how to do?

thank u

tom

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Wed 10 May 2006 07:08

We can not reproduce the problem on oracle 10g (10.2.0.1) client ,windows xp 64,vs2005 vc++8. Please send us call stack for this exception

tom_jht
Posts: 16
Joined: Sat 18 Mar 2006 06:24

exeception

Post by tom_jht » Thu 11 May 2006 01:47

hi,

private: System::Void button1_Click(System::Object^ sender, System::EventArgs^ e)
{
this->oracleConnection1 = (gcnew CoreLab::Oracle::OracleConnection());
oracleConnection1->ConnectionString ="User ID=scott; Password=tiger; Data Source=testdb";
oracleConnection1->Open();
}//line 94

Additional information: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)

call strack information:

CoreLab.Oracle.dll!CoreLab.Common.DbConnectionClosed.Open(CoreLab.Common.DbConnectionBase outerConnection = {CoreLab.Oracle.OracleConnection}) + 0xe0 bytes
CoreLab.Oracle.dll!CoreLab.Common.DbConnectionBase.Open() + 0x32 bytes
CoreLab.Oracle.dll!CoreLab.Oracle.OracleConnection.Open() + 0x19b bytes
>test.exe!test::Form1::button1_Click(System::Object^ sender = 0x0012ed0c, System::EventArgs^ e = 0x0012ed1c) Line 94 + 0xe bytes C++
System.Windows.Forms.dll!System.Windows.Forms.Control.OnClick(System.EventArgs e) + 0x57 bytes

tom_jht
Posts: 16
Joined: Sat 18 Mar 2006 06:24

exeception

Post by tom_jht » Thu 11 May 2006 01:50

hi,

private: System::Void button1_Click(System::Object^ sender, System::EventArgs^ e)
{
this->oracleConnection1 = (gcnew CoreLab::Oracle::OracleConnection());
oracleConnection1->ConnectionString ="User ID=scott; Password=tiger; Data Source=testdb";
oracleConnection1->Open();
}//line 94

Additional information: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)

call strack information:

CoreLab.Oracle.dll!CoreLab.Common.DbConnectionClosed.Open(CoreLab.Common.DbConnectionBase outerConnection = {CoreLab.Oracle.OracleConnection}) + 0xe0 bytes
CoreLab.Oracle.dll!CoreLab.Common.DbConnectionBase.Open() + 0x32 bytes
CoreLab.Oracle.dll!CoreLab.Oracle.OracleConnection.Open() + 0x19b bytes
>test.exe!test::Form1::button1_Click(System::Object^ sender = 0x0012ed0c, System::EventArgs^ e = 0x0012ed1c) Line 94 + 0xe bytes C++
System.Windows.Forms.dll!System.Windows.Forms.Control.OnClick(System.EventArgs e) + 0x57 bytes


this is all my app and call strack information.

i don't konw why?

thank u

tom

tom_jht
Posts: 16
Joined: Sat 18 Mar 2006 06:24

new

Post by tom_jht » Fri 12 May 2006 05:25

hi,Paul

i forgot to tell u that my app is runing at 64bit mode(compiler with x64) in vs2005(vc++8.0) on windows xp64.

thank u

tom

tom_jht
Posts: 16
Joined: Sat 18 Mar 2006 06:24

new

Post by tom_jht » Sat 13 May 2006 07:16

hi Paul ,

All my information is:

when I use oradirect 3.5, my program is runing on 64bit mode(compiled with x64) in vs2005(vc++8.0) on windows xp64.

private: System::Void button1_Click(System::Object^ sender, System::EventArgs^ e)
{
this->oracleConnection1 = (gcnew CoreLab::Oracle::OracleConnection());
oracleConnection1->ConnectionString ="User ID=scott; Password=tiger; Data Source=testdb";
oracleConnection1->Open();
}

Additional information: Arithmetic operation resulted in an overflow.
on 32bit mode(compiled with x32), it no problem.

why?

I think it is caused by windows xp64?

this is useful for u .

thank u very much!

tom

tom_jht
Posts: 16
Joined: Sat 18 Mar 2006 06:24

Post by tom_jht » Thu 18 May 2006 00:41

hi,

anyone have same problems?

why?

thanks!


tom

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Thu 18 May 2006 12:44

Do you use OraDirect for .NET 2.0 Framework?

Post Reply