Sitemap

Amicuk Programming Answers

Problem with dblink through ODBC

-0001-11-30   Views:0

Advertisement

Hi. Our company are trying to connect to an Oracle 7.3.4 database from Oracle 10g through an ODBC link (using Microsoft Oracle ODBC driver). The database link is working when we test it in SQL Plus, meaning that select * from [email protected] is

Hi. Our company are trying to connect to an Oracle 7.3.4 database from Oracle 10g through an ODBC link (using Microsoft Oracle ODBC driver). The database link is working when we test it in SQL Plus, meaning that select * from [email protected] is working. But, when we are using
Select count(*)
from [email protected] we get an error:
SQL> select count(*) from [email protected];
ERROR:
ORA-28500: forbindelse fra ORACLE til ikke-Oracle-system returnerte denne
meldingen:
[Generic Connectivity Using ODBC][Microsoft][ODBC driver for Oracle]Error in
row 1[Microsoft][ODBC driver for Oracle]Error in column 1: Numeric value out of
range (SQL State: 01S01; SQL Code: 0)
ORA-02063: foran 2 lines fra TEST_SID
no rows selected
SQL>
Why is this happening when the tatabase link is working with regular selects?
We think that the problem is centered around the odbc and db link settings. Could it be that we need to specify more in the HS init file? This is our file initTEST_SID.ora:
# HS init parameters
HS_FDS_CONNECT_INFO = odbc_test
HS_AUTOREGISTER = TRUE
HS_FDS_TRACE_LEVEL=OFF
HS_DB_NAME = hsodbc
# Environment variables required for the non-Oracle system
#set <envvar>=<value>
Could it be the ODBC driver version? Our MS ODBC driver is:
Microsoft ODBC for ORacle version 2.575.1022.00, MSORCL32.DLL
Has anybody experienced something like this before?
Ronny

The replay answer
Advertisement
I tried the same thing when we needed to connect a 9i database to a 7.3.4 database, but could not get it to work.
Instead, we used a database link to an 8i database which had a database link to our 7.3.4 database. We had to set up some views on the 8i database to hide the link, but it was only temporary. If you go down this route, check your licensing situation.
Tak

Go to See the other 2 answers

Problem with dblink through ODBC

Category:DefaultRelease time:-0001-11-30Views:130

Hi. Our company are trying to connect to an Oracle 7.3.4 database from Oracle 10g through an ODBC link (using Microsoft Oracle ODBC driver). The database link is working when we test it in SQL Plus, meaning that select * from [email protected] is[More]

Query update on each iteration problem (MS SQL Sever / ODBC / Native Driver

Category:DefaultRelease time:2015-10-11Views:130

Hello, I�ve been working to learn some Java and now JDBC over the past 10 or so months. I think I have a general understanding of how to perform queries and work with data using JDBC. However, I�ve run into a problem. I�m trying to do a query of a se[More]

Problem with dblink in Oracle Forms 6i

Category:DefaultRelease time:2015-10-11Views:130

I hava a problem and i try to compile a form that use a dblink when i start to compile the form the IDE is close and no errors are shown. That someone know what can i do for it ??... The Dblink is defined like this way: sqlstr := 'SELECT ' || The_Col[More]

Problem in building JDBC ODBC connection with my stand alone Project.

Category:DefaultRelease time:2015-10-11Views:130

Hello Everyone! I gave the following command in order to create JAR file: C:\app>jar cvfm MyJar.jar Manifest.txt . and the Manifest file contains the code: Main - Class: Login My Manifest File and the .class codes and the JAR file which is created su[More]

Urgent! Problems with bridge JDBC-ODBC

Category:DefaultRelease time:-0001-11-30Views:130

Hello, I have found out that JDBC-ODBC bridge in JDK 1.4.1 don't works fine, because, if you want to store text largest 254 characters in a field type text in one record of a Access database's table, it generate a SQLError, I have tried with EasySoft[More]

Any problem with dblinks between 8.1.7 and 10gR2?

Category:DefaultRelease time:-0001-11-30Views:130

Hi, Just want to know if any of you have encountered problem using a dblink between an Oracle database 8.1.7 and a brand new 10.2? I guess simple query from the 8i db to 10gR2 data would be OK...or not!? But what for queries with joins??? Many Thanks[More]

Problem with connecting [Microsoft][ODBC Driver Manager]

Category:DefaultRelease time:2015-10-11Views:130

I am employing the Apache Tomcat 5.5.During the time of execution one Exception occur which implies [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified In ordinary way of execution of DataBase connectivity(with[More]

Problem connecting through with ODBC driver

Category:DefaultRelease time:2015-10-11Views:130

I have a virtual machine (Win XP SP3) running Oracle 11.1.0.7.0. The name of the machine is UK010862.uk.int.**********.com. sqlnet.ora: SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= ( TNSNAMES, EZCONNECT) tsnames.ora: ORCL = (DESCRIPTIO[More]

Performance problem with dblink

Category:DefaultRelease time:-0001-11-30Views:130

Hi! I have 2 servers with a dblink join. I push from server A to server B with an insert sentence 80 mb of data (blob datatype). It take between 4 to 5 hours to insert. Server A and B are in the same office. (Windows 2000) Somebody have an idea why i[More]

Problem in DBLINK | More Inactive sessions

Category:DefaultRelease time:-0001-11-30Views:130

Hello All, We are facing some problem in our environment due to db links between the applications 1. MYDB and TSTDB applications reside on two different DB's. 2. MYDB has a db link to TSTDB to extract data from TSTDB. 3. There are lot of sessions cre[More]

Getting a problem while using Microsoft ODBC for Oracle

Category:DefaultRelease time:-0001-11-30Views:130

Oracle(tm)Client and networking components not found. These components are supplied by Oracle Corporation and part of Oracle Version 7.2 or greater Client software installation. You will be unable to use this driver until these components have been i[More]

Hot
Hi I'd like to know if there is a FM to update the Sales order schedule line quantities. In particular, the fields in VBEP:  WMENG, BMENG, LMENG, CMENG. Thanks.Hi Lily, Can you please tell us how you updated BMENG using the BAPI BAPI_SALESORDER_CHANG [More]
Can somebody help me? my safari quit unexpectedly and it wont let me reopen it. i can't go on safari at all right now. my version is surely updated. and this is what it said when i click on detail Process:               Safari [1262] Path:            [More]
Dear all of I am getting the following error while using the export utility in the Oracle database 9i I have run the catexp.sql and catrm.sql suggested by the experts in this forum. But it did not help me. Kindly help me in solving this issue. FOLLOW [More]
Is there a way that I can sync my Itouch to my outlook task list? I really need some help.There is no a way to sync Outlook To-Dos or Notes, much to many people's chagrin, including mine. There have been many requests made to Apple for this functiona [More]
I recently upgraded to Snow Leopard and now I would like to upgrade to Lion but it is not in the Mac App store anymore. How can I get it?Phone the Apple Store and order a download code for it. (70012)Read other 2 answers [More]
Important.Ben, welcome to the forum. Here is a guide from Microsoft to help you create the disk.  Watch the video. Please click the "Thumbs up + button" if I have helped you and click "Accept as Solution" if your problem is solved. Sig [More]
Hello all, currently i'm using version 4.7. as known in std t-code FB12, we need to request which documents to generate correspondence. steps are:- 1. enter company code 2. choose correspondence type 3. key in document number & fiscal year as for ite [More]
Our engineering team is looking for ways for us to reduce the number of XML files produced when a (relatively) simple 2-page INDD file is saved out as IDML for translation?IDML contains quite a few XML files, but I suspect you're only interested in t [More]
After I import my photos from my phone to iphoto, i always move my pictures to a folder i made in my documents. Now, for some reason, it does not let me transfer the pictures. As i drag the pictures to the Finder, it does not let me release the pictu [More]
Hi all, does anybody knows if tehere is a BAPI/FM to read complete hierarchy of a marketing planner ? I mean i have MKTPL's GUID from table CGPL_PROJECT and i'd like to know entire hierarchy of it..... May U help me ? Kind regards, Francesco.Francesc [More]