I'd like to test Oracle database connection via web service. Could I create Oracle database in MS development environment? Oracle version is 10.2... is it Oracle 10g. I'm familiar with MS SQL Server. Oracle is new for me.
View 1 Replies
Until recently I have been using net 2005 with distributing an app which uses an access database with getting data using recordsets
I decided it was time to upgrade so I got net 2010 & started using ADO.net with a dataadapter.
To my dismay I have found that my app will not run on all platforms, ie XP, Vista 32 & 64 bit, Windows 7 32 & 64 bit From another question I have been told
"If compiled to target AnyCPU, your program will fail to run in an x64 environment if it utilizes any ODBC database driver. In this case, you must compile it to x86. Therefore, x86 is safer than AnyCPU."
Which I have found to be correct I am not familiar with all the options to open a database & the respective code required to extract/change the database data. I also don't understand the implications of using x86 cpu instead of any CPU
MY net 2005 apps have been working fine for the last 6 years (until W7 64 bit), so I want to develop an app that has the same lifespan without having to make variations to the build for specific platforms
I would like the answers to the following:
1. is x86 the new standard for specifying cpu & works on all platforms?
2. why does W7 64 bit have a windows & windows x86 system folder
3. why does my installer when "any CPU" is specified install it in the x86 system folder (W7 64 bit, even though the app fails when trying to open the database as outlined above)
4. which method of opening an access database is preferred which works on all platforms with a common cpu specified?
I have a interesting problem: Where I work we've built a home-grown ERP system in VB6 that we are slowly moving over into vb.net. There are some projects have are in .net: we have a hand-held C# project that uses a web service to talk to our database, I've built some reporting screens using Crystal and some smaller maintenance screens.
Well as we have been plotting the conversion out, we want to have a way to separate our business logic and UI so that the UI can be a win/web form or a Smart Device project. Is this even possible? I try to reference the DLL in a test I have and it gives me this error when trying to debug using a emulator Deployment and/or registration failed with error: 0x8973190e. Error writing file '%csidl_program_files%smartdeviceproject1system.windows.forms.dll'. Error 0x80070070: There is not enough space on the disk.
I want to create a RTSP/h264 video stream from static images, and incorporate it into my .NET application. So far I have found two possible ways to do this:
Use ffmpeg/ffserver, but I would need to compile ffserver on windows and then rely on it... and I don't necessarily want to rely on an external application
Use the LIVE555 [URL] library, but they do not have any .NET libraries, so I would need to spend some effort to make it work with the rest of my .NET application.
Can you comment on either #1, #2, or which is better. Is there a faster way to bring up a RTSP server in .NET? I do not mind putting in development time if there is a solid solution that takes time, but it would be good to have something we can work with fast, for prototyping and demos.
I have a table hasn't primary key in oracle 10g and I need to add autonumber to table and use this autonumber in vb.net 2005 to control in update ,delete command in vb.net
View 4 Replieshow i create an autonumber in visual basic statement for an oracle database??
View 1 RepliesI want to create Table in Oracle database from my asp.net application by using ado.net
View 1 RepliesSo I made a simple patform game where the player has to jump quickly while the platforms move to the bottom of the screen, as to not touch the bottom of the screen. But, I need to know how to create a loop to loop the locations of the platform. This means that after twenty or so platforms, the same platforms come up again, so that the player will have an "endless" game. I've declared all the platform's locations relative to the location of the first repeating platform:
[Code]...
Today is my first day trying to use Oracle databases in Asp.NET so I have no idea of what I need to do. I have added this code
[Code]....
I would like to change the Name of the oracle Db. How can i change it.if i change the database name what are the things i have to keep in mind.Will it Affect any system files or oracle dll files if i create wrongly.Will the name of the Db be same for all the Oracle 9i s/w?
View 1 RepliesHow can i take back up on Every minute and hourly and complete whole day backup using VB.NET i.e i want to know the coding example
View 5 Replieshow can i take backup on Every minute and hourly and complete whole day backup using VB.NET i.e i want to know the coding example.
View 11 Repliesi have problem on how to insert the data into the oracle database 10g using visual basic 2008
My coding is like at below:Dim cmd211 As OleDbCommand
cmd211 = New OleDbCommand("INSERT INTO STUDENT_DETAIL(STUD_ID,STUD_NAME) VALUES(@STUD_ID,@STUD_NAME)", con)
.Add("@STUD_ID", OleDbType.VarChar).Value = txt_studId.Text
want to know how to connect database from window2008 server platform to ibm aix database is oracle 10g ..please anyone can help me here
View 2 RepliesI developed an application with old VB form and binding the data from Oracle database into VB form. Actually, I tried to bind the data more than 35000 records in to grid. But, it takes more than half an hour and also form was hanged and there is no output. Can you please let me know the solution to fix it and bind the data without any hang in my application. What are the steps to be followed to fix it?
View 1 RepliesI have some deprecated code in visual basic when connecting to an oracle database. I am using a OracleDataAdapter but it says that this has been deprecated. Does anyone know what the new supported code is to connect to a database?
View 2 RepliesI've been viewing the tutorial at [URL]...08-088541.html but I'm still having issues creating my connection to our Oracle database. Here's my code, which uses the same connection string as one of my VB6 programs (no password required for database--Oracle picks up windows name) :
Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Create connection object
Dim OraDB As String = "Data Source=databaseneme;Persist Security Info=False"
Dim conn As New OracleConnection(OraDB)
conn.ConnectionString = OraDB
conn.Open()
Me.Show()
End Sub
I've been using .NET for all of 10 mins so the error may be painfully obvious!
I am creating a Reporting program in VB 2008. The first issue that I want to correct is in VB 2008 there is a Database Explorer. But whenever I try to create a new Data Connection in the Database Explorer it does not give me the option to connect to Oracle. How do I get my Oracle Database in the Database Explorer tab. All it gives my options for are Microsoft based database applications.
View 3 RepliesI have this in creating table but did not work. Having invalid table name error.
Imports Oracle.DataAccess.Client
Imports Oracle.DataAccess.Types
Public Class dump
[code]......
I want to update a particular row in the database table but no success,i keep on receiving this error One or more errors occurred during processing of command. ORA-00907: missing right parenthesis
Cmd = New OleDbCommand("UPDATE SUB_DETAIL SET (LECT_ID = " & TextBox3.Text & ") WHERE SUB_ID = " & cmb_subID.Text & ")", con)
con.Open()
[code].....
If the following is my code in VB6 to connect to Database (Oracle 8i) then what would it be for VB.Net (VS 2008)....?
[Code]....
I am reading a csv file in to a datatable in vb.net and making a few checks and appending an extra column. I then want to perform a bulk insert using microsofts Oracle.DataAccess (no choice in this) to an Oracle database. what would be the best way to perform this as there is no bulkImport like in SQLserver.
View 2 Repliescan you tell me,how can i add a provider for oracle(Microsoft Provider oledb for oracle).Actually i had Microsoft ODBC for oracle but i want to add a provider above mention.
View 2 RepliesI have written a rather complex dll for processing a large volume of data (~4,000,000 records) from an Oracle database. It works well, but takes about 23 hours to run.Since I wrote the code fairly compartmentalized I realized that there are 6 routines that should be able to run concurrently, and I have a multi core processor,I decided to try my first multi-threaded implementation.
In the routine I am working on I am doing no I/O everything is in memory in variables. My data is already in dataTables and hashTables. Most of the data is defined as private in the class scope, but no conflicting updates should happen because the code segments works very distinct portions of the dataTables.The concept is simple, I have 2 routines that need to complete before launching my threads, and one routine that needs to run after all of the threads have completed. Here is what I am trying;
ProcessDXDate()
ProcessHistology()
aryThreads(0) = New Threading.Thread(AddressOf ProcessLaterality)[code].....
Well for some reason when i try to add a reference so that the oracle database can connect to the VB.NET 2010 program.In other words it shouldn't highlight certain code as if the database is not connected.Here is a clear summery as best as i can say what the problem is.
1. Connection from Visual Studio 2010 to Oracle plus server
2. Adding References will not be allowed for some reason.
3. The code (See example below on what it might be) is still highlighted even when i added the references several times.
I'll show just a small snip of the code coz it's more or less the same on most of the forms if i want to either update, delete, add or amend to the database. I'll show a few screenshots so to be clearer.I've tried by even looking over the notes and followed step by step and nothing works.Since i am not registered in this module this time i can't seek help of the lecturer so don't bother telling me to go and ask my teacher I've pestered the supervisor that i'd have to present this project to and she hasn't replied to my email at all so i have no clue what else to do in the matter.
Im writing a simple VB program that connects to an oracle DB which retreives and inserts data to a table I created.[code].....
I want to be able to search through a table I have created to store all the information.Rather than just searching for one variable which would be easy to do, I want to give the user the option to filter out the search from the form.So say the user hits "Find", they would be given access to 10 comboboxes, they would select the information they want to search for (They do not have to select every box) and then click "Do Find".Then the form would display all the results of the query in the form.
how can i import a Excel sheet Data into my oracle10g Database using vb.net coading..
View 1 RepliesI am trying to insert date and time in dtime column in oracle database by using this code but it gives me following error ORA-01830 date formate pictures ends before converting entire output.
[Code]...
A VB.net program reads the queue and calls a stored proc in SQL Server that processes and then inserts the message into another SQL Server table and then deletes the record from the oracle table.
We use a DataReader to read the records from Oracle and then call the stored proc for each of the records. The program seems to be a little slow. The stored procedure itself isn't slow. The SP by itself when called in a loop can process about 2000 records in 20 seconds. But when called from the .Net program, the execution time is about 5 records per second.I have seen that most of the time consumed is in calling the stored procedure and waiting for it to return.[code]...
I am trying to open an Oracle database connection in vb.net 2008 in order to issue a Select statement and the populate a listbox with it.
My code is as follows:
Dim orclstr As String = _
"Provider=OraOLEDB.Oracle;" & _
"Data Source=10.0.0.77;" & _
"User ID=myuser;" & _
[code]....
Obviously, I am doing something wrong, but I can't figure out what.
