Oracle problem new instant client 10.2.0.3 basic lite win32

I use the instant client 10.2.0.2 on a w2k/IIS5 machine with no problems at all.I used "instantclient-basiclite-win32-10.2.0.2-20060508.zip", followed the instructions and it works fine. I use in an ASP page a connection string to use with OLE DB (Provider=MSDAORA; etc. etc)On a second machine i dow ...

-2147467259 Error running a VB compiled executable on XP client using ADO to Oracle.

I am running a VB 6.0 executable on an XP client using ADO to access an Oracle database on a remote server. The following line of code: "ADORecordSet.ActiveConnection = 'somestring' ", generates this error:'-2147467259 Oracle error occured, but error message could not be retrived from Orac ...

Oracle Instant Client with ADO on VBA -->Run-time error '-2147467259 (80004005)'<-

VB 6.0 uses Instant Client and Win XP Pro sp2 operating system. The MDAC has been checked and it is 2.8 sp1.The same project works on Win 2000 pro.Installing the run-time, thick, client makes the application work. We are getting the following error:Run-time error '-2147467259 (80004005)';Oracle erro ...

DTS Package from Oracle db to SQL db

I'm having problems with a DTS package that copies data from an Oracle database to a SQL database. The package runs successfully if it is manually executed however fails every time it is scheduled. The error given in the Job History is as follows:Error = -2147467259 (80004005) Error string: [Microso ...

Error 2147467259 with ASP

I just installed Oracle Client version 9.2.0.1.0 on a Win2k server. I have a VB6 and an ASP app with the same code. Both run fine on my Win2k desktop. The VB6 code runs fine on the Win2k server. My ASP app, however, displays the following message when I try to open the connection (cn.Open) on the se ...

Oracle or ODBC error I dont know Pl Help

I am using ADO to connect to oracle'conn.Open "Provider=MSDAORA.1;User ID=Userid;password=Password;Data Source=DSN;Persist Security Info=False"I am getting the error likeruntime error -2147467259(80004005)Error While trying to retrive text for error ORA-03121Do any one knows why it is happ ...

Oracle COM Errors?

Hello. I'm using Oracle's COM Cartridge to call routines built in Visual Foxpro. I'm looking for some kind of explanation of the codes returned from the ORDCOM.CreateObject() call. The dll I built can be instantiated fine from other environments on the same machine, but CreateObject returns -2147467 ...

ODBC driver for Oracle error

I just received the following error while trying to access an address I have never had problems with before. Been trying to find an answer to solve this but have been unsuccessful. The error I am receiving is:Error: Login failed. Please try againError Number : -2147467259Error Description : [Microso ...

runtime error-2147467259(80004005)

hii have developed an application in vb6.0 and connecting the application to oracle 9i database using dsn.I have run the setup in the machine having winows 2000 and vb not installed on that system. set up is installed successfully but when i am running the application the error comes-runtime error-2 ...

VB 6 - Oracle(Unix)

I am trying to connect to an Oracle DB on a Unix Box. My VBApp is on NT Workstation and the Network is a Windows Network.VB6 - Oracle 8i - ADO 2.6My code snippet for the connection is as follows;cn.Open "Provider=MSDAORA;User ID=MyUid;Password=MyPwd;Data Source=MyServer;Persist Security Info=False"T ...

Oracle schema confusion after imp

I am preparing to expand the use of a VB app to several branches within one organization. All branches will share one Oracle8i (soon to be 9i) instance, but require separate tablespaces. The ADO conn string determines which schema is logged into via username/password. I created a new tblsp and user, ...

Oracle BLOB Upload via ASP ORA-00600 Error

I have a routine that successfully uploads a file into a blob field of a table via ASP. Yet, approximately once a day (and it seems to be on the first attempt of upload each day), the routine returns an error. I have gotten these errors with all file types and sizes and can usually reproduce it if I ...

Oracle JDBC Numeric Overflow / IP address conversion

I am using an application that imports data via a JDBC connection to an instance. It bombs anytime I try to pull over large NUMBER values. Specifically, I have numeric representations of IP addresses. (For example a stored value of 3520061480 converts to "209.207.224.40")When I try to pull this data ...

Oracle How do I trace a function sequence error?

can anyone tell me how I trace a function sequence error?I have a piece of VB code (that has worked on many occassions, which runs to 9i.I deleted the contents of my tables and then tried to run the same code again but got the following error message:run time error '-2147467259 (80004005)':[Oracle][ ...

Oracle How to find the cause of a function error?

can anyone tell me how I trace a function sequence error?I have a piece of VB code (that has worked on many occassions, which runs to 9i.I deleted the contents of my tables and then tried to run the same code again but got the following error message:run time error '-2147467259 (80004005)':[Oracle][ ...

Server Issue with Oracle and ASP Connection

We got a new server and are trying to set it up with Oracle Client to allow our web application to connect to the database server. We are getting connection errors, but on the old server, it works fine. We have Windows 2003 and IIS 6.0 on the new server and Win2K and IIS 5.0 on the old server and it ...

Oracle Stored Procedure w/ binary data parameter problems in Visual Basic

Howdy all.I am having a problem calling stored procedures with a BLOB parameter. I have tried changing the paramater other data types to see if it would work, but with no success. I am calling the stored procedure from Visual Basic using ADO. I am using the Oracle ODBC Driver, Release 9.2.0.4.0. I h ...

Oracle Instant Client with SQL Server - HELP!!

G'day all...My goal is to connect to a server using Oracle Database version 8.1.7.4, from a server which does not have either Oracle Database or the full Oracle Client, preferrably using SQL Server DTS packages.With that said, I have installed instant client basic and instant client ODBC suppliment ...

About connecting to Oracle from an Excel file

Now I've got such problem: Run-time error '-2147467259 (80004005)': ORA-12154: TNS: could not resolve service name with the codes below (towards the bold statement): Dim objADOConnection Dim objADORecordSet Dim strSQLCommand Set objADOConnection = CreateObject("ADODB.Connection") Set objADORecordSet ...

Oracle 9.2.06 Error

I am using ADODB from VB6 to connect to Oracle server. Recently there was an org wide upgrade of Oracle client and server to 9i. The code was designed for 8i but worked without any issues in 9i (9.2.0.1).But there was a security patch applied sometime which upgraded the client version from 9.2.0.1 t ...

Oracle ORA-00979: not a GROUP BY expression

I run this query:select COINT, sum(QTACH) from MZPOSIWHERE COINT = '0MCMC'group by COINTand I getNUMBER: -2147467259 SOURCE: Microsoft OLE DB Provider for ODBC Drivers HELPCONTEXT: 0 DESCRIPTION: [Microsoft][ODBC driver for Oracle][Oracle]ORA-00979: not a GROUP BY expression.Any ideas? ...

VB6, Oracle 9i connectivity problem

The follwoing error occurs intermittently while tring to connect to Oracle 9i from a service written in VB6. The connection is dsnless and commandtime out=15.Err:-2147467259 Oracle error occurred, but error message could not be retrieved from Oracle.ADO Provider: MSDAORA;ADO DataSource: <data_sou ...

Error while connecting Oracle

Below is the code I have written to connect to oracle database through VB.and got error.'Script in VB =============================== Dim rs1 As New ADODB.Recordset Private Sub Command1_Click() Dim myconn1 As New ADODB.Connection Dim lngcount As Integer With myconn1 .ConnectionString = "Provide ...

Date comparison in oracle thru Vb

I am running one query as from VB with oracle recordset.open sQuery, connection objectwhere i have tried 1> sQuery="Select * from Holiday Where HolidayDt = '07-Aug-2002'"returning no records2>sQuery ="Select * from Holiday Where HolidayDt = '#07-Aug-2002#'"gives errorrun-ti ...

Oracle DSN Problem

Recently i have upgraded my database from oracle 9i to 10 g(10.2.0). The problem is when I am trying to connect the database through DSN using VB 6.0 I am getting an error "-2147467259 [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed. "My applicaion is developed in VB 6.0 and it wa ...

Oracle DSN Problem

Recently i have upgraded my database from oracle 9i to 10 g(10.2.0). The problem is when I am trying to connect the database through DSN using VB 6.0 I am getting an error "-2147467259 [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed. "My applicaion is developed in VB 6.0 and it wa ...

Oracle Identify a duplicate record

actually i had post the question related with this many times in my previous post before and this are:[link1|http://forums.oracle.com/forums/message.jspa?messageID=3558165#3558165], [link2|http://forums.oracle.com/forums/thread.jspa?messageID=3493643?], [link3|http://forums.oracle.com/forums/thread. ...

Oracle 11g Client to Oracle 9i Database

I have installed Oracle 11g Client on my computer but everytime I try to connect to myOracle 9i Database Server I get the error:ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.Error Number -2147467259Can someone please explain why I can not connect Oracle 1 ...

Oracle lost RPC connection to heterogeneous remote agent using...

Good morning.I am a VB developer and I use an Oracle database (10g).Our Oracle database has to call (sometimes) a SQL server database to get/check information.We just migrated our Oracle database to a new server using Windows (64 bit). Because Oracle doesn't have a 64 bit transparency or database ga ...

Oracle Error ORA-12154: TNS:could not resolve the connect identifier specified

I'm attempting to use a vbscript to make a connection to an Oracle 10g database. The script I am using is a known working script that I have copied from an old machine to my new machine. It still works from my old machine (Running Windows XP SP3), but when ran on my new machine (Running Windows XP S ...

Oracle Can't Connect after installing 10g EX

After installing a local copy of Oracle Database 10g Express Edition on my laptop (for development purposes of the online database)I can't connect anymore trough ODBC connection.For example connecting with Excel to the database with the connection string: connectionStr = "ODBC;DSN=XE;UID=msg;PW ...

Oracle as SYSDBA from VB 6.0

How can I connect me as sysdba since Visual Basic, my ConnectionString is:ConnectionString = "Data Source=" & ServiceOraDb & ";User ID=" & pUser & ";Password=" & pass & ";"The result is:Error #-2147467259: PRAYS-01017: invalid username/password; logon denied Status.Thanks.Eye ...

Error when connecting to Oracle from VB6

I have a VB6 application and for 1 action it has to connect to an Oracle db. It has worked fine since years (more than 5 years). Now we have 2 users that have problems.The error we receive is :Run-time error '-2147467259 (80004005)': ORA-01019: unable to allocate memory in the user side.First only 1 ...

Oracle How to pass a Raw array from c#?

I am trying to pass an array of byte arrays (byte[][]) to Oracle procedure using ODP.Net, which from the Oracle perpective is an array of Raw. I get the following exception:Oracle.DataAccess.Client.OracleException was unhandled by user codeMessage=ORA-06550: line 1, column 52:PLS-00418: array bind t ...

jQuery and PHP/Oracle interaction

I'm building a small web system for a group project in my database class. Basically how this works is someone searches for flights by departure city, destination city, date, and time. From there, results are shown in a table and users should have the ability to select which flight they want using a ...

Data Migration: Adabas to Oracle 8

HiWe currently need to export some data from Adabas (on OpenVMS) and import to a new Oracle 8.1.7.4 database.Can anyone advise on best procedure? Scripts, tools or other metods etc. ...

Adabas migration to Oracle

I need to migrate a database from Adabas to Oracle. I have the database structure in secuential files, and I thought to use SQL*Loader scripts to read the data, but the problem is that I don't know how to manipulate "multiple-valued" fields or groups.Any idea?????Thnks in advance. ...

How to join data from Adabas and Oracle?

I am recently working with Adabas. Also we have a database on oracle. We need to receive data from both databases and process them together. Please, suggest me how do it? ...

oracle LPAD corresponding func. IN db2

Does anybody have any clue for corresponding DB2 function of LPAD of oracle!thks in advance! ...

db2 export and db2look and Oracle full database export

Oracle full database export generates 'dmp' file that carries all objects and content in database. (May be used for database recovery, tablespace recovery, object recovery, or data recovery, in some extent.Or recreate database)What are the command, utilities and or functions (excluding db2 backup) i ...

fetch object using oracle API

I cannot fetch object using oracle functions defined for php3. Can anyone help me????? ...

Extracting DB2 data to Oracle

We are beginning to look at integrating data from an IBM DB2 database running under VM on a mainframe into Oracle applications. Currently, we have Oracle 8i, but will migrate to 9i within the year. Does anyone have any experience with extracting data directly from a DB2 database into an Oracle appli ...

Dtsession on AIX for Oracle Application Server 10g (10.1.2.0.2)

How to maintain Dtsession process to run in background (always running)?The problem occurs when running Oracle Application Server, we need to keep this process to make Oracle Application Server running well.Symptom: emctl must execute on console or X-browser, and the session must keep alive. Cause: ...

Display Server Problem with Oracle Apps

I am facing the isseu with DIsplay server running on IAX to integrate with Oracle Apps.It does not let Oracle apps to connect to display server for any report to process.i want to let every cleint connect to displaya server.this i am doing with xhost +.But its not working...it constantly hangs there ...

DB2 equivalent to Oracle's Partitioned Tables

I have a table in Oracle that is designed using ranged partitions. I am converting the database to DB2 and wanted to know if version 7.2 has a similar function. ...

how to insert items dynamically to list box from database like oracle

please tell how to dynamically insert items in list box in javascript.That is . When ever new element in stored in oracle that should be listed in listbox ...

Simple Question - DB2 UDB & Oracle

When looking at IBM web site for DB2 UDB i found that DB2 UDB EE runs on Windows 98/NT/2000. Can i install or anyone worked with DB2 UDB EE on Windows ME (Milliniun Edition). If yes, can you expalin how different it is from Windows NT/200? I need to work with DataJoiner, DB2 Relational Connect on DB ...

Oracle=sysdate; DB2=?

I want to convert this oracle query in DB2 :SELECT ...WHERE TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') > 20020101000000Could you help me plz? ...

Merge Statement In DB2 as in Oracle

HelloI was wondering if there is a MERGE statement in DB2 as in ORACLE and if not, any similar statement ?Merge statement actually updates the rows in TABLE B if present and Inserts the rows if not present from TABLE A( In Oracle) ...

trigger in Oracle

I am trying to create a trigger on a table in Oracle that will create a sequence each time a row is inserted into a table. When I try to compile the trigger I get a message that the trigger is invalid.The syntax I am using is:create or replace trigger on_part_insertbefore insert on PARTfor each rowb ...