Search:   Namespaces Discussions .NET v1.1 Feedback

Oracle 9i OLEDB Conn in .Net Messages   Related Types This message was discovered on ASPFriends.com 'ngfx-oracle' list. Steven M. Swafford I have been unsuccessful at getting this connection to work: Any thoughts? Import Namespace="System.Data.OleDb" Sub Page_Load Dim OleDbConnection As OleDb.OleDbConnection Dim sConnString As String = _ "Provider=OraOLEDB.Oracle;" & _ "Data Source=localhost;" & _ "User ID=xxx;" & _ "Password=xxx;" OleDbConnection = New OleDb.OleDbConnection(sConnString) OleDbConnection.Open() End Sub The error I get is: C:\WINDOWS\system32> "c:\windows\microsoft.net\framework\v1.0.3705\vbc.exe" /t:library /utf8output /R:"c:\windows\assembly\gac\system.web.services\1.0.3300.0__b03f5f7f11d5 0a3a\system.web.services.dll" /R:"c:\windows\microsoft.net\framework\v1.0.3705\temporary asp.net files\aspalliance_dotnet\7c35d723\807dd867\assembly\dl\aa998388\5015d3ba _ee05c201\aspalliance_dotnet.dll" /R:"c:\windows\assembly\gac\system.xml\1.0.3300.0__b77a5c561934e089\syst em.xml.dll" /R:"c:\windows\assembly\gac\system.enterpriseservices\1.0.3300.0__b03f5f 7f11d50a3a\system.enterpriseservices.dll" /R:"c:\windows\assembly\gac\system.drawing\1.0.3300.0__b03f5f7f11d50a3a\ system.drawing.dll" /R:"c:\windows\assembly\gac\system\1.0.3300.0__b77a5c561934e089\system.d ll" /R:"c:\windows\assembly\gac\system.data\1.0.3300.0__b77a5c561934e089\sys tem.data.dll" /R:"c:\windows\assembly\gac\system.web\1.0.3300.0__b03f5f7f11d50a3a\syst em.web.dll" /R:"c:\windows\microsoft.net\framework\v1.0.3705\temporary asp.net files\aspalliance_dotnet\7c35d723\807dd867\x55jqj9o.dll" /out:"C:\WINDOWS\Microsoft.NET\Framework\v1.0.3705\Temporary ASP.NET Files\aspalliance_dotnet\7c35d723\807dd867\-fed28ni.dll" /D:DEBUG=1 /debug+ "C:\WINDOWS\Microsoft.NET\Framework\v1.0.3705\Temporary ASP.NET Files\aspalliance_dotnet\7c35d723\807dd867\-fed28ni.0.vb" Microsoft (R) Visual Basic .NET Compiler version 7.00.9466 for Microsoft (R) .NET Framework version 1.00.3705.209 Copyright (C) Microsoft Corporation 1987-2001. All rights reserved. c:\inetpub\wwwroot\aspalliance_dotnet\datagrid.aspx(8) : error BC30002: Type 'OleDb.OleDbConnection' is not defined. Dim OleDbConnection As OleDb.OleDbConnection ~~~~~~~~~~~~~~~~~~~~~ c:\inetpub\wwwroot\aspalliance_dotnet\datagrid.aspx(14) : error BC30002: Type 'OleDb.OleDbConnection' is not defined. OleDbConnection = New OleDb.OleDbConnection(sConnString) \|||/ (o o) ----ooO-(_)-Ooo-------- Steven M. Swafford Reply to this message...        Wally McClure Oracle 9i OLEDB Conn in .NetA couple of things. 1. The error that you are getting leads me to believe that there is some conflict between the System.Data.OleDb namespace and variable called OleDbConnection. I would suggest changing the name of the variable to oledbCn, or something like that. Do you have System.Data.OleDb properly setup as a reference to this application? 2. I don't think that your 'Data Source' name is setup correctly. Typically, the data source name is the name setup in TNSNames. Wally ----- Original Message ----- From: Steven M. Swafford To: ngfx-oracle Sent: Monday, May 27, 2002 11:19 PM Subject: [ngfx-oracle] Oracle 9i OLEDB Conn in .Net I have been unsuccessful at getting this connection to work: Any thoughts? Import Namespace="System.Data.OleDb" Sub Page_Load Dim OleDbConnection As OleDb.OleDbConnection Dim sConnString As String = _ "Provider=OraOLEDB.Oracle;" & _ "Data Source=localhost;" & _ "User ID=xxx;" & _ "Password=xxx;" OleDbConnection = New OleDb.OleDbConnection(sConnString) OleDbConnection.Open() End Sub The error I get is: C:\WINDOWS\system32> "c:\windows\microsoft.net\framework\v1.0.3705\vbc.exe" /t:library /utf8output /R:"c:\windows\assembly\gac\system.web.services\1.0.3300.0__b03f5f7f11d50a3a\system.web.services.dll" /R:"c:\windows\microsoft.net\framework\v1.0.3705\temporary asp.net files\aspalliance_dotnet\7c35d723\807dd867\assembly\dl\aa998388\5015d3ba_ee05c201\aspalliance_dotnet.dll" /R:"c:\windows\assembly\gac\system.xml\1.0.3300.0__b77a5c561934e089\system.xml.dll" /R:"c:\windows\assembly\gac\system.enterpriseservices\1.0.3300.0__b03f5f7f11d50a3a\system.enterpriseservices.dll" /R:"c:\windows\assembly\gac\system.drawing\1.0.3300.0__b03f5f7f11d50a3a\system.drawing.dll" /R:"c:\windows\assembly\gac\system\1.0.3300.0__b77a5c561934e089\system.dll" /R:"c:\windows\assembly\gac\system.data\1.0.3300.0__b77a5c561934e089\system.data.dll" /R:"c:\windows\assembly\gac\system.web\1.0.3300.0__b03f5f7f11d50a3a\system.web.dll" /R:"c:\windows\microsoft.net\framework\v1.0.3705\temporary asp.net files\aspalliance_dotnet\7c35d723\807dd867\x55jqj9o.dll" /out:"C:\WINDOWS\Microsoft.NET\Framework\v1.0.3705\Temporary ASP.NET Files\aspalliance_dotnet\7c35d723\807dd867\-fed28ni.dll" /D:DEBUG=1 /debug+ "C:\WINDOWS\Microsoft.NET\Framework\v1.0.3705\Temporary ASP.NET Files\aspalliance_dotnet\7c35d723\807dd867\-fed28ni.0.vb" Microsoft (R) Visual Basic .NET Compiler version 7.00.9466 for Microsoft (R) .NET Framework version 1.00.3705.209 Copyright (C) Microsoft Corporation 1987-2001. All rights reserved. c:\inetpub\wwwroot\aspalliance_dotnet\datagrid.aspx(8) : error BC30002: Type 'OleDb.OleDbConnection' is not defined. Dim OleDbConnection As OleDb.OleDbConnection ~~~~~~~~~~~~~~~~~~~~~ c:\inetpub\wwwroot\aspalliance_dotnet\datagrid.aspx(14) : error BC30002: Type 'OleDb.OleDbConnection' is not defined. OleDbConnection = New OleDb.OleDbConnection(sConnString) \|||/ (o o) ----ooO-(_)-Ooo-------- Steven M. Swafford | [ngfx-oracle] member Click here to reveal e-mail address = YOUR ID | http://www.aspfriends.com/aspfriends/ngfx-oracle.asp = JOIN/QUIT Reply to this message...        Moua, Xay Try this: ************************************************ Import System.Data.OleDb Sub Page_Load Dim sConnString As String = _ "Provider=OraOLEDB.Oracle;" & _ "Data Source=localhost;" & _ "User ID=xxx;" & _ "Password=xxx;" Dim OleDbConnection As New OleDb.OleDbConnection(sConnString) OleDbConnection.Open() End Sub -----Original Message----- From: Steven M. Swafford [mailto:Click here to reveal e-mail address] Sent: Monday, May 27, 2002 11:20 PM To: ngfx-oracle Subject: [ngfx-oracle] Oracle 9i OLEDB Conn in .Net I have been unsuccessful at getting this connection to work: Any thoughts? Import Namespace="System.Data.OleDb" Sub Page_Load Dim OleDbConnection As OleDb.OleDbConnection Dim sConnString As String = _ "Provider=OraOLEDB.Oracle;" & _ "Data Source=localhost;" & _ "User ID=xxx;" & _ "Password=xxx;" OleDbConnection = New OleDb.OleDbConnection(sConnString) OleDbConnection.Open() End Sub The error I get is: C:\WINDOWS\system32> "c:\windows\microsoft.net\framework\v1.0.3705\vbc.exe" /t:library /utf8output /R:"c:\windows\assembly\gac\system.web.services\1.0.3300.0__b03f5f7f11d50a3a \system.web.services.dll" /R:"c:\windows\microsoft.net\framework\v1.0.3705\temporary asp.net files\aspalliance_dotnet\7c35d723\807dd867\assembly\dl\aa998388\5015d3ba_ee0 5c201\aspalliance_dotnet.dll" /R:"c:\windows\assembly\gac\system.xml\1.0.3300.0__b77a5c561934e089\system.x ml.dll" /R:"c:\windows\assembly\gac\system.enterpriseservices\1.0.3300.0__b03f5f7f11 d50a3a\system.enterpriseservices.dll" /R:"c:\windows\assembly\gac\system.drawing\1.0.3300.0__b03f5f7f11d50a3a\syst em.drawing.dll" /R:"c:\windows\assembly\gac\system\1.0.3300.0__b77a5c561934e089\system.dll" /R:"c:\windows\assembly\gac\system.data\1.0.3300.0__b77a5c561934e089\system. data.dll" /R:"c:\windows\assembly\gac\system.web\1.0.3300.0__b03f5f7f11d50a3a\system.w eb.dll" /R:"c:\windows\microsoft.net\framework\v1.0.3705\temporary asp.net files\aspalliance_dotnet\7c35d723\807dd867\x55jqj9o.dll" /out:"C:\WINDOWS\Microsoft.NET\Framework\v1.0.3705\Temporary ASP.NET Files\aspalliance_dotnet\7c35d723\807dd867\-fed28ni.dll" /D:DEBUG=1 /debug+ "C:\WINDOWS\Microsoft.NET\Framework\v1.0.3705\Temporary ASP.NET Files\aspalliance_dotnet\7c35d723\807dd867\-fed28ni.0.vb" Microsoft (R) Visual Basic .NET Compiler version 7.00.9466 for Microsoft (R) .NET Framework version 1.00.3705.209 Copyright (C) Microsoft Corporation 1987-2001. All rights reserved. c:\inetpub\wwwroot\aspalliance_dotnet\datagrid.aspx(8) : error BC30002: Type 'OleDb.OleDbConnection' is not defined. Dim OleDbConnection As OleDb.OleDbConnection ~~~~~~~~~~~~~~~~~~~~~ c:\inetpub\wwwroot\aspalliance_dotnet\datagrid.aspx(14) : error BC30002: Type 'OleDb.OleDbConnection' is not defined. OleDbConnection = New OleDb.OleDbConnection(sConnString) \|||/ (o o) ----ooO-(_)-Ooo-------- Steven M. Swafford | [ngfx-oracle] member Click here to reveal e-mail address = YOUR ID | http://www.aspfriends.com/aspfriends/ngfx-oracle.asp = JOIN/QUIT Reply to this message...        Sreedhar Koganti <html><div style='background-color:'><DIV> <P>Do you tried with OracleClient [with Oracle.Net], Since you are trying for oracle, I  will suggest you to use Oracle.Net. I tried it with Oracle 8.1.7, It worked for me. I am sure it works with 9i also.<BR><BR>Cheers<BR>Sreedhar<BR><A href="http://www.w3coder.com"" target="_blank">http://www.w3coder.com";>http://www.w3coder.com</A></P> <P><BR><BR> </P></DIV> <DIV></DIV> <DIV></DIV>>From: "Moua, Xay" <Click here to reveal e-mail address> <DIV></DIV>>Reply-To: "ngfx-oracle" <Click here to reveal e-mail address> <DIV></DIV>>To: "ngfx-oracle" <Click here to reveal e-mail address> <DIV></DIV>>Subject: [ngfx-oracle] RE: Oracle 9i OLEDB Conn in .Net <DIV></DIV>>Date: Tue, 28 May 2002 08:42:37 -0400 <DIV></DIV>> <DIV></DIV>>Try this: <DIV></DIV>> <DIV></DIV>>************************************************ <DIV></DIV>> <DIV></DIV>>Import System.Data.OleDb <DIV></DIV>> <DIV></DIV>>Sub Page_Load <DIV></DIV>> <DIV></DIV>>Dim sConnString As String = _ <DIV></DIV>> <DIV></DIV>>"Provider=OraOLEDB.Oracle;" & _ <DIV></DIV>> <DIV></DIV>>"Data Source=localhost;" & _ <DIV></DIV>> <DIV></DIV>>"User ID=xxx;" & _ <DIV></DIV>> <DIV></DIV>>"Password=xxx;" <DIV></DIV>> <DIV></DIV>>Dim OleDbConnection As New OleDb.OleDbConnection(sConnString) <DIV></DIV>> <DIV></DIV>>OleDbConnection.Open() <DIV></DIV>> <DIV></DIV>>End Sub <DIV></DIV>> <DIV></DIV>>-----Original Message----- <DIV></DIV>>From: Steven M. Swafford [mailto:Click here to reveal e-mail address] <DIV></DIV>>Sent: Monday, May 27, 2002 11:20 PM <DIV></DIV>>To: ngfx-oracle <DIV></DIV>>Subject: [ngfx-oracle] Oracle 9i OLEDB Conn in .Net <DIV></DIV>> <DIV></DIV>> <DIV></DIV>> <DIV></DIV>>I have been unsuccessful at getting this connection to work: Any thoughts? <DIV></DIV>> <DIV></DIV>>Import Namespace="System.Data.OleDb" <DIV></DIV>> <DIV></DIV>>Sub Page_Load <DIV></DIV>> <DIV></DIV>>Dim OleDbConnection As OleDb.OleDbConnection <DIV></DIV>> <DIV></DIV>>Dim sConnString As String = _ <DIV></DIV>> <DIV></DIV>>"Provider=OraOLEDB.Oracle;" & _ <DIV></DIV>> <DIV></DIV>>"Data Source=localhost;" & _ <DIV></DIV>> <DIV></DIV>>"User ID=xxx;" & _ <DIV></DIV>> <DIV></DIV>>"Password=xxx;" <DIV></DIV>> <DIV></DIV>>OleDbConnection = New OleDb.OleDbConnection(sConnString) <DIV></DIV>> <DIV></DIV>>OleDbConnection.Open() <DIV></DIV>> <DIV></DIV>>End Sub <DIV></DIV>> <DIV></DIV>>The error I get is: <DIV></DIV>> <DIV></DIV>>C:\WINDOWS\system32> "c:\windows\microsoft.net\framework\v1.0.3705\vbc.exe" <DIV></DIV>>/t:library /utf8output <DIV></DIV>>/R:"c:\windows\assembly\gac\system.web.services\1.0.3300.0__b03f5f7f11d50a3a <DIV></DIV>>\system.web.services.dll" <DIV></DIV>>/R:"c:\windows\microsoft.net\framework\v1.0.3705\temporary asp.net <DIV></DIV>>files\aspalliance_dotnet\7c35d723\807dd867\assembly\dl\aa998388\5015d3ba_ee0 <DIV></DIV>>5c201\aspalliance_dotnet.dll" <DIV></DIV>>/R:"c:\windows\assembly\gac\system.xml\1.0.3300.0__b77a5c561934e089\system.x <DIV></DIV>>ml.dll" <DIV></DIV>>/R:"c:\windows\assembly\gac\system.enterpriseservices\1.0.3300.0__b03f5f7f11 <DIV></DIV>>d50a3a\system.enterpriseservices.dll" <DIV></DIV>>/R:"c:\windows\assembly\gac\system.drawing\1.0.3300.0__b03f5f7f11d50a3a\syst <DIV></DIV>>em.drawing.dll" <DIV></DIV>>/R:"c:\windows\assembly\gac\system\1.0.3300.0__b77a5c561934e089\system.dll" <DIV></DIV>>/R:"c:\windows\assembly\gac\system.data\1.0.3300.0__b77a5c561934e089\system. <DIV></DIV>>data.dll" <DIV></DIV>>/R:"c:\windows\assembly\gac\system.web\1.0.3300.0__b03f5f7f11d50a3a\system.w <DIV></DIV>>eb.dll" /R:"c:\windows\microsoft.net\framework\v1.0.3705\temporary asp.net <DIV></DIV>>files\aspalliance_dotnet\7c35d723\807dd867\x55jqj9o.dll" <DIV></DIV>>/out:"C:\WINDOWS\Microsoft.NET\Framework\v1.0.3705\Temporary ASP.NET <DIV></DIV>>Files\aspalliance_dotnet\7c35d723\807dd867\-fed28ni.dll" /D:DEBUG=1 /debug+ <DIV></DIV>>"C:\WINDOWS\Microsoft.NET\Framework\v1.0.3705\Temporary ASP.NET <DIV></DIV>>Files\aspalliance_dotnet\7c35d723\807dd867\-fed28ni.0.vb" <DIV></DIV>> <DIV></DIV>> <DIV></DIV>>Microsoft (R) Visual Basic .NET Compiler version 7.00.9466 <DIV></DIV>> <DIV></DIV>>for Microsoft (R) .NET Framework version 1.00.3705.209 <DIV></DIV>> <DIV></DIV>>Copyright (C) Microsoft Corporation 1987-2001. All rights reserved. <DIV></DIV>> <DIV></DIV>>c:\inetpub\wwwroot\aspalliance_dotnet\datagrid.aspx(8) : error BC30002: Type <DIV></DIV>>'OleDb.OleDbConnection' is not defined. <DIV></DIV>> <DIV></DIV>>Dim OleDbConnection As OleDb.OleDbConnection <DIV></DIV>> <DIV></DIV>> ~~~~~~~~~~~~~~~~~~~~~ <DIV></DIV>> <DIV></DIV>>c:\inetpub\wwwroot\aspalliance_dotnet\datagrid.aspx(14) : error BC30002: <DIV></DIV>>Type 'OleDb.OleDbConnection' is not defined. <DIV></DIV>> <DIV></DIV>>OleDbConnection = New OleDb.OleDbConnection(sConnString) <DIV></DIV>> <DIV></DIV>> <DIV></DIV>> \|||/ <DIV></DIV>> (o o) <DIV></DIV>>----ooO-(_)-Ooo-------- <DIV></DIV>>Steven M. Swafford <DIV></DIV>> <DIV></DIV>> <DIV></DIV>> <DIV></DIV>>| [ngfx-oracle] member Click here to reveal e-mail address = YOUR ID | <DIV></DIV>>http://www.aspfriends.com/aspfriends/ngfx-oracle.asp = JOIN/QUIT <DIV></DIV>> <DIV></DIV>> <DIV></DIV>> <DIV></DIV>>| [ngfx-oracle] member Click here to reveal e-mail address = YOUR ID <DIV></DIV>>| http://www.aspfriends.com/aspfriends/ngfx-oracle.asp = JOIN/QUIT <DIV></DIV></div><br clear=all><hr>Send and receive Hotmail on your mobile device: <a href='http://g.msn.com/1HM303401/38'>Click Here</a><br></html> Reply to this message...     System.Data.OleDb.OleDbConnection Ad MBR BootFX Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT

Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd. Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com