| Oracle 9i OLEDB Conn in .Net (4 replies) |
| ASPFriends.com 'ngfx-oracle' list |
| 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:\WIND... |
|
| .NET Oracle Data Provider beta 1 (4 replies) |
| ASPFriends.com 'ngfx-oracle' list |
| Ok ASPFRIENDS, I have downloaded and sucessfully installed The .NET Oracle Data Provider beta 1. I have tried to use the recommended Oracle Connection NameSpace, but It is not recognized! Here follows the code: %@ Import Namespace 3D"System.Data.OracleClient" % script language 3D"VB" runat 3D"server" Sub Page Load(Sender As Object, E As EventArgs) 20 Dim con As New OracleConnection("SERVER 3D;USER... |
|
| help with ado.net and oracle functions (2 replies) |
| ASPFriends.com 'ngfx-oracle' list |
| Moved from [aspngfreeforall] to [ngfx oracle] by Tim Musschoot Tim.Musschoot@rug.ac.be Hello I'm new to ado.net and I'm trying to call an oracle function. the function has an input parameter as an Integer and returns an integer. For some reasons, I cannot call the function properly. Any advice, web links, tutorial, specific to the Oracle function that you might know of and refer me to? I can do th... |
|
| Managed Provider for Oracle from Oracle aka odp.net (2 replies) |
| ASPFriends.com 'ngfx-oracle' list |
| I just got an email from Oracle that the Managed provider for Oracle from Oracle (aka odp.net) is available for download. You can get a copy at http://otn.oracle.com/tech/windows/odpnet this is beta code. More info as I have a chance to dive into it. Now if I could just get something from IBM about DB/2, I would have all my bases covered. Wally |
|
| odp.net error!? (2 replies) |
| ASPFriends.com 'ngfx-oracle' list |
| Hi Guys, I need some help. I have been in this list and perhaps for my early stage in .NET, I have not understood the hints an tips directed to my issue. My code is: %@ Import Namespace "System.Data.OracleClient" % script language "VB" runat "server" Debug "true" Sub Page Load(Sender As Object, E As EventArgs) Dim con As New OracleConnection("SERVER aspnet;USER ID system;PWD manager") Dim cmd As N... |
|
| NOCOUNT?!? (5 replies) |
| ASPFriends.com 'ngfx-oracle' list |
| SQL Server has an option "NOCOUNT" that turns off the end results for queries on how many rows are returned. Does Oracle have this same option? It would add a lot of efficiency if the database doesn't have to count results as they are returned. Every little bit helps. :) Thanks Matt |
|
