Search results matching tags 'Oracle' and '.net'

Re: error: 26 - Error Locating Server/Instance Specified

shantanu.gupta — Sun, 13 Dec 2009 05:00:00 GMT

Here is the resolution to error 26. Check this video to configure your error. It was a real headache for me for a long time. But this worked.

http://techpint.com/programming/error-26-%E2%80%93-error-locating-serverinstance-specified-sql-server

Re: Data provider for Oracle?

thakkarnimesh — Thu, 15 Jan 2009 05:00:00 GMT

This redirects me to Oracle Data Access Components, which I mentioned earlier.

I have already installed this but stuck in executing the scripts which is the last part.

When I execute the script one by one from Oracle XE interface, it ignores the statement where other script is referenced.

How can I execute all the scripts at one go? OR, how do I run the script that the referencing statements are not ignored.

Learning from others

Infinite_Recursion — Tue, 12 Aug 2008 04:00:00 GMT

I was not sure of where to post this. I am not sure of how appropriate the title is, but here goes:
The main focus of my post is to get a broader idea of current technologies. Taking a peek at non-Microsoft Technologies, I played a bit with JDeveloper and ADF. I have to admit that I noticed features that are not matched in the Microsoft realm of development tools and approaches. The whole framework is something else. I mean ADF is obviously targeted at business applications, and I as an ASP.NET developer have to develop Business Applications all the time. But ASP.NET does not have those cool things that ADF + JDeveloper + (add what you see fit here since I am not an expert ) have.

Why don't Microsoft start heading in the right direction? I know that they are working on MVC, and some other things like ASP.NET Dynamic Data, but I am not sure that this is enough. When working with .NET technology, it always feels like we have this big puzzle that we must figure out. We have to get a tool from here, and a whole other framework from their, and some hacks from somewhere else and finally glue all these things up. And after things start working, you notice that you are like the only one that knows how the pieces fit together, thus inducing a very steep learning curve.

I am starting to feel jealous when I notice how other developers that work on JDeveloper, are able to build a whole business application without having to write much code. Everything (almost) is done deceleratively. OR Mapping, they have it; MVC, already there; smart IDE that has tons of wizards, granted. In ASP.NET (.NET in general), we need something like NHibernate for OR Mapping, messing around with the BETA MVC framework for MVC, and have to get third party controls or even build our own to start feeling that we are developing smarter.

I wish Microsoft can learn from others, I might even start learning that Oracle technology cocktail.

Select statement for arabic data not working!!

cpcdafoor — Mon, 28 Jul 2008 04:00:00 GMT

Hi,

In my asp.net code, I am trying to retrieve some data from an oracle database using a select statement that includes an arabic string (see in green). The select statement is as follows:

select * from T_GOG_PHONEBOOK where afl_name like '%عبدالله جابر%' and rownum < 50

For some reason, I don't get any results although, using the same select statement in SQL Navigator, I do get the needed results. The character sets in the database are WE8ISO8859P1 and AL16UTF16 for NLS_CHARACTERSET, and NLS_VCHAR_CHARACTERSET respectively (i cannot change them!).

What could be the reason behind this? Here are some things I tried:

changing the locale! (I don't know if what I did was right. I think not)
changing Oracle NLS_Lang in the registry (again, just trial and error)
encoding the string in my code. ?!?!

Please help me in this issue. It's been weeks :(

Regards,

How to make a oracle package call and receive the return values as dataset

kabir.khan.net — Tue, 12 Feb 2008 05:00:00 GMT

Here is My Problem, I have a complicated login porcess, there are two seperate databases involve in it. Firstly, I will search the userid in the local sql server 2005 database, if not found I will call an oracle package which is being develop by a third party(none comercial) and that package will verify the userid and password and return me user's present credentials (rolse, orgs, etc) as dataset. My question is how do a call that oracle package from asp.net application and how do a recieve a oracle dataset or cursor at the asp.net. Sorry if i wasnt clear. I really do need help on this, any help will be appreciated.

I will like to use ODP.net if at all possible.

Thanks

Kabir

Re: Converting Now date to Oracle's whacky date

ratnamadhuri — Fri, 14 Dec 2007 05:00:00 GMT

Date.Now.ToString("yyyy-MMM-dd")

doesnt make sense but works.

You can also try Date.Now.ToString("dd-MMM-yyyy")

universal function to convert any oracle date to .net date

to_char(doe,'MM-DD-YYYY HH24:MI:SS')= '" & doe.ToString("MM-dd-yyyy HH:mm:ss")

(doe is of type date)

The format of the second parameter for oracle date function should match the format of the parameter for the .net function.

example shown below

Public Sub updatedate(ByVal number As String, ByVal doe As Date, ByVal username As String)

Dim query As String

Try

query = "Update tablename set date1 ='" & Date.Now.ToString("yyyy-MMM-dd") & "',username= '" & DatabaseConnections.Username() & "' where id= " & number& " and user_id='" & username & "' and to_char(doe,'MM-DD-YYYY HH24:MI:SS')= '" & doe.ToString("MM-dd-yyyy HH:mm:ss") & "'"

Dim cmdupdate As New OleDbCommand(query, dbcon.opendatabaseconnection())

Dim i As Integer

i = cmdupdate.ExecuteNonQuery()

If (i > 0) Then MessageBox.Show("Task completed")

Catch ex As Exception

MessageBox.Show("Error in updatediarycompletedate() " & ex.Message)

Finally

dbcon.closeconnection()

End Try

End Sub

A call to the above function will be like

databaseconnectionsclassfileobject.updatedate(8000, datetime.now.date, username)

Character mismatch exception while using "SQLDataSource" for "GridView" updating Oracle Data Base

avais2006 — Sat, 23 Jun 2007 04:00:00 GMT

i creat connection easlly and fatch data from oracle and delete also easlly uisng "SQLDataSource" for "GridView" accessing Oracle Data Base but when i wish to do "UpDate" it give me the execption "System.Data.OracleClient.Oracle Exception:ORA-12704:Character Set MisMatch" and application crashed

Please if any one know how to solve

Re: OracleTable to C# Class

opethema — Wed, 13 Jun 2007 04:00:00 GMT

i have developed this tool myself!

thanks for no help.

Transfer Data from Oracle to SQL

systima — Thu, 07 Jun 2007 04:00:00 GMT

Hi,

I am new to Oracle and SQL and I want to transfer data from Oracle to an SQL table. Would it be better to look into doing this using a DTS package or writing a c#.net program to do it?

Thanks.

How to write Commit trasction

vijaya123 — Sat, 02 Jun 2007 04:00:00 GMT

Note from moderator XIII : this message was moved from the Oracle forums:

i have create Business logic layer

i want to implement begin transaction

commit transaction.

if data is not properly updated -> Rollback trasaction

thank you

vijaya@jyothy.com