Oracle ODBC Rdb Driver

We want to install Oracle ODBC Rdb Driver 2.10.13.00 but we can't find this driver for XP.We are now using the driver 3.00.02.06 but we have a lot of problem.Could you please Help me ?SG ...

Oracle table RDB.tblRm is mutating, trigger/function may not see it

We have written a procedure sp_CloseRM which compares a datefield and if it expires with todays date then another procedure sp_deLink will be called in which we update some data of tblRM.And also we wrote a trigger which updates the values to null in tblRMS on update of tblRM.We have also created a ...

Oracle RDB7 %RDB-F-SYS_REQUEST

can anyone please explain what this Error is and what can be the solution...this has happened with the Oracle RDB7 database which we are using for one of our application.%RDB-F-SYS_REQUEST, error from system services request%RDMS-F-EXQUOTA, exceeded quota%COSI-F-EXENQLM, exceeded enqueue quota ...

Oracle to RDB INSERT statement

I'm trying to update a remote table of a RDB Database withrecords from a local table in an Oracle Database with the following SQL statement:INSERT INTO LOT_RESULTS@NOVLNKSELECT * FROM LOT_RESULTSwhere LOT_RESULTS@NOVLNK is the remote table in the RDB Database and LOT_RESULTS is the local table in OR ...

Oracle odbc rdb driver v3.1.0.3 not able to download

hi, I've been trying to download the odbc driver rdb v3.1.0.3 from the oracle site - it downloads the zip file but can't open it with winzip - gets an "old archive file try downloading again" - any one have any ideas? or where I can download from another site? ...

Oracle Need RDB ODBC driver version 2.10.17

I need this older release for Visual Foxpro 9.0 ODBC connections. This version is no longer available for download on your website. Or, alternatively, I need a way to transfer this working release from one PC to another. Version 3 works with some apps but not VFP 9. ...

Oracle CLOB, out params in SP, DLL, ASP

Using Windows2000, 9i(9.0.2?), OraOLEDB driver by Oracle.I have an Oracle stored procedure that is called by a DLL which is called from an ASP page. The signature of the call is ...CREATE OR REPLACE PROCEDURE checkOutFile( pProjName IN VARCHAR2, pFileName IN VARCHAR2, pUser IN VARCHAR2, pVer IN NUMB ...

ADO, Recordsets, and Oracle SP input params

Does anyone know if it is possible to pass an ADO recordset from VB 6 using ADO and COM+ to an Oracle Stored procedure?I need to evaluate multiple records and would like that evaluation to occur on the server rather than the client. ...

Oracle Limitation proc params with OCIDescribeAny?

There seems to be a limitation of 256 procedure parameters when getting info via OCIDescribeAny. Am I wrong? Is there a way to get around this? Why is there such a limitation? ...

Oracle Number of params in a prepared statement in OCI

Does anyone know how to determine how many parameters one prepared statement may have, i.e. something similar to ODBC's SQLNumParams call? This is for the Solaris platform.Assume I have a statement like this: "select firstName, lastName, emailAddr from emp where empId = :id and age < :age". In th ...

Oracle LOV with params

How to use LOV which is defined with parameter?I.E.select name d, id r __from countries _where continent = :continentDo I have to assign value on every "before header" or what....any help appresciated.THX!Sorry if this post is repeated but cannot find it! ...

Oracle Using URL params in a PL/SQL block

I have a column link (id) set up on page 1 that brings up page 2. I am passingid as a URL parameter. I am trying to use the parameter as input to an ONLOADProcess that will select some text from a table for that id stored in a CLOB. Can you provide me with the syntax for accessing the URL param?sele ...

Oracle Number of params (arguments) passed to an sql file

Is there a way to find out number of parameters passed to a sql fileFor ex test.sql EMP DEPT EMP and DEPT are passed as parameters(command line arguments) to the SQL file "test.sql".Though I can access then within the test.sqlas :table_name1 = &1;:table_name2 = &2;I would like to loop thru a ...

Oracle changing NLS params after installation

Is it possible to change NLS_CHARACTERSET to EE8MSWIN1250 and NLS:NCHAR:CHARACTERSET to AL16UTF16 after instalation of XE 10.2TIAdinko ...

Oracle Rdb odbc driver Download link transfers wrong file

The download for Oracle ODBC Rdb driver with universal Installation link should download a file with 12mb as mentioned in the web site link. But it downloads wrong file with 1kb size which is in-capable of doing nothing.First of all, the direct clicks on the driver downloads (with or without univers ...

ODBC - Oracle Rdb : SQL column aliases not supported ?

We have problems using a database link from an Oracle v8.1.6 database to an Oracle Rdb v5.1 database via hsodbc-ODBC driver for Rdb v3.0.2.x on Windows NT4.Error Message : [Oracle][ODBC][Rdb]%SQL-F-SYNTAX_ERR, Syntax error (SQL State: S1000; SQL Code: -1)The ODBC connection to the Rdb DB is OK. With ...

Oracle RDB Error Codes...

All,I apologize in advance if this is not posted to the correct place.OS:SQL Server2000 on WinNT 4I'm using the Oracle RDB driver to run a DTS against the Oracle database on a VAX. The error message I cannot find an explaination for is:Step Error Source: Microsoft OLE DB Provider for ODBC DriversSte ...

Orcale11g DG4ODBC-Connection to Oracle RDB Database

Hallo,with Orcale 11g I want to select data from Oracle RDB Database with the Oracle DG4ODBC.I have configured the following items:0) ODBC SYSTEM DSN1) listener 2) tnsnames 3) init<SID>.ora of the hs subsystem 4) environment 5) Oracle database But, if I run the select statement, I have the fol ...

Connecting Oracle RDB through ODBC

I have my Oracle RDB running in OpenVMS environment. Below is my server configuration.SQLSRV> show server;Server Version: 7.3Server Platform: HP OpenVMS IA64Max Shared Mem Size: 8000 KbConfig file: SYS$SYSROOT:[SYSMGR]SQLSRV_CONFIG_FILE73.DAT;1Log path: SYS$MANAGER:Dump path: SYS$MANAGER:Proc sta ...

RDB ODBC to MS Sql issues.

I was assigned a project at work to get an Oracle system to synchronize a table & contents to an sql server.Seemed daunting, but I found the RDB ODBC driver, loaded that and created a System DSN on my Windows 2000 SQL Server. I am working with creating a DTS package that would run every 3 hours ...

RDB ODBC driver

I have an 8.1.7.0 Oracle db installed on an OpenVMS ver 7.3.I wanted to connect an XP client using RDB ODBC driver.I've downloaded latest RDB driver version (3.20.00) from Oracle site.Connection test succeed. This is the connection string I use:ATTACH 'FILENAME USER$DISK:[ELIA_TO.DAT]RDB_TEST'When o ...

Oracle's position on SQLMOD

It has become apparent to me that Oracle has chosen not to support SQL*Modlue, a Core SQL:1999 standard, for it's RDBMS product. I came to this conclusion after reading what looks like an Oracle publication... http://info.star.spb.ru/Oracle/Oracle9i_doc/server.901/a90125/ap_standard_sql.htm"Oracle d ...

Getting PHP to speak to Oracle

I've got quite a mess here.I have a new Windows 2000 Server, running IIS. I've installed PHP manually (as well as using the php.net binaries). I have edited the php.ini file to point the extension_dir to the correct location. I have installed the Oracle client, as well as SQL Plus.I also have an UNI ...

Oracle Trivia question about linking problem

I have a problem when linking a tiny source code which I cut from OCCI documentation's example code. The following are them:#include <iostream>#include <occi.h>using namespace oracle::occi;int main(){Environment *env = NULL;env = Environment::createEnvironment();return 0;}I compile and l ...

Oracle different figures from Solaris 'prstat' and 'top' command

I Migrated the Oracle database bearing version 9.2.0.4.0 from Sun 480(memory 8GB) To a higher end Sun server 4800(memory 32 GB). This new server had oracle home with version 9.2.0.6.0 Therefore we migrated the database from 9.2.0.4.0 to 9.2.0.6.0By running the catpatch.sql command I Successfully exe ...

(0x80040E57) error Microsoft OLE DB Provider for ODBC Drivers

has anyone seen this error before. If so what causes it?Error Type:Microsoft OLE DB Provider for ODBC Drivers (0x80040E57)[Oracle][ODBC][Rdb]%RDB-E-ARITH_EXCEPT, truncation of a numeric value at runtime -SQL-F-DATCONERR, Data conversion error for string '1112-00-50' -COSI-F-IVTIME, invalid date or t ...

Invalid SyncServer License

I've downloaded DB2 7.1 developer's Personal edition and DB2 Everplace Syncserver Evaluation. I'm following the Quick Start instructions:1.Start the Sync Server by selecting Programs --> DB2 Everyplace --> StartServlet for Sync Server from the Start menu. Verify Sync Server is running byopenin ...

Unable to run Mobile Device Administration Center, IBM Sync Serv

I have installed 1) DB2 UDB Enterprise edition - extended edition ver 7.22) Web Sphere Advance Single Server Edition v4.03) DB2 Everyplace v7.1.14) DB2 Sync Server v7.1.1On WINDOWS Advanced Server 2000 machine with SP1.All the products are evaluation copies from IBM site.The problem is i am not able ...

null pointer exception

Whoops, I think I broke something!I've got a development environment set up at work, and a duplicate at home. (workaholic). I successfully did a sync test today at work. I came home, started working, and tried to sync up the same database / subscription at home (not the same physical databse, but a ...

Problems with the first synchronization of Sync Server

I am trying to install DB2 Everyplace Sync Server 7.2 (Windows NT, POSE 3.2).Apparently the installation process was successfully completed, I did not get any error message. The problem comes when I synchronize for the first time. After starting the Servlet for Sync Server from Start --> Programs ...

Sync errors when using IBM Sync + Sync Server

Settings #1===========Ethernet adapter Local Area Connection:IP Address. . . . . . . . . . . . : 12.239.187.154Select "Settings" menu from "IBMSync" application and set the following:Server IP: 12.239.187.154Port #: 8080User and Password are already created on the PC.Device message DSYC602E: Failed ...

Questioning default servlet engine usability

The situation: The palm can not establish connection with SyncServer from outside, but can sync locally. Though using test command from outside the sync servlet responds OK. 1. After running test command from browser http://mysite.com:8080/db2e/db2erdbSync Server console responds:urilist: /ErrorRepo ...

error BlockMechanism

After restsrting the Serevr Sync I get the Error of:error BlockMechanismthe Serevr is doing sync with the client.Here are the Out put I get in the cosul window:I'm posting the the Msgs.Does these Msg indicates on a problem I have with the server.After intalling the DB2 sync server it works fine with ...

Oracle RDB Driver fails with JDBC/ODBC Bridge

Has anyone experienced problems using the latest Oracle RDB Driver (3.0.2.0) with the JDBC/ODBC Bridge.We have been using the Oracle ODBC Driver for RDB (2.10.17) successfully on NT, but it is not supported on W2K. The new drivers work fine for Access etc., but fail with the bridge. Specifically, yo ...

Oracle Rdb Releases on OTN

Platform: OpenVMSWhy is the current release of Oracle Rdb 7.1-02 and/or Rdb 7.0-64 not downloadable on OTN but only on Oracle's Metalink?How often will the Rdb releases on OTN being replaced by the newest ones? ...

Where is Oracle Rdb for NT?

So that we may better diagnose DOWNLOAD problems, please provide the following information.- Server name- Filename- Date/Time- Browser + Version- O/S + Version- Error MsgHi, Can you please tell me how to locate Oracle Rdb for NT4 on this site? I have followed the instructions (below) but there is no ...

Oracle ODBC Drivers for Rdb on Windows NT Alpha

I am looking for ODBC drivers for Oracle RDB running on Windows NT with the Alpha processor. The latest version I have is 2.10.14. Is there a newer version available and where can I find it? ...

Oracle cannot download RDB ODBC drivers

the download links in Oracle rdb odbc drivers for windows doesn't work. the first link for download, without Universal installer doesn't execute really. It says MS-dos error and bombs out.The second link, with universal Installer, never comes up. the download fails with server response, illegal resp ...

Oracle RDB Documentaion

So that we may better diagnose DOWNLOAD problems, please provide the following information.- Server name- Filename- Date/Time- Browser + Version- O/S + Version- Error Msg I have been trying to download pdf documentation for Oracle RDB 7.0 from sitehttp://otn.oracle.com/docs/products/rdb.But none of ...

Oracle Rdb for NT - Download files not found

The following Message was received for ALL "Rdb for NT" zip file download attempts: "The file was not found on the server"One of the download URLs is:http://download.oracle.com/otn/downloads/rdb/rdbworkbench.zipWHAT HAPPENED TO THE ORacle Rdb zip files????WOULD ANYONE ON THE FORUM HAVE THESE ZIP FIL ...

Oracle Cannot download RdB Document

Hi, trying to download or view "Oracle Rdb7 SQL Reference Manual, Release 7.0" with IE5.5 from http://technet.oracle.com/documentation/rdb.html I always get "The page cannot be displayed" as for other documents on the same page. Is this a temporary problem ? ...

Oracle rdb system table

i hope some one can come up with the solution to my problem.i am using oracle rdb database on open vms. i am trying to get the view name. view fields, source table and the source fields. i tried different ystem tables like rdb$relation_fields, rdb$view_fields etc , to get the desired result. i dont ...

Oracle Can't Download RDB Packages

I try to get:http://download.oracle.com/otn/openvms/rdb/rdbv71101kit_amv.zipResult:Server ErrorThe following error occurred:The server response could not be read because of an error. Contact your system administrator. (SERVER_RESPONSE_RESET) Please contact the administrator. ...

I cannot download Oracle Rdb Extension for OEM 9i, Release 7.1.0.0 for Wind

I cannot download Oracle Rdb Extension for OEM 9i, Release 7.1.0.0 for Windows and Sun Solaris from this URL:http://otn.oracle.com/products/rdb/htdocs/rdb_oem/index.htmlAt the bottom of that page it says:"Click here to download the Oracle Rdb Extension for OEM 9i kit."When I click there it gives me ...

Wrong version of SqlService for Oracle Rdb

When you go to the download page and select Oracle Rdb Product there is a new version of SQL Services 7.1.5.9.1 from 5-AUG-2004.If you download the ZIP file you get 7.1.5.9 from 19-JAN-2004. Version 7.1.5.9.1 was released 03-APR-2004.Everything is wrong with this "new" version. ...

Oracle Download problems with RDB JDBC Driver

ErrorDocument 404 when trying to download Oracle RDB JDBC Driver.I have tried many times since monday, but unsuccessfully. ...

Oracle 8 and the RDB Drivers

Hi, how are you. I have always worked with a latter copy of oracle than 8i. One of the technical staff in our support department here at sydney ferries as advised us that the oracle 8i is not compatible with your RDB Drivers. Somehow i don't think this is the case because as a programmer and solutio ...

Oracle RDB Odbc drivers and Visual Express 2005 !!!

i'm having troubles with MS Web Developper Express 2005 and RDB database ODBC driver 3102.When i try to declare a link to a dsn previously delared in ODBC manager (win xp sp2), i click the "test connection" then it's succesfull, but when i want to browse thru the tables within the rdb db, i receive ...

Oracle Download of Rdb Client Kits 7.1.1

I cannot download the Rdb Client Kits 7.1.1 from http://www.oracle.com/technology/software/products/rdb7/index.htmlit always directs me tohttp://www.oracle.com/technology/software/htdocs/devlic.html?http://www.oracle.com/technology/software/products/rdb7/htdocs/othersoft.htmlwhich then redirects me ...

Oracle Unable to download Rdb JDBC driver

On trying to download the Rdb JDBC 7.1.4.1 driver, takes me to the licensing page and then again back to the same page. There seems to be no content for download. Please advice.url :http://www.oracle.com/technology/software/products/rdb7/index.html ...