I have tried several methods to connect to an Oracle DB, but with no 
success. I have downloaded and installed both MS .NET data provider for 
Oracle and ODBC.NET. I keep getting error messages that says namespaces 
can`t be found when I import them:

%@ Import NameSpace="system.data.OracleClient %
%@ Import NameSpace="Microsoft.system.data.odbc %

They are both registered in the gobal cache.

Any ideas???

thanks in advance!

C

use System.Data.OleDb;

-----Original Message-----
From: Chris Lancey [mailto:xenostalker@m...]
Sent: Wednesday, February 05, 2003 11:45 AM
To: aspx_beginners
Subject: [aspx_beginners] Connect to oracle


I have tried several methods to connect to an Oracle DB, but with no
success. I have downloaded and installed both MS .NET data provider for
Oracle and ODBC.NET. I keep getting error messages that says namespaces
can`t be found when I import them:

%@ Import NameSpace="system.data.OracleClient %
%@ Import NameSpace="Microsoft.system.data.odbc %

They are both registered in the gobal cache.

Any ideas???

thanks in advance!

C

I`ve tried that as well. 
This is my connection string:

strConnORA = "Provider=MSDAORA;Data Source=XXX;User ID=XXX;Password=XXX;"

Where data source is db name set in tnsnames.ora.
And the error message I get is:
Oracle client and Networking components were not found. These components 
are supplied by Oracle Corporation and are a part of Oracle Version 7.3.3 
or later client software installation. Provider is unable to function 
until these components are installed.

I have Oracle server 8.1.7 and oracle client 9i installed on my machine.

________________________________________________________________________


> use System.Data.OleDb;

-----Original Message-----
From: Chris Lancey [mailto:xenostalker@m...]
Sent: Wednesday, February 05, 2003 11:45 AM
To: aspx_beginners
Subject: [aspx_beginners] Connect to oracle


I have tried several methods to connect to an Oracle DB, but with no
success. I have downloaded and installed both MS .NET data provider for
Oracle and ODBC.NET. I keep getting error messages that says namespaces
can`t be found when I import them:

%@ Import NameSpace="system.data.OracleClient %
%@ Import NameSpace="Microsoft.system.data.odbc %

They are both registered in the gobal cache.

Any ideas???

thanks in advance!

C

hi there.. 
try this one

%@ Import NameSpace="System.Data.OracleClient %>
%@ Import NameSpace="Microsoft.System.Data.Odbc %>


Namespace are case sensitive...
regards
-----Original Message-----
From: Chris Lancey [mailto:xenostalker@m...]
Sent: Wednesday, February 05, 2003 5:15 PM
To: aspx_beginners
Subject: [aspx_beginners] Connect to oracle


I have tried several methods to connect to an Oracle DB, but with no 
success. I have downloaded and installed both MS .NET data provider for 
Oracle and ODBC.NET. I keep getting error messages that says namespaces 
can`t be found when I import them:

%@ Import NameSpace="system.data.OracleClient %
%@ Import NameSpace="Microsoft.system.data.odbc %

They are both registered in the gobal cache.

Any ideas???

thanks in advance!

C

Hey frenz where are these namespaces

NameSpace="System.Data.OracleClient
NameSpace="Microsoft.System.Data.Odbc

coz what alwayz i could find is system.data.oledb or system.data.odbc ...but
I hv never seen these two namespace but in some book i hv read this about
data.odbc and they said microsoft has plan to include that...has it arrived
??

peace
rohit


-----Original Message-----
From: Ashish M.bhonkiya [mailto:Ashishm@p...]
Sent: Thursday, February 06, 2003 9:58 AM
To: aspx_beginners
Subject: [aspx_beginners] RE: Connect to oracle


hi there..
try this one

%@ Import NameSpace="System.Data.OracleClient %>
%@ Import NameSpace="Microsoft.System.Data.Odbc %>


Namespace are case sensitive...
regards
-----Original Message-----
From: Chris Lancey [mailto:xenostalker@m...]
Sent: Wednesday, February 05, 2003 5:15 PM
To: aspx_beginners
Subject: [aspx_beginners] Connect to oracle


I have tried several methods to connect to an Oracle DB, but with no
success. I have downloaded and installed both MS .NET data provider for
Oracle and ODBC.NET. I keep getting error messages that says namespaces
can`t be found when I import them:

%@ Import NameSpace="system.data.OracleClient %
%@ Import NameSpace="Microsoft.system.data.odbc %

They are both registered in the gobal cache.

Any ideas???

thanks in advance!

C

you can download it from net and once you put it in GAC it will come.
by default .net SDK has Systeb.Data has SqlClient and OleDb 

regards

-----Original Message-----
From: Rohit Arora [mailto:rohit_arora@i...]
Sent: Thursday, February 06, 2003 9:51 AM
To: aspx_beginners
Subject: [aspx_beginners] RE: Connect to oracle


Hey frenz where are these namespaces

NameSpace="System.Data.OracleClient
NameSpace="Microsoft.System.Data.Odbc

coz what alwayz i could find is system.data.oledb or system.data.odbc ...but
I hv never seen these two namespace but in some book i hv read this about
data.odbc and they said microsoft has plan to include that...has it arrived
??

peace
rohit


-----Original Message-----
From: Ashish M.bhonkiya [mailto:Ashishm@p...]
Sent: Thursday, February 06, 2003 9:58 AM
To: aspx_beginners
Subject: [aspx_beginners] RE: Connect to oracle


hi there..
try this one

%@ Import NameSpace="System.Data.OracleClient %>
%@ Import NameSpace="Microsoft.System.Data.Odbc %>


Namespace are case sensitive...
regards
-----Original Message-----
From: Chris Lancey [mailto:xenostalker@m...]
Sent: Wednesday, February 05, 2003 5:15 PM
To: aspx_beginners
Subject: [aspx_beginners] Connect to oracle


I have tried several methods to connect to an Oracle DB, but with no
success. I have downloaded and installed both MS .NET data provider for
Oracle and ODBC.NET. I keep getting error messages that says namespaces
can`t be found when I import them:

%@ Import NameSpace="system.data.OracleClient %
%@ Import NameSpace="Microsoft.system.data.odbc %

They are both registered in the gobal cache.

Any ideas???

thanks in advance!

C

so it must be part of some service pack for framework. right ?

and can u also specify some other namespaces which are not a part of this
framework but we can add..by downloading ?

peace
rohit

-----Original Message-----
From: Ashish M.bhonkiya [mailto:Ashishm@p...]
Sent: Thursday, February 06, 2003 10:09 AM
To: aspx_beginners
Subject: [aspx_beginners] RE: Connect to oracle


you can download it from net and once you put it in GAC it will come.
by default .net SDK has Systeb.Data has SqlClient and OleDb

regards

-----Original Message-----
From: Rohit Arora [mailto:rohit_arora@i...]
Sent: Thursday, February 06, 2003 9:51 AM
To: aspx_beginners
Subject: [aspx_beginners] RE: Connect to oracle


Hey frenz where are these namespaces

NameSpace="System.Data.OracleClient
NameSpace="Microsoft.System.Data.Odbc

coz what alwayz i could find is system.data.oledb or system.data.odbc ...but
I hv never seen these two namespace but in some book i hv read this about
data.odbc and they said microsoft has plan to include that...has it arrived
??

peace
rohit


-----Original Message-----
From: Ashish M.bhonkiya [mailto:Ashishm@p...]
Sent: Thursday, February 06, 2003 9:58 AM
To: aspx_beginners
Subject: [aspx_beginners] RE: Connect to oracle


hi there..
try this one

%@ Import NameSpace="System.Data.OracleClient %>
%@ Import NameSpace="Microsoft.System.Data.Odbc %>


Namespace are case sensitive...
regards
-----Original Message-----
From: Chris Lancey [mailto:xenostalker@m...]
Sent: Wednesday, February 05, 2003 5:15 PM
To: aspx_beginners
Subject: [aspx_beginners] Connect to oracle


I have tried several methods to connect to an Oracle DB, but with no
success. I have downloaded and installed both MS .NET data provider for
Oracle and ODBC.NET. I keep getting error messages that says namespaces
can`t be found when I import them:

%@ Import NameSpace="system.data.OracleClient %
%@ Import NameSpace="Microsoft.system.data.odbc %

They are both registered in the gobal cache.

Any ideas???

thanks in advance!

C

it can be.. you can also write your own assembly and put it in to GAC. 



it depends where and how you need to implement. if you want your assembly to
be used by all applications you can put it in GAC or 
if you want your assembly to be used by only one application then you can
put it in local cache /bin directory.

http://www.code101.com/Code101/DisplayArticle.aspx?cid=21


you can reffer to the above link a good explanation is given there..

ashish

-----Original Message-----
From: Rohit Arora [mailto:rohit_arora@i...]
Sent: Thursday, February 06, 2003 10:03 AM
To: aspx_beginners
Subject: [aspx_beginners] RE: Connect to oracle


so it must be part of some service pack for framework. right ?

and can u also specify some other namespaces which are not a part of this
framework but we can add..by downloading ?

peace
rohit

-----Original Message-----
From: Ashish M.bhonkiya [mailto:Ashishm@p...]
Sent: Thursday, February 06, 2003 10:09 AM
To: aspx_beginners
Subject: [aspx_beginners] RE: Connect to oracle


you can download it from net and once you put it in GAC it will come.
by default .net SDK has Systeb.Data has SqlClient and OleDb

regards

-----Original Message-----
From: Rohit Arora [mailto:rohit_arora@i...]
Sent: Thursday, February 06, 2003 9:51 AM
To: aspx_beginners
Subject: [aspx_beginners] RE: Connect to oracle


Hey frenz where are these namespaces

NameSpace="System.Data.OracleClient
NameSpace="Microsoft.System.Data.Odbc

coz what alwayz i could find is system.data.oledb or system.data.odbc ...but
I hv never seen these two namespace but in some book i hv read this about
data.odbc and they said microsoft has plan to include that...has it arrived
??

peace
rohit


-----Original Message-----
From: Ashish M.bhonkiya [mailto:Ashishm@p...]
Sent: Thursday, February 06, 2003 9:58 AM
To: aspx_beginners
Subject: [aspx_beginners] RE: Connect to oracle


hi there..
try this one

%@ Import NameSpace="System.Data.OracleClient %>
%@ Import NameSpace="Microsoft.System.Data.Odbc %>


Namespace are case sensitive...
regards
-----Original Message-----
From: Chris Lancey [mailto:xenostalker@m...]
Sent: Wednesday, February 05, 2003 5:15 PM
To: aspx_beginners
Subject: [aspx_beginners] Connect to oracle


I have tried several methods to connect to an Oracle DB, but with no
success. I have downloaded and installed both MS .NET data provider for
Oracle and ODBC.NET. I keep getting error messages that says namespaces
can`t be found when I import them:

%@ Import NameSpace="system.data.OracleClient %
%@ Import NameSpace="Microsoft.system.data.odbc %

They are both registered in the gobal cache.

Any ideas???

thanks in advance!

C

Thanks all!

I think something is wrong with the oracle client. When I use MSDAORA as 
provider using OleDB, I keep getting error messages stating Oracle client 
and networking isn`t installed, wich it is.


-c-



> it can be.. you can also write your own assembly and put it in to GAC. 



it depends where and how you need to implement. if you want your assembly 
to
be used by all applications you can put it in GAC or 
if you want your assembly to be used by only one application then you can
put it in local cache /bin directory.

http://www.code101.com/Code101/DisplayArticle.aspx?cid=21


you can reffer to the above link a good explanation is given there..

ashish

-----Original Message-----
From: Rohit Arora [mailto:rohit_arora@i...]
Sent: Thursday, February 06, 2003 10:03 AM
To: aspx_beginners
Subject: [aspx_beginners] RE: Connect to oracle


so it must be part of some service pack for framework. right ?

and can u also specify some other namespaces which are not a part of this
framework but we can add..by downloading ?

peace
rohit

-----Original Message-----
From: Ashish M.bhonkiya [mailto:Ashishm@p...]
Sent: Thursday, February 06, 2003 10:09 AM
To: aspx_beginners
Subject: [aspx_beginners] RE: Connect to oracle


you can download it from net and once you put it in GAC it will come.
by default .net SDK has Systeb.Data has SqlClient and OleDb

regards

-----Original Message-----
From: Rohit Arora [mailto:rohit_arora@i...]
Sent: Thursday, February 06, 2003 9:51 AM
To: aspx_beginners
Subject: [aspx_beginners] RE: Connect to oracle


Hey frenz where are these namespaces

NameSpace="System.Data.OracleClient
NameSpace="Microsoft.System.Data.Odbc

coz what alwayz i could find is system.data.oledb or 
system.data.odbc ...but
I hv never seen these two namespace but in some book i hv read this about
data.odbc and they said microsoft has plan to include that...has it arrived
??

peace
rohit


-----Original Message-----
From: Ashish M.bhonkiya [mailto:Ashishm@p...]
Sent: Thursday, February 06, 2003 9:58 AM
To: aspx_beginners
Subject: [aspx_beginners] RE: Connect to oracle


hi there..
try this one

%@ Import NameSpace="System.Data.OracleClient %>
%@ Import NameSpace="Microsoft.System.Data.Odbc %>


Namespace are case sensitive...
regards
-----Original Message-----
From: Chris Lancey [mailto:xenostalker@m...]
Sent: Wednesday, February 05, 2003 5:15 PM
To: aspx_beginners
Subject: [aspx_beginners] Connect to oracle


I have tried several methods to connect to an Oracle DB, but with no
success. I have downloaded and installed both MS .NET data provider for
Oracle and ODBC.NET. I keep getting error messages that says namespaces
can`t be found when I import them:

%@ Import NameSpace="system.data.OracleClient %
%@ Import NameSpace="Microsoft.system.data.odbc %

They are both registered in the gobal cache.

Any ideas???

thanks in advance!

C

It still won`t work!!! aargh! Is this a microsoft conspiracy?

I`ve tried it all; using MS data provider for oracle, ODBC provider and 
OleDbConnection with MSDAORA provider.
I have also reinstalled Oracle client 8.1.7.

When using the two first, the namespaces aren`t found. When using 
OleDBconnection, the components can`t be found. 

Have anyone else used MS data provider for oracle or the ODBC provider? 
You only have to install it, right?

And has anyone ever managed to connect to an oracle database?? 

Getting quite frustratede here, even thinking of going back to Asp 3.0.

Is there anyone out there who can help me?????

-C-

Chris,

Mdac 2.7 or greater on client machine?
Just a thought, and probably not a relevant one at that.
Regards
Bob

-----Original Message-----
From: Chris Lancey [mailto:xenostalker@m...] 
Sent: Tuesday, 11 February 2003 1:44 p.m.
To: aspx_beginners
Subject: [aspx_beginners] RE: Connect to oracle

It still won`t work!!! aargh! Is this a microsoft conspiracy?

I`ve tried it all; using MS data provider for oracle, ODBC provider and 
OleDbConnection with MSDAORA provider.
I have also reinstalled Oracle client 8.1.7.

When using the two first, the namespaces aren`t found. When using 
OleDBconnection, the components can`t be found. 

Have anyone else used MS data provider for oracle or the ODBC provider? 
You only have to install it, right?

And has anyone ever managed to connect to an oracle database?? 

Getting quite frustratede here, even thinking of going back to Asp 3.0.

Is there anyone out there who can help me?????

-C-