this is the code--
Dim con As New System.Data.OracleClient.OracleConnection()
con.ConnectionString = "Password=tiger;User ID=scott;Data Source=INDV;"
con.Open()
and the error is--
OCIEnvNlsCreate failed with return code -1 but error message text was not available.
Well, if i m connecting ASP.Net with SQL Server its wrking perfectly alright..I have oracle client installed on my machine..
how do we run "aspnet_regiis -i" from the framework folder. Could u pls explain it little further..
I m not able to connect ASP.Net with Oracle. The code is given below-
=========================================================
Dim oOracleConn As OleDbConnection = New OleDbConnection()
oOracleConn.ConnectionString = "Provider=OraOLEDB.Oracle;Data Source=INDV;User ID=scott;Password=tiger"...
Hi All,
I want to connect ASP.Net with Oracle 8...i have installed Microsoft .Net Oracle Cleint..
i got this code from the Net
===========================================================
Imports System.Data.OracleClient
Dim oOracleConn As OracleConnection = New OracleConnection()...
well, i tried this code but not able to retrieve the records in recordset...
===========================================================
Dim objConnection
Dim objCommand
Dim objRecordset
Set objConnection = Server.CreateObject("ADODB.Connection")
With objConnection...
hi again...
My stored procedure is given below...
==========================================================
CREATE OR REPLACE procedure proc_meenu1(v_empno emp.empno%TYPE)
IS
CURSOR c1(v_empno emp.empno%TYPE) IS
SELECT * FROM EMP
WHERE empno = v_empno;
BEGIN
FOR I IN C1(v_empno)...
Hi All,
I want to call oracle procedure from my ASP page in which i m passing the value of empno and want to display empname,job etc..from the table...my code is given below...
=========================================================
Dim strSearchName
Dim objConnection
Dim objCommand
Dim...
I m not able to create a view for sp2.
my table structure(GTD_M_RESOURCE_CONTACT)for sp2 is--
Resource_id Contact_Type Last_Digits
---------------------------------------------
193 O 291
193 F 56122778
193 C...
Stored Procedure 1--
CREATE Procedure sp1
AS
BEGIN
SELECT * FROM Table1
WHERE
COMPANY_ID=52 AND
CONTACT_TYPE='O' AND
RESOURCE_TYPE_ID=1 AND
RESOURCE_ROLE='P'
END
GO
=========================================================
Stored Procedure 2--
CREATE Procedure sp2
AS
BEGIN
SELECT...
Hi All,
I have one Reapeter in my page. I have to use two seperate stored procedures in order to fetch the data from database and then bind it to the data repeater.
My code is given below--
<asp:Repeater id="Repeater1" runat="server">
<HeaderTemplate>
<table border="1">
<tr...
Hi cappmgr,
well well finally i got the solution...the procedure for vb.net & C# is same but make sure there isn't a "root namespace" specified for your control in the project properties, this is a "feature" of VB.net.
This was the only problem..
Thanks for your help.
Regards,
Meenakshi Dhar
Hi cappmgr,
i think the problem is with vb dll...if i follow the same procedure in C#..then it's working perfectly alright...
In Case of C#--
Namespace=ABC
Project Name=ABC
Class Name= WebCustomControl1
In my code behind file its showing--
Protected WithEvents md1 As ABC.WebCustomControl1...
thanks Marty...i think there is some problem in naming conventions...Could you please correct this---
My Namespace= MControl
My Control Class Name=MClass
My Dll= MControl
In my code behind file its showing--
Protected MyCtrl As MControl.MControl.MClass (why ??)
and in my aspx page i m using...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.