Forum

Posts

RECENTLY INDEXED PROGRAMMING SOLUTIONS OF Oracle


text datatype  

hi, i can't seems to update the below sql statement because the field 'notes' is a text type. how can i change the sql so that it can be able to update?? thanks UPDATE z_test set notes='' where code ='test'... Continue Reading
Views : 242
Wednesday 21st of November 2012

Connection problems  

Hi, I am having problems connecting to an Oracle database, I have set everything up running against an Oracle 9i db with the client and ODP.Net data provider. I seem to however have problems establlishing connections, they take about 6 seconds to connect before data is... Continue Reading
Views : 288
Wednesday 21st of November 2012

Dropdownlist Databinding  

Sql = "Select CompanyID, CompanyName From tblCompany;" Now this will return the CompanyID and CompanyName. But how do I bind these value (CompanyID as the value, CompanyName is to display to user) to a asp:dropdownlist? Continue Reading
Views : 110
Wednesday 21st of November 2012

Month-Year Select  

A site I'm working has a series of project updates each with an EntryDate column - no problem. I have to create a select box with the following in it: January 2002 February 2002 . . . . December 2004 In short they want to select entries by month-year? How can I do this, I... Continue Reading
Views : 38
Wednesday 21st of November 2012

mySQL 5.0 - release dates  

Hi everyone. Seeing that the alpha version of mySQL 5.0 is out (http://www.mysql.com/downloads/mysql-5.0.html) I'm just wondering if anyone knows when they plan to release the beta version and when they plan to release (finally) the stable (non Beta) version? I've looked at... Continue Reading
Views : 235
Wednesday 21st of November 2012

SQL Installation  

Hey guys, i am installing sql server 2000 on windows xp and its giving me this error at the last step of installation " Setup failed to configure the server. Refer to the server error logs and c:\windows sqlstp.log for more information" this seems to be the place where error... Continue Reading
Views : 41
Wednesday 21st of November 2012

Urgent !! Problem with iBuySpy portal with Oracle 9i  

Hi I'm not able to use Oracle 9i for the iBuySpy portal and am getting this error ORA-04068: existing state of packages has been discarded ORA-04063: package body "GLAST_DP.IBSPO9I_DAL" has errors ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line... Continue Reading
Views : 115
Wednesday 21st of November 2012

.NET Provider installed only on client PC but not on PC with databse server  

Is it possible to access database server thru ADO.NET if .NET Provider is installed only on client PC but not on PC with database server? I think the question is of general database access understanding though the database is SQLBase. Continue Reading
Views : 143
Wednesday 21st of November 2012

ExecuteNonQuery  

Now I'm running into a little problem. Using MS Oracle Provider, ExecuteNonQuery suppose to return an int indicate how many records were effected by a command. Now, I have a stored procedure that executes an update command update a single record given it's key. I passed in a... Continue Reading
Views : 114
Wednesday 21st of November 2012

Intersystems Cache database with ASP.NET  

is it possible to use cache database with asp.net? i cant seem to find any documentation on this. I've tried using odbc on cache v4 with asp.net but it kept giving me error.. anyone got it to work? Continue Reading
Views : 207
Wednesday 21st of November 2012

System.InvalidCastException  

Hi I have upgraded to vs2003. After the upgrade I am getting a new error from code which was working fine before the upgrade.... I am using oracle client..... and when ever I do executedataset I get System.InvalidCastException . Any help .. Thanks Continue Reading
Views : 44
Wednesday 21st of November 2012

why can't insert data into mysql database  

b4 i install mysql5, when i run in mysql4, it's ok. but after i install mysql5 store it in /mysql5 folder but not /mysql, i cannot insert record but can get record from the tables. i just wonder why????? Continue Reading
Views : 441
Wednesday 21st of November 2012

Re: Crystal Reports using Oracle  

Hi, i have been using oracle database for my program for development and everything (commands... connections...) works fine in my classes the problem is, when i try to create a crystal report using the wizard, the connection is valid and i can get the data to display on the... Continue Reading
Views : 217
Wednesday 21st of November 2012

Oracle stored procedure problems  

I'm using this article as reference: http://www.code101.com/Code101/DisplayArticle.aspx?cid=22 Here's what I got: Stored Procedure: -------- CREATE OR REPLACE PROCEDURE ALLBASE.GetOrgOnlyData(OrgCur ?IN Out ALLBASE.PKG_ORGANIZATIONS.cORG) AS BEGIN ?Open OrgCur For Select *... Continue Reading
Views : 94
Wednesday 21st of November 2012

MSSQL vs. MySQL  

Does anyone know which is better performance wise? I have always thought MSSQL was generally better in terms of speed, scalability, and stability, until I found out that MySQL MaxDB supports a lot of new features including stored procedures/triggers + I saw this graph(s):... Continue Reading
Views : 77
Wednesday 21st of November 2012

iskey = false when i use cmd.ExecuteReader(CommandBehavior.keyinfo) mysql myoledb provider  

************* Edited by moderator Adec *************** Inserted missing < code> tags. Always format your code and use tags when including code in your postings. Many readers disregard postings without the code tags. ************************************************** Hello, I... Continue Reading
Views : 217
Wednesday 21st of November 2012

Help creating stored procedures dynamically!  

Does anybody know how to achieve this? I tried using both Oracle and MS ODP.NET even tried OleDB and none of them seemed to work, if i do use sql*plus to compile the procedure it works fine, using the code below doesnt seem to work!! Even tried to catch up some exception but... Continue Reading
Views : 284
Wednesday 21st of November 2012

Casting from OdbcDataReader.getBoolean(...) to Bool !  

Hi Folks, I have successfully set up my db-app using odbc and MS Access...now i am trying to use a MySQL Database. Seems to work fine, but now i am encountering problems with boolean values. I am trying to access boolean values just like with my access db: bool boolVal =... Continue Reading
Views : 133
Wednesday 21st of November 2012

PLS HELP on ...ORA-03114: not connected to ORACLE  

I am getting the following error and I would really appreciate if any of you guys could give an idea of why this is happening. The error is as following: ************************************************************************** ORA-03114: not connected to ORACLE... Continue Reading
Views : 256
Wednesday 21st of November 2012

Limit Users  

hi.. currently i have developed a web site that allow the user to enter the no. of cars they have.. but how i do i limit that each users are only allowed to add 2 cars ? what shud my sql statement be ? and how shud i go about comparing the different user with the limitation... Continue Reading
Views : 44
Wednesday 21st of November 2012

MySql Date Comparison  

Hi all, How can I get the fields where dateField = this; For example select * from tbl_customers where DOB=11/21/1980; Is this a valid way to compare the dates.I'm getting the EOF. Thanking in anticipation. M.Shahzad Continue Reading
Views : 124
Wednesday 21st of November 2012

Server Explorer and MS OLE DB Provider for Oracle  

Hi, I'm having problems creating a new connection in server explorer using this provider. On the 'Connection' tab it asks for '1. Enter a sever name'. Is there some specific format for this?? The server name is 'skynet'. The oracle service name is 'test.skynet'. I've tried... Continue Reading
Views : 125
Wednesday 21st of November 2012

migration from MS access to MySQL  

hi, i've got a fully working site using MS Access as its datasource, with the connection string set up as: "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=c:\inetpub\wwwroot\dissertation\db\db1.mdb" and all as OLEDB connections and commands. Basically what do i need to change... Continue Reading
Views : 33
Wednesday 21st of November 2012

Help with a select statement  

I need to return the following from my db, eg Date User (Count) 12/01/04 23 13/01/04 17 14/01/04 12 15/01/04 9 16/01/04 32 Basically I just need to return a list count of all users that cancelled orders with a specified date range on the given dates. I'm just not sure how to... Continue Reading
Views : 55
Wednesday 21st of November 2012

SYBASE 12.5.1 Data.ASE.Client Challenges  

We have been survigin using the Sybase OLEDB driver on our production .NET application. However, we have been facing errors, specifically Error 4020 when calling a stored procedure with a large parameter list and/or value. As per Sybase Support recommendation, we decided to... Continue Reading
Views : 67
Wednesday 21st of November 2012

Special Characters in Oracle Baan IV  

Hi, I am trying to create an it Data Adapter with the data of ERP BaaN IV that are in Oracle. And that it happens, it is that the fields of Oracle have special characters ($) and with that it Data Adapter it doesn't work. Below it is a sql: SELECT A.T$CPRJ AS PROJECT ,... Continue Reading
Views : 61
Wednesday 21st of November 2012

Oracle 10g with MS ODP  

Just wondering if anyone has tried using Oracle 10g with MS ODP. Is it compatible ?? Continue Reading
Views : 154
Wednesday 21st of November 2012

How to display user's name once they login  

Hi,can someone show me example how to check the user's name and diplay it once they login (mySQL & asp.net) Thnx Continue Reading
Views : 98
Wednesday 21st of November 2012

storing search results in a table  

Hi, I am trying to insert the criteria the user and search info into another table. I am using the einfodesigns mysql driver. I get this message when I try to do this: Compiler Error Message: CS0117: 'eInfoDesigns.dbProvider.MySqlClient.MySqlDataAdapter' does not contain a... Continue Reading
Views : 183
Wednesday 21st of November 2012

SELECT TOP Problem  

I want to select second part of 20 to rows of a database. I write this SQL Command : SELECT TOP 20,10 * FROM Marks But it is not work ! what is my fault please? Continue Reading
Views : 54
Wednesday 21st of November 2012