Forum

Posts

RECENTLY INDEXED PROGRAMMING SOLUTIONS OF Oracle


Problem with NULL fields  

when I retrieve data from MySql if one of the fields is null the rest of the rows in the same column get null values, I dont know why. i use Microsoft Visual Studio 2002 mysql-4.0.20d-win mysql-connector-net-1.0.0-beta.zip Continue Reading
Views : 110
Wednesday 21st of November 2012

View Oracle SPs, FNs or Packages code in C#  

Hi All, I'm writing a utility similar to TOAD and would like the users to select SPs, FNs or Packages and be able to see their code. Is there a way to do this? How does Toad or similar utilities do it? Same thing with Tables, is there a way to find out which columns are... Continue Reading
Views : 67
Wednesday 21st of November 2012

ASP.NET site with MySQL Database Backend  

Hi Has anyone tried or tested out designing a asp.net website that use a MySQL Database. If you have is it anygood. Matthew Continue Reading
Views : 53
Wednesday 21st of November 2012

The OracleParameter is already contained by another OracleParameterCollection.  

I have the following class method: Continue Reading
Views : 596
Wednesday 21st of November 2012

ODP.NET : VB.NET and PLSQLAssociativeArray, hanging webserver  

Hello, I'm trying to use a PLSQLAssociateiveArray as output parameter using the examples from the ODP.NET client distribution, but when i call ExecuteNonQuery(), the webserver hangs. Regards, Joost Evertse Here is the code: ----- VB.NET code ----- Try con.Open() cmd = New... Continue Reading
Views : 217
Wednesday 21st of November 2012

Connecting to Oracle  

Hello There, Can someone provide me with enough information to connect to Oracle DB, I have been using SQL Server in the past. Do i need to download Oracle Oledb Provider? If yes, can you please provide me the link. Also, can you please give me the sample code of connection... Continue Reading
Views : 167
Wednesday 21st of November 2012

Visual WEB Developer 2005 connection to MySql  

Dear Supporters, Is it possible to connect Visual WEB Developer to a MySQL dabatase? I have installed MyODBC and also the .Net connection beta. I am relaly new to using MySQL, so please help. Best regards, Thomas. Continue Reading
Views : 132
Wednesday 21st of November 2012

How do you call oracle stored procedure w/ OLEDB  

I'm new to ASP.NET, and I'm having a hell of a time finding out how to call an Oracle stored procedure. I have been able to run my SQL directly in my ASP code, but now I want to take the next step. I've been using OLEDB to connect to an Oracle9i DB. Would someone please post... Continue Reading
Views : 331
Wednesday 21st of November 2012

how to connect to oracle  

To connect to oracle database I need to use System.Data.Oledb or is there another class available for Oracle only thanks Continue Reading
Views : 167
Wednesday 21st of November 2012

error BC30466: Namespace or type 'OracleClient' for the Imports 'System.Data.OracleClient' cannot be found  

Hi all, i'm a new here. i found that the titled error occurs when i browse the page. following is a part of the source: sub Page_Load(Sender as object, e as eventargs) dim OracleConn as new OracleConnection("Data... Continue Reading
Views : 120
Wednesday 21st of November 2012

Excel PageSetup Problem  

I got this error from trying to access the MS Excel PageSetup class: System.Runtime.InteropServices.COMException (0x800A03EC): Unable to get the Zoom property of the PageSetup class at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object... Continue Reading
Views : 327
Wednesday 21st of November 2012

Building login page using ASP.NET and MySQL  

Do anyone know where can i download free source code on building a complete login page using ASP.NET with MySQL (ODBC connector). Or do anyone know what code should i put so that in adding new member into my database(via login page), the system will check if the new member... Continue Reading
Views : 47
Wednesday 21st of November 2012

how "register" MySQL .net connector  

Hi there! I'm trying to use the MySQL .net connector to connect to a MySQL database, however, the line: fails: The type or namespace name 'MySql' could not be found (are you missing a using directive or an assembly reference?) I guess I have to register the MySQL.net... Continue Reading
Views : 195
Wednesday 21st of November 2012

mySQL connection string  

Hello, I need to connect to a mySQL database from my ASP .NET project. I have two questions first though that I need to know: #1. Can I just use ODBC objects to access the mySQL database? #2. What should my connection string look like for the database? Thanks!! Continue Reading
Views : 157
Wednesday 21st of November 2012

Using Visual Studio's wizards with MySQL  

I'm getting errors trying to use Visual Studio's wizards to add an ODBC Data Source. I get the same errors for both MySQL ODBC and SQLite ODBC. Both ODBC's work fine when accessed by other clients. One or more errors occurred while processing the following database... Continue Reading
Views : 69
Wednesday 21st of November 2012

ODP.NET: Function call with VARCHAR2 return value cause ERROR  

Hi ALL , I am unable figure out the following problem.I am using VB.NET with ODP.NET 9.2.0.4 to access ORACLE 8i Database Server. While I am trying to call an Oracle function which returns a VARCHAR2 at the time of ExecuteNonQuery it generates the OracleExecption(... Continue Reading
Views : 133
Wednesday 21st of November 2012

The type or namespace name 'OracleClient' does not exist in the class or namespace 'System.Data'  

I am using notepad to code my ASP.NET pages. Line 3: using System.Data.OleDb; Line 4: using System.Web; Line 5: using System.Data.OracleClient; Line 6: Line 7: public class OConn . . . Source File: c:\inetpub\wwwroot\Oracle8.cs Line: 5 I know if I precompile the *.dll in my... Continue Reading
Views : 235
Wednesday 21st of November 2012

Installing ODP.net Docs into .Net Framework Help  

Does anyone know how to go about installing the ODP.Net Help files into the .Net Framework help system? I know it just works with Visual studio. It seems i may need to generate a HxI file for the system. I have no idea how to go about this. Continue Reading
Views : 232
Wednesday 21st of November 2012

Problems connecting to database using Web Matrix  

How do I connect to a Foxpro .dbf using the Simple Data Report in Web Matrix ? The following code works in Foxpro:STORE SQLCONNECT('vfpdbf', 'sa') TO gnConnHandle SELECT Firstname, Lastname, Address, City, State ; FROM 'CUSTOMERS' ; WHERE Alltrim(upper(lastname)) =... Continue Reading
Views : 177
Wednesday 21st of November 2012

Database lock  

Hi, I need to use locking for an edit page , For example if two users request the same record to edit, after the first user clicks edit the record should be edited, but when the other user clicks edit i should show him an error message. Thanks Continue Reading
Views : 48
Wednesday 21st of November 2012

SQL Query  

if i would like to select a record that exist in one table and not exist in another table i tried to use minus statment but SQL doesnt recognized it any help the primary key is combination of 3 fields Continue Reading
Views : 58
Wednesday 21st of November 2012

SQL Update  

Hi all - I hope I have put this question in the correct place. I am currently attempting to preform an update on an SQL database based on the click of a button. I have already established a connection to the database using DreamWeaver and have performed a select statement to... Continue Reading
Views : 104
Wednesday 21st of November 2012

ASP into MySQL  

All, I am new to all this, so please be patient with me. I have established a connection with my MySQL database using ASP, but now I want to get data into the database via an .asp form. The connection code I have inside regForm.asp is: What do I need to do to have data... Continue Reading
Views : 38
Wednesday 21st of November 2012

PL/SQL Query help ( Replace NULL with 0 )  

Hi, I have a Sql query that returns null when there is nothing in the database. I want this query to return 0 whenever NULL is expected to be returned. How can this be done ? Thanks, Continue Reading
Views : 77
Wednesday 21st of November 2012

Uppercase check constraint  

I have a field that i want to have a value of only M or F. I thought that this would work but I get uppercase is an invalid identifier. "UPPERCASE" is whats used in oracle isnt it? gender VARCHAR2(1) NOT NULL CONSTRAINT gender_ck CHECK (gender IN UPPERCASE('m','f')), Tom ... Continue Reading
Views : 60
Wednesday 21st of November 2012

Select Statement with Dates  

I'm having an interesting problem here hopefully someone can get me straightened out. I am going against an oracle db and I am writing a report in report services. In my report I prompt for a starting and ending date and it seems to work when I specify 01/01/2005 through... Continue Reading
Views : 25
Wednesday 21st of November 2012

HELP ME PLEASE  

I IMPORT NAMESPACE System.Data.OracleClient in my web-page I see that in classes-browser but when i process the page i received an error message. I wrote the following code : Sub Button1_Click(sender As Object, e As EventArgs) --->> Dim conn As New... Continue Reading
Views : 446
Wednesday 21st of November 2012

spacing sql  

I am wondering if there is a way I can change an sql statement in order to have spaces in it. I am using vb.net and an oracle database this code workssql = "SELECT SERVICED_AREA, SA_NUM, POPULATION_SERVICED from... Continue Reading
Views : 93
Wednesday 21st of November 2012

Paging via Oracle  

Hello,??? I come from a MS SQL Server background and always used paging in a stored procedure describedhere. Now I want to do the same with a stored procedure in Oracle - However I am already failing... Continue Reading
Views : 87
Wednesday 21st of November 2012

Possible  

Is it possible to call command in as400 database and get results(ResultSet or scalar)?from itThanks Continue Reading
Views : 25
Wednesday 21st of November 2012