I have a table in orcale database where I am inserting records. I am able to insert a record in a table but it is not being saved permenantly.When inserting there is no error. what could be causing this?
View 4 RepliesI'm a little confused as to what is causing the following error is a very simple application: System.ArgumentException: An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB The code-behind has this:
OleDbConnection conn = new
OleDbConnection(ConfigurationManager.ConnectionStrings["db_conn_qa"].ConnectionString);
In the Web.Config, the following is present (note the Provider is clearly there):
<configuration>
<appSettings/>
<connectionStrings>
<add name="db_conn_qa" connectionString="Data Source=xx;Persist Security Info=True;User ID=xx;Password=xx;Unicode=True"
providerName="System.Data.OracleClient" />
</connectionStrings>
<system.web>
...
supose i have one table nd there are many records in table .this table access by many usewhen any user inserted record in database then show message in popup boxnd this message show in all users
View 4 Repliesi am inserting a record into oracle database using vb.net,there is a password field by using md5 i am generating it and taking tht value as string(ex: "16D78A6B10D631C8C86397C35A3CCD57") now my requirement is i should insert it into database(oracle) & in database that field is "RAW" how to do this?and the error msg is
Type of value has a mismatch with column typeCouldn't store in Col_Pass Column. Expected type is Byte[].
I have data entry form like...There are some empty rows and some of them have values. User can Update existing values and can also fill value in empty rows.I need to map these values in my DB table and some of them will be inserted as new rows into the database and existing record will be updated.I need your suggestions, How can I accomplish this scenario with best approach.
View 2 Replies Suppose there are three button and every butthon has a click event function.
Clicking the first button displays something on this page with a gridview taking data from databases.
After clicking the first button i stored the value in a variable.
But when i click the second or third button i get null value for that variable.
Clicking the second or third button the page reloads and the value of that variable becomes null.
How can i store the value to that variable permanently?
My site extracts data from a MS SQL db and then connects to a mySql db which it writes the data to. My site is working properly when connecting to a db in cPanel at a remote website.
However, I have a mysql db also hosted on my site, and I'm connecting to it ok, but the loop is failing. There are 2 tables, one stores the category, and the other stores link data.
For each category
write to the category table
for each link in this category
write to the link table
next
next
The tables are being created, and the very first category is written to the table, but then nothing gets written to the link table.
How can I make this generate an error message? My webhost doesn't know what to do about it and they just want to see an error message.
I tried this once already, and neither of my lines worked:
HttpContext.Current.Response.Write(lnkid & " " & url)
Why doesn't that get written into the source of the page on each iterance of the loop? How do I see the data that isn't being written?
[Code]....
i am getting this error while fetching select statement in oracle pl/sql proc... ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'SP_CLASS' ORA-06550: line 1, column 7: PL/SQL: Statement ignored My proc is like..PROCEDURE "SP_CLASS" ( iDec IN NUMBER := null, p_ICID in number := null, p_DATA OUT SYS_REFCURSOR) IS BEGIN if(iDec = 1) then open p_DATA for SELECT ICID AS ID, SNAME AS NAME FROM SETUP_CLASS; else if(iDec = 2) then open p_DATA for SELECT ICID AS ID, SNAME AS NAME FROM SETUP_CLASS where ICID = p_ICID ; end if; end if; END;
View 1 Repliesdatabase type field BLOB in oracle but if i use MS SQL and field type as image then this below line code work fine.
here trying to save image in oracle database but system giving me below line error
unimplemented or unreasonable conversion requested
here is my code
[Code]....
In oracle we can do this by using rowid.
select * from tableName where rowid = (select max(rowid) from tableName);
but i don't know equivalent of rowid in sql server.
We already have a complete Oracle database system where we have there as well a table (Oracle table name : "LTR_USERS") for usernames, passwords, emails, etc...
Now, we want to create an ASP.NET 4.0 website and we want to use the built in Login control (no need for the register / create user controls). However, we want this Login control to use that Oracle table ("LTR_USERS") to look for the username and password. How to do that?
I am trying to insert a record into a MySQL Table. I thought that the Insert methods returned the number of records that were successfully inserted. But that is not what I found. My code:
Code:
dim n as integer
n = taProject.InsertProject(pname, descr, idManager, startdate, tenddate, client, disable)
I get n = 0 even though the record is installed. How can I determine if the insert was successful or not?
I need to fetch the data from a table with Alias name in oracle.
example: select f1 'Field Name1',f2 'Field Name2' from sometablename;
I am using asp.net 3.5 and Oracle Providers for membership and roles. Now, using CreateUserWizard i can make user register here but for storing custom information like First name, last name, address etc. i am using couple of custom oracle tables instead of Oracle Profile Provider. In this case, i am using the USERID field which is of GUID type as primary key. Now, my problem is that i dont know how to draw information from my custom oracle tables for those users who are currently logged in. I have searched a lot in this forum and elsewhere where there are many topics relating to it but i failed to follow any of them. So, i would request you to kindly guide me to solve the issue. Oracle Membership
Table(ORA_ASPNET_USERS) USERID=xxxxxxxxxxxxxxx(some guid value) Username=abc and so on.. My Custom Table(UserProfile): USERID RAW(16), --> referenced to USERID field of ORA_ASPNET_USERS table fname varchar2(20) lname varchar2(20) I've the profiles of username "abc" having some userid stored in Userprofile table So, how can i fetch data from UserProfile table for the user "abc" when he is logged in?
We are doing migration from SQL Server to Oracle.
I have following sample trigger which uses SQL Server built in tables "deleted" and "inserted" tables. But Oracle we do not have equivalent. Oracle has only :OLD, :NEW, which represents only one row, but not table contains set of deleted/inserted rows. what would be the equivalent trigger in Oracle?
[Code]....
I'm working with Oracle database and I want to improve performance of my website.I read about caching. So is it possible to implement caching (SQL Server Database Dependency) with oracle?
View 2 Replieshow i can use Oracle database with asp.net mvc 2 web application?
View 3 Replieshow to display msg ni label after data entered in databas in asp.net with c#
View 1 Repliesi hv been trying to perform insert operation on Oracle 10G database using asp.net 3.5. So far i m new to oracle and i m confused as back end queries seems different froms sql server. this code is in submit button click event:-
[code]....
am trying to insert images into oracle database using c#.net.but am getting error "ORA-01465: invalid hex number".Here is the code.
if (FUcontrol.HasFile)
My prob is that when data inserted in database after that without any button click the new record show in popup box ?
View 10 RepliesCan anybody tell me how can I increase the size of the database in oracle manually.
View 2 RepliesI have to automate one database process in .Net web applicaiton which uses Oracle 11g Database as Backend.
I need to know two things:
(1) How to check space on Oracle database server? I need space on server and not in the Database itself. My process creates few tables so I want to make sure that we have sufficient space before the process starts.
(2) Also I need to create script to backup Indexes and Triggers on the table so that I can recreate them after data transfer process is completed. Any idea how to create script form c# code?
How do I read excel(with many worksheets) using asp.net c# and load the data into oracle database?
View 2 Repliesam in deep trouble with retriving the data from oracle database. Please HELP ! In one line: "When i retrive the data from oracle database, it's truncate the data if it is more than 4 kb"I have oracle proc param as below:
PROCEDURE p_GetData (
ivar_id IN id_n%TYPE,
oclb_owners OUT CLOB,
onum_sqlcode OUT NUMBER,
[code]...