Program Hsodbc Oracle
Oracle Connections to Non-Oracle Databases. Lewis Cunningham Apr. Oraclexe app oracle product 10.2.0 server) (PROGRAM=hsodbc) ) The HSODBC program has under gone. Mar 16, 2015 ODBC stands for Open database connectivity is an interface written in C program. How to Connect MS-Access with Oracle. Hsodbc) (ORACLE.
Hi Tom, I have set the access to a local dbase table using Heterogeneous Services. This is Listener. Spawn Comic Book Torrent. ora. (SID_DESC= (SID_NAME=hsodbc) (ORACLE_HOME=C: Programmi oracle ora81) (PROGRAM=hsodbc) ).and Tnsnames.ora. Dell Inspiron 660s Desktop Vga Drivers For Windows 7 32bit there. HSODBC = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)) (CONNECT_DATA=(SID=hsodbc)) (HS=) ). And the database link: CREATE DATABASE LINK 'SIGLA' USING 'HSODBC'; The inithsodbc.ora is: HS_FDS_CONNECT_INFO = SIGLA HS_FDS_TRACE_LEVEL = 0 When I run the query SQL>select count(*) from intabel@sigla; COUNT(*) ---------- 1813 it works fine.
The odbc driver access to a local directory on PC1 (the oracle server) Now I change the odbc configuration to access a remote disk on a PC2 mapped as G: Test it using a query from excel and all is ok. When I run the query this is the result: SQL>select count(*) from intabel@sigla; select count(*) from intabel@sigla * ERROR at line 1: ORA-00942: table or view does not exist [Generic Connectivity Using ODBC]393330(0,0,1[[]]) ORA-02063: preceding 2 lines from SIGLA Does Heterogeneous Services work only if the dbf tables are on oracle server disk? Sorry for my poor english. Thanks for all.
Mario and we said. Dear Tom, Thank U so much for your prominent support which you are providing to ORACLE community. The requirement is to connect DB2 DB which is running on NT from oracle 9i Rel2 DB which is running on NT. I went thru Heterogeneous DB Conn Admin Guide and and did the following username/password= db2admin/db2admin Machine name(NT)=venkatk DB name=tpg01db port #=50001 (SID_DESC = (GLOBAL_DBNAME = tpg01db) (ORACLE_HOME = D: Oracle9i) (SID_NAME = tpg01db) (PROGRAM= ) The value associated with PROGRAM keyword defines the name of the agent executable. Question 1) What would be the PROGRAM value? HS agents are part of the Oracle9i Database, so they are installed by default with these products. Generic Connectivity uses these agents to connect to the non-Oracle systems.