80 Topics
 | |
 | **ChatGPT has had lazy days before, but this week’s performance marks an unprecedented low. Here’s why many ChatGPT Pro users are canceling their subscriptions – and even more might follow.**  Yes, complaints about ChatGPT being lazy have been around for as long as the LLM itself. I have written … |
| | In China, many manufacturers are 'replacing IOE' and are moving closer to open source databases.openGauss is an open source database developed by Huawei itself. Although there is policy support,but ，Oracle has always been ranked first in DB-Engines Ranking. So, do you think openGauss database can replace Oracle database?  |
 | # Introduction # As we move into 2022, businesses will continue to look for ways to become more data-driven. This means that knowing how to use Structured Query Language, commonly called SQL or 'Sequel', will remain an essential skill for data scientists, analysts, and developers. In this post, we'll provide … |
| | Dear sir, i got a TFT device attendance 3.5 inch and iam using SDK 6.2.4.11 iam using windows 10 LTSC Enterprize 64 bit when running , i created a windows service on it when i try to run it, it does not work and cause an error 1053 :Error 1053: … |
| | 1. Crystal Reports SAP Crystal Reports is known as a robust production reporting tool. With SAP Crystal Reports, you can create powerful, richly formatted, dynamic reports from virtually any data source, delivered in dozens of formats, in up to 24 languages. SAP Crystal Reports turns almost any data source into … |
| | I wan to call oracle database function I tried this but i am getting error `ORA-06550: line 1, column 7: PLS-00221: 'F_GET_DESC' is not a procedure or is undefined ORA-06550: line 1, column 7: PL/SQL: Statement ignored` public void Get_Desc() { string oradb = "Data Source=source;User Id=myuser;Password=ss;"; string CommandStr = …  |
 | We have a WCF web service hosted on Windows 2008 SP2/IIS 7 accessing an Oracle database. Usually data access works fine but during load testing, it often times out and logs an exception saying: Error occurred when processing XXXXXXXX Web Service Oracle.DataAccess.Client.OracleException Connection request timed out at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection … |
| | Hi guys. I am looking for a software tools that can analyse data from several sources like databases: Oracle,Mysql,Access,MsSql e.t.c and draw graphs,dashboards or other data visualisation objects. The software should also be able to read excel sheet and analyse the data and give output in variuos graphs/pie charts. It … |
 | 'database connection class file '------------------------------------------------------- Imports Oracle.DataAccess.Client Imports System.Data Public Class DataBaseConnection Private con As New OracleConnection ReadOnly Property connection() As OracleConnection Get Return con End Get End Property Sub New() con.ConnectionString = System.Configuration.ConfigurationManager.AppSettings("DBconnection") con.Open() End Sub Sub closeConnection() con.Close() con.Dispose() End Sub End Class '////////////////////////////////////// 'staff class file '-------------------------------------- …  |
 | ***Please don't post "spam" or "Thank you" posts in this thread since this is meant to be used as a guide for all beginners and I am sure we would like it to be on topic. I hope you understand this.*** **» Introduction to Java «** To start off, [Java](http://en.wikipedia.org/wiki/Java_(programming_language)) … |
| | I'm somewhat new to deploying ClickOnce manifests, first off. I know the basics of how to publish to an app server, which then lets every use the newest version (after setting to check for updates before running the application). We have multiple VB.Net applications stored on our app server, that … |
 | hello, i want to ask why my function cant be called here's the function create or replace function hitung_denda (idPinjam number, tggl varchar2) return number is denda number; tgl1 date; tgl date; begin select tgl_batas into tgl1 from peminjaman where id_pinjam=idPinjam; tgl:=to_date (tggl, 'MM/DD/YYYY'); if tgl>tgl1 then select (tgl-tgl_batas)*1000 into … |
 | The world's largest technical support, software and hardware companies use Linux on a daily basis for a variety of tasks and solutions. This post gives you an overview of all the ways in which large companies use Linux. Most don't use Linux on the desktop but do use it in …  |
| | I had c# application that has registration form and another from that user use to sigin in into my application i wonder how to check if user its register or not my login form has to textbox username and passpwrd and im trying this code i gusse its wrong can … |
| | hi all I had make this samll method to insert data from c# forms into my oracle database the code processed fine but when I go to sql developers software to check if the record has been inserted or not I found nothing... so whats wrong with it please thanks … |
| | hi I am trying to save multiple images into one ID and I am getting no where ...I am posting the code so for storing and retrieving image (one image)...but need to store more than one ....need some help here ... using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using … |
| | Ok, here is one that we are strugglling with to find a potential source of "slowness" (as defined by the users). We have 4 staff that have new, Windows 7 machines connected to a Cisco 3750 Access Switch (connection is 1 GB, and connected through a Cisco 7975 phone). Connections …  |
 | [url="http://../tutorials/tutorial6028.html"]Original thread [/url]- To see why this was Updated [i] Reason for new thread is to start with a clean slate and I will also be providing a tutorial for SQL and possibly Oracle DB connections to show how easy this code is to implement regardless of the DB you … |
| | I made c# asp.net web form application with visual studio 2008 with oracle 10g database using Oracle.DataAccess. When I start debugging or start withoutdebuggin from visual studio, it workd fine. (visual studio and oracle 10g server and client are installed in my pc). I publish the application and use ftp … |
| | I used following code to connect oracle database from C#. But i get this error "**invalid login credentials**" using (Oracle.DataAccess.Client.OracleConnection cn = new Oracle.DataAccess.Client.OracleConnection("Data Source=abcSource;User Id=abcUserId;Password=abcPassword;") { cn.Open(); } While if i try following code to connect database from C# I succeed. using (System.Data.OracleClient.OracleConnection cn = new System.Data.OracleClient.OracleConnection("Data Source=abcSource;User Id=abcUserId;Password=abcPassword;")); … |
 | Hello, I have been struggling a little bit with an issue in a relational database that supports queries. Originally I was going to use an OleDB data adapter and connect to an Microsoft Access database (created with Access 2000). The problem is that when I use a connection string like: …  |
 | ** Please help me debug the code, I am experiencing error in this part: cmd.CommandText = "select ROUND(((date_from - date_to)/30),0) as months from rental where tenant_id = '" & Me.TextBox9.Text & "'" cmd.CommandType = CommandType.Text It says: Error while retriving record on the table.. There is already an open Data …  |
| | Please help me debug about datetimepicker. I think, the code is written correctly but its not. The program kee[s prompting **ORA-01858: a non-numeric character was found where a numeric was expected** Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Dim cmd As New OleDb.OleDbCommand 'cnn.ConnectionString = … |
| | **PLEASE HELP ME. THIS CODE WILL RETRIEVE THE SEQUENCE YOU MADE. AND WILL OUTPUT IN THE TEXBOX IN THE NEXT FORM. BUT MY PROBLEM IS THAT IT DOES NOT RETRIEVE/GIVE THE GENERATED SEQUENCE. FOR SHORT NO OUTPUT T__T . PLEASE HELP.** Public Sub getJO() Dim oradb As String = "Provider=OraOLEDB.Oracle; …  |
| | **THIS CODE RETRIEVES DATA FROM THE DATABASE. PLEASE HELP ME DEBUG. I AM EXPERIENCING ERROR CALLED INDEXOUTOFRANGE IN: ** **HERE IS MY CODE:** Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click 'Try Dim oradb As String = "Provider=OraOLEDB.Oracle; Data Source=TRAVELMATE-PC/XE;User Id=cj;Password=me;" Dim conn As New OleDb.OleDbConnection(oradb) …  |
 | Hi, i'm a newbie and get stuck with this problem for a few days. I have datatable with two column, line and duration. I want to sum the duration based on the line group. For example: LINE DURATION A1 00:05:20 A1 00:07:00 A1 00:02:10 A1 00:01:50 A2 00:02:01 A2 00:03:45 … |
| | Below is my scripts: <% connstring ="Provider=MSDAORA;Data Source=(DESCRIPTION="&_ "(ADDRESS=(PROTOCOL=TCP)(HOST=cqcmdb1.corp.mot.com) (PORT=1521))"&_ "(CONNECT_DATA=(SID=CQPD2)));User ID=report_ccmpd_ro;Password=report" set con = server.CreateObject("ADODB.Connection") con.open connstring set conn = server.CreateObject("ADODB.Connection") conn.open connstring sqltest = "select T1.screen_failure, DBMS_LOB.SUBSTR(T1.ROOT_CAUSE_ANALYSIS,9000,1) AS RCATT from Submission_Record T1 where T1.dbid <> 0 and (T1.Headline like '%[O2O7]%')" set rs=server.createobject("adodb.recordset") rs.open sqltest ,con,1,3 sqltestonly = "select … |
| | guys - i cannot figure this one out. i keep getting the "wrong number or types of arguments in call" error & for the life of me can't figure out why. i've got dozens of other programs doing way more difficult stuff than this so, i'm officially stumped. 4 parameters … |
| | Run time error 3251 Current Recordset does not support updating, this may be a limitation of the provider, or of the selected Locktype Friends, I have a VB application that is using Oracle backend database. My code is as below but returns the above error when I try to add …  |
| | Any commands for creating database using oracle command? as well as creating tables? I have this in creating table but did not work. Having invalid table name error. [CODE] Imports Oracle.DataAccess.Client Imports Oracle.DataAccess.Types Public Class dump Dim conn As New OracleConnection Private cmd As OracleCommand Private da As OracleDataAdapter Private … |
| | Proper way of doing this? Please disregard some variables. [CODE]Imports Oracle.DataAccess.Client Imports Oracle.DataAccess.Types Public Class Addcage Dim conn As New OracleConnection Private cmd As OracleCommand Private da As OracleDataAdapter Private cb As OracleCommandBuilder Private ds As DataSet Dim roomprice As Integer Dim roomtitle As String Dim lubid As String = …  |
| | [B]My project is Housing reservation system for University I design the interfaces by VB and connect to my oracle data base account Oracle 11g, VB express edition are used The proble is with the login form [URL="http://im20.gulfup.com/2011-12-23/1324652639153.png"]http://im20.gulfup.com/2011-12-23/1324652639153.png[/URL] when I debug and enter the ID & password for User : according … |
| | Hello everyone, I'm working on a little project that use c#, Oracle ODT and asp.net, so, my problem is that i dont know how to convert or store the data retrieved from a sql that is a sequential and then use in other query in the same project. This is … |
 | Hi Experts: When i run this page on my online website with mysql (already with Oracle), this errors orrurs. Exception Details: System.Data.OleDb.OleDbException: [1]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'exec print_pack.check_print … |
 | I need a little help connecting to an oracle database. I keep getting this error: Data provider internal error(-3000) [System.String]. [CODE=C#] using System; using System.Collections.Generic; using System.Linq; using System.Text; using Oracle.DataAccess.Client; using Oracle.DataAccess.Types; namespace OrcaleTest { class Program { static void Main(string[] args) { string connectionString = "user id=travus;password=password;data source=127.0.0.1"; … |
| | Hi Can you please let me know if I execute several sql query with one open connection? For example if I have a code like following: [CODE] using System; using System.Data; using Oracle.DataAccess.Client; class OracleCommandSample { static void Main() { string constr = "User Id=scott;Password=tiger;Data Source=oracle"; OracleConnection con = new … |
| | Hi Guys, I am trying to make a connection with Oracle 11g which is installed on a server 2008 BUT have problems with the ConnectionString. Could you please let me know how I set a correct connection String while I have parameters like these: Database name: GISData Server Name : …  |
| | I have problem with printing Crystalreports from Dataset as a source. I have a Dataset fullfilled with data from query and CrystalRaports doesn't show any data from dataset on the report. Do you haeve any ideas what is the problem. My Code: [CODE]using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; … |
| | Hi Guys, I am trying to make a connection with Oracle 11g which is installed on a server 2008 BUT have problems with the ConnectionString. Could you please let me know how I set a correct connection String while I have parameters like these: Database name: GISData Server Name : …  |
| | hi , i given code for password validation which retrieve the data from oracle table.... it was validating the first record alone... its not validating the next records... help me to validate ... ............... Option Explicit Dim ac As New ADODB.Connection Dim rs As New ADODB.Recordset Private Sub Command1_Click() If … |
| | Hello I've got a problem, I have a Oracle db in a Windows 2003 server, the server has already installed the framework 2.0, and in the same server I published a web site in asp.net 2005, and this site should connect to the oracle db, but when you open any … |
| | sir/madam i need a help.......how to search a string from oracle to vb.......my codings are not working properly so please correct it........i attach my codings below... [COLOR="Red"] accse.Open "Provider=MSDASQL.1;Password=tiger;Persist Security Info=True;User ID=scott;Data Source=facultydetails" rsfdcse.Open "select * from csefacultydetails where name= " & "'&name1.Text '", accse, adOpenDynamic, adLockOptimistic If Not rsfdcse.RecordCount …  |
| | Hello, How to import csv data into Oracle using c #. Where data to be imported 3GB in size and number of rows 7512263. I've managed to import csv data into Oracle, but the time it takes about 1 hour. How to speed up the time it takes to import … |
 | Hello. I'm trying to serialize a class that implements Serializable and a Runnable. My class has a transient Thread object as a field that is created and started after the restoration of my class(object). This is proven possibile by a tutorial from Oracle, [URL="http://java.sun.com/developer/technicalArticles/Programming/serialization/"]here[/URL]. But i fail to compile my … |
| | Hi everyone... this is my first post... so I would be quite descriptive I am working on a Web App which is a Helpdesk Solution and is based on PHP and interacts with MySQL, MSSQL, Oracle, Postgres SQL... we also support Linux based and Windows based installation... There is quite … |
| | I am using a FileUpload control to allow the user to import the contents of an Excel spreadsheet into an DataAdapter and then import into an Oracle database table. This works great when I use a local filesystem project. However, when I try to run this on the server, I … |
| | Hi All, This is Vasu.I am new to this software field.Now I started learning Unix n Oracle. Daily we are doing the following job manually.But I am planning to automate it.So any one please help me to write a script for the following requirement.It's very helpful to learn new things. … |
| | Hi, I´m new in forum. Im trying to change one project made in Oracle Forms/Rerports to CFML. I did somethings in CFML in 2003 and now I will return to it because I need time and dont want type lines of code. I have installed Railo and Eclipse and now … |
 | i went to college to be an engineer, came out 6 years later with a degree in discrete mathematics, & have since worked as a software developer in a corporate IT shop. i'm considering retooling once again, this time towards something like what i suppose people mean by industrial engineering. … |
| | Hi experts, i developed javascript code that connects to ms acess database 2003. Everything work fine as it can insert,update and delete information from database. But my problem is that when i try to validate all my input text so as to ensure that my user must fill all the … |
The End.