Untuk point 3, saya mencobanya dengan oracle 10g saya belum pernah dengan
oracle 8.0.5 jadi saya tidak tahu persis kalo untuk oracle 8.0.5.
 yang saya lakukan di oracle 10g adalah dengan menambahkan/meng-edit di file
listener.ora coba tambahkan seperti ini:
    )
      (SID_DESC =
      (SID_NAME = HSMSQL)
      (ORACLE_HOME = d:\oracle\product\10.1.0\db_3)
      (PROGRAM = hsodbc)
    )
Kemudian restart listener-nya.
Kalo untuk file inithsodbc.ora coba cari di folder
c:\oracle\product\10.1.0\db_3\hs\admin
Kemudian edit file inithsodbc.ora, ganti pada HS_FDS_CONNECT_INFO = ('sesuai
dengan nama ODBC-nya'.
Selamat mencoba..
Salam,

Burghan

-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On
Behalf Of Clara Devi
Sent: Sunday, August 08, 1999 8:51 AM
To: [email protected]
Subject: Re: [indo-oracle] ODBC

  Pak Thanks  ya tuk artikelnya saya sudah coba pelajari tp saya ada problem
dlm point
  3. ENTRIES TO THE LISTENER.ORA
   3.1 (SID_DESC =
  Needs to match the sid in tnsnames.ora?(SID_NAME=HSMSQL)
  (ORACLE_HOME=D:\oracle\product\10.1.0\Db_3)
    hsodbc is the executable?(PROGRAM =hsodbc)
           )
  saya pake oracle 8.0.5 dan untuk set
(ORACLE_HOME=D:\oracle\product\10.1.0\Db_3)
  saya harus gunakan file apa karena data oracle semua ada di C:\orant dan
folder product  tidak ada ...

  dan file inithsodbc.ora, initHS_SID.ora tidak ada di komputer saya,  pak
kira2 saya harus copy dari mana atau bagaimana ya ?

  Thanks banget untuk masukkan tmn2 karena saat ini saya harus dapat akses
dari form developer ke SQL server, Urgent

  Salam,
  Devi





  Coba baca artikel dibawah ini saya dapat dari orafaq.com, saya sudah
pernah mencobanya dan berhasil.

  Regards,
  Burghan
  ====================
  Access MS SQL Server tables from Oracle 9i

  For the tables to be accessed we can use the generic connectivity. This is
using the hsodbc that is heterogenous Connectivity Drivers. The procedure is
here which we have created as a white paper. Please go step by step
  1. CREATING THE SYSTEMDSN THROUGH THE DATASOURCE:-
  The following procedure enables you to define a system DSN in the
Windows98/NT/2000/2000/serverXP ODBC Data Source Administrator,
  1.1. From the Start menu, choose Settings > Control Panel and select the
ODBC
        icon. If it is in the windows 98. OR 1.1. If it is in windows
NT/2000/XP then goto the Start menu, choose Settings > Control
        Panel and select the Administrator tools and then select the Data
Sources (ODBC).
  1.2. Select the system DSN tab to display the system data sources.
  1.3. Click Add.
  1.4. From the list of installed ODBC drivers, select the name of the
driver that the
        data source will use. For example, select SQL Server.
  1.5. Click Finish.
  1.6. Enter a name for the DSN and an optional description. Enter other
information
        depending on the ODBC driver. For example, for SQL Server enter the
SQL
        Server machine. Press Next.
        Note :- The name entered for the DSN must match the value of the
        parameter HS_FDS_CONNECT_INFO that will be specified in
initHS_SID.ora.
  1.7. Then select the option (With SQL Server authentication using login ID
and password
         entered by the user)
  1.8. Then select the check box (Connect to SQL server to obtain default
settings for the
         additional configuration options).
  1.9. Now in the Text Box (Login ID: ) type the MS-SQL server login and in
the Text Box
          of (Password: ) type the Password of the MS-SQL server user's
password.
          Then press Next.
          Note :- Every time this user will be used in order to connect to
MS-SQL server.
          And tables available in this user's schema will be available to
query. So no need of
          giving the user and password again and again to connect to the
database of MSSQL
           server.
  1.10. select the check box (Change the default database to) then it will
show that
          particular users database which you have previously mentioned in
point 1.9 above.
          Select that database from the List Of Values (LOV). Then click
next and then Finish.
  1.11. Then the ODBC Microsoft SQL Server Setup window will be displayed.
Here check
           the connection by pressing the test button which checks the
connectivity to
           MS-SQL Server with the authentication of User entered in point
1.9. If the
           connection is successfully then the MS-SQL username, MS-SQL
password and the
           MS-SQL servername are proper. If it is unsuccessful then check
then check the
           username, password and the server name.
  1.12 . After creating the system DSN, click OK to exit the ODBC Data
Source
             Administrator.
            Note :- Now Please keep in mind the SystemDSN name you gave for
the source
            MS-SQL Server. That was the name in the 6th point.
  ________________________________________
   FILE. :-?2. ENTRIES TO THE TNSNAMES.ORA
  Here it is considered as the name of the HSMSQL as the systemDSN name You
created through odbc.
  2.1
         HSMSQL=
             (DESCRIPTION=
                          (ADDRESS= (PROTOCOL=tcp)
                                                (HOST=oracle server IP)
                                                (PORT=1521)
                           )
                          (CONNECT_DATA =
                                           (SERVICE_NAME=HSMSQL)  ->
  Needs to match with the
                                                       sid in the
  listener.ora
                           )
                           HS clause goes in the description?(HS = OK)
              )

  2.2 Here the HSMSQL is the name of the systemDSN created to connect to the
         MS-SQL-SERVER through the odbc datasource administrator. The IP is
the IP of the
         Oracle server where the oracle database is installed or through
which your are trying
         to connect the ms-sql server database.
  2.3 Save and Exit.
  ________________________________________
   FILE. :- Here it is considered as the name of?3. ENTRIES TO THE
LISTENER.ORA the HSMSQL as the systemDSN name You created through odbc.
  3.1 (SID_DESC =
  Needs to match the sid in tnsnames.ora?(SID_NAME=HSMSQL)
  (ORACLE_HOME=D:\oracle\product\10.1.0\Db_3)
    hsodbc is the executable?(PROGRAM =hsodbc)
           )

  3.2 Save and Exit.
  ________________________________________
  4. STARTING THE LISTENER :-
    Reload the Listener, and confirm that the HSODBC service is running.
  4.1 After reloading the listener the below thing should be show, now here
        the hsmsql is the systemdsn name is assumed in the listener.ora file
        For example :
        DOS> lsnrctl reload

        LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on
  26-
        AUG-2004 10:04:03

        Copyright (c) 1991, 2004, Oracle.  All rights reserved.
       Connecting to
       (DESCRIPTION= (ADDRESS= (PROTOCOL=IPC) (KEY=EXTPROC)))
       The command completed successfully.
       - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
  - - -
       DOS> lsnrctl services

       LSNRCTL for 32-bit Windows: Version 9.2.0.4.0 - Production on 01-
       JUL-2004 12:00:00

       Copyright (c) 1991, 2002, Oracle Corporation.  All rights
  reserved.
       Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=IPC)
  (KEY=EXTPROC0)))
    Services Summary...
    Service "HSMSQL" has 1 instance(s).
    Instance "HSMSQL", status UNKNOWN, has 1 handler(s) for this service...
      Handler(s):
        "DEDICATED" established: 1 refused: 0
           LOCAL SERVER

    Service "ORCL" has 1 instance(s).
      Instance "ORCL", status READY, has 1 handler(s) for this service...
        Handler(s):
          "DEDICATED" established: 0 refused: 0 state: ready
             LOCAL SERVER

    The command completed successfully
  4.2 Now in the 4.1 the red coloured HSMSQL service is shown as running,
        that means the service is up to listen the queries.
  5. CREATING THE INITIALIZATION FILE :-
  The following procedure enables you to create the Initializing the service
  by creating and customizing an initialization file for your Generic
Connectivity
  agent.
  5.1. Oracle Corporation supplies sample initialization files,
inithsodbc.ora
            for ODBC agents. The sample files are stored in the
\ORACLE_HOME\hs\admin
             directory.
  5.2 To create an initialization file for an ODBC, copy the applicable
sample
            initialization file from \ORACLE_HOME\hs\admin and rename the
file to name
            initHS_SID.ora, where HS_SID is the system identifier you want
to use for the
            instance of the non-Oracle system to which the agent connects.
(Please refer to
            the point 1.6 name will SID that is if the name was msql here it
would be
            HSMSQL. The suffix HS will be added to name of the systemdsn
name.
            Note: - The HS_SID is also used to identify how to connect to
the agent when you
            Configure the listener by modifying the listener.ora file.
  5.3 The HS_SID you add to the listener.ora file must match the HS_SID in
an
            initHS_SID.ora file, because the agent spawned by the listener
searches for a
            matching initHS_SID.ora file. That is how each agent process
gets its initialization
            information.
  5.4 When you copy and rename your initHS_SID.ora file, ensure it remains
in the
              \ORACLE_HOME\hs\admin directory.
  5.5 Then open the file HS_SID.ora file make the below changes.
          odbc_data_source_name?HS_FDS_CONNECT_INFO = HSDSNNAME
         HS_FDS_TRACE_LEVEL = OFF

          Example: - If the name of the systemdsn was hsmsql then here it
  will be:
         HS_FDS_CONNECT_INFO = HSMSQL
         HS_FDS_TRACE_LEVEL = OFF

        Then save the file and exit.


  ===========================================================


  6. CREATING THE DATABASE LINK TO ACCESS THE TARGET  DATABASE :-
      Now create the database link, here it is assumed that the name of the
systemDSN is
      Hsmsql.
  6.1
            sql> create database link hsmsql
              2.  connect to "ms-sql user login" identified by
  "ms-sql passwd"
              3.  using 'hsmsql';

              Database link created

  6.2       To test, run a simple query of a known table on the target
  datastore.
              Note :- But before executing this, the table employee should
be created first in
              the MS-SQL server.
              SQL> select * from employee_at_hsmsql;
              EmpoyeeID EmployeeName
              ----------
  --------------------------------------------------
              1 Ralph
              2 Sam
              3 Monica

              THIS MEANS THAT NOW YOU ARE ABLE TO QUERY THE REMOTE MS-SQL

              DATABASE.

               Note :- If any errors please refer to the APPENDIX B for
  the common errors.
  ________________________________________

  7. RESTRICTIONS ON OPERATIONS TO BE CARRIED ON THE REMOTE DATABASE FROM
ORACLE.
  On the remote database the DDL (Data Definition Language) statement cannot
be executed.
  7.1 Creating the table on the remote database is not possible on a remote
database.
          Example :
          SQL> create table rama_at_hsmsql
             2  (
             3  name varchar,
             4  address varchar,
             5  phone varchar);
            create table rama_at_hsmsql
             *
            ERROR at line 1:
            ORA-02021: DDL operations are not allowed on a remote
  database
  7.2 Dropping the existing table from remote database not possible.
           Example:
           SQL> drop table emp_at_hsmsql;
           drop table emp_at_hsmsql
            *
           ERROR at line 1:
           ORA-02021: DDL operations are not allowed on a remote database

  7.3 Selective queries are not possible on the remote database.
         Example :

  SQL> select * from employee_at_hsmsql
    2 where EmpoyeeID='Ralph';
  where EmpoyeeID='Ralph'
         *
          ERROR at line 2:
          ORA-00904: "EMPOYEEID": invalid identifier

  7.4 Deletion of the selective rows not possible on the remote
  database.
   Example:
          SQL> delete from employee_at_hsmsql
                 2  where employeeid=4

     3 ;
  where employeeid=4
    *
             ERROR at line 2:
             ORA-00904: "EMPLOYEEID": invalid identifier



  7.5 Updation of the selective rows not possible. SQL> update
employee_at_hsmsql
    2 set employeeid=100
    3 where employeeid=1;
  where employeeid=1
        *
  ERROR at line 3:
  ORA-00904: "EMPLOYEEID": invalid identifier
  ________________________________________

  8. OPERATIONS THAT CAN BE CARRIED OUT ON THE REMOTE DATABASE FROM ORACLE.
8.1 Inserting the new records into the existing table. Example:-
            SQL> desc emp_at_hsmsql;
                                 Name
   Null?    Type
                       ----------------------------------------- --------
  ----------------------------
                                  empno
             VARCHAR2(1)
                                  ename
             CHAR(1)

           SQL> select * from emp_at_hsmsql;
                     e e
                     - -
                     1 j

           SQL> insert into emp_at_hsmsql
                  2  values ('2','P');

                  1 row created.

           SQL> select * from emp_at_hsmsql;

                     e e
                     - -
                     1 j
                     2 P

           SQL> insert into employee_at_HSMSQL values(4,'Ramakrishna');

           1 row created.


  8.2 Deletion of the all rows at once in the table is possible, even it can
be rollbacked.
  SQL> delete from employee_at_hsmsql;
  3 rows deleted.
  SQL> SELECT * FROM EMPLOYEE_at_HSMSQL; no rows selected
  SQL> rollback;
  Rollback complete.
  SQL> SELECT * FROM EMPLOYEE_at_HSMSQL;  EmpoyeeID EmployeeName
  ----------  --------------------------------------------------
             1    Ralph
             2    Sam
             3    Monica

              3 rows selected.



  ===========================================================

  8.3 Creating the tables in the oracle from the existing tables on the
remote database. That
        is duplication of tables from MS-SQL to Oracle.
        SQL> select * from employee_at_hsmsql;
         EmpoyeeID EmployeeName
         ---------- --------------------------------------------------
                     1 Ralph
                     2 Sam
                     3 Monica

        3 rows selected.

        SQL> create table employee as select * from employee_at_hsmsql;

        Table created.

        SQL> select * from employee;

   EmpoyeeID EmployeeName
  ---------- --------------------------------------------------
           1 Ralph
           2 Sam
           3 Monica

  3 rows selected.
  ________________________________________
                    APPENDIX A

                         (Tables in the MS-SQL server)

  A.1   Tables with data created in the MS-SQL Server.
  Example:-

  SQL> create table employee (
             EmpoyeeID NUMBER(10),
             EmployeeName VARCHAR2(50)
         );

  SQL> insert into employee values(1, 'Ralph');
              SQL> insert into employee values(1, 'Sam');
              SQL> insert into employee values(1, 'Monica');

  . - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
  . - - -
  SQL> create table emp (
             Empno VARCHAR2(1),
             Ename  CHAR(1)
             );

  SQL> insert into emp values('1', 'j');

  SQL> insert into emp values('2', 'P');
  SQL> insert into emp values('2', 'P');


  -----Original Message-----
  From: [email protected] [mailto:[EMAIL PROTECTED] On
Behalf Of Clara Devi
  Sent: Thursday, August 04, 2005 4:34 PM
  To: [email protected]
  Subject: Re: [indo-oracle] ODBC

    Sorry saya nanya lagi TG4MSQL itu bawaan oracle atau berdiri sendiri
  soalnya saya cari di www.oracle.com ga nemu, jadi kalau pisah dari oracle
  harus cari lagi cd nya

    Thanks



    > dear clara devi,
    >
    > untuk bisa connect dari oracle ke sql server, kamu harus intall
TG4MSQL
    > (Transparent Gateway for MS SQL Server) dulu, kalo kamu engga punya cd
    > installationya, kamu bisa download di oracle.com, ini saya kirim juga
    > petunjuk cara installnya dan cara connect ke sql servernya.
    >
    >

============================================================================
    > =================
    > PURPOSE
    > -------
    >
    > This article provides a step-by-step guide setting up and
  troubleshooting
    >
    > TG4MSQL (Transparent Gateway for MS SQL Server) for a Windows based
    >
    > platform. This note applies to TG4MSQL release 8.1.6.0.0 and
9.0.1.0.1 -
    >
    > both TG4MSQL versions use the MS SQL Server client library - as well
to
    >
    > release 9.2.0.1.1 which uses ODBC as connect method.
    >
    >
    >
    > SCOPE & APPLICATION
    >
    > -------------------
    >
    > This bulletin is a summary of the manual.
    >
    >
    >
    > How to setup TG4MSQL
    >
    > --------------------
    >
    >
    >
    > 1)
    >
    >  -For Oracle TG4MSQL V9.0.1 or 9.2:
    >
    >    With the OUI (Oracle Universal Installer) install
    >
    >    TG4MSQL. This product is part of the server
    >
    >    installation CDs.
    >
    >    ( Start OUI, choose a sep. Oracle_Home, select the Oracle
    >
    >      database for installation. Then choose custom install. A
    >
    >      product list pops up where you have to scroll down to
    >
    >      ORACLE TRANSPARENT GATEWAY; click on the '+' in front and
    >
    >      a product list opens. Choose the gateways you want to install)
    >
    >
    >
    >  -For Oracle TG4MSQL V816:
    >
    >    There is a separate CD containing Oracle Transparent Gateway
    >
    >    for MS SQL Server release 8.1.6. Insert this CD and install TG4MSQL
    >
    >    according to the screen messages.
    >
    >
    >
    >  -BOTH:
    >
    >    A directory called TG4MSQL will be created and a file called
    >
    >    TG4MSQL.EXE is placed in the bin directory of the appropriate
    >
    >    Oracle_Home.
    >
    >
    >
    >
    >
    > 2) TG4MSQL needs data dictionary tables in the Oracle database.
    >
    >    To check their existence, run a query on
    >
    >    i.e. SYS.HS_FDS_CLASS.
    >
    >    If it fails, run the caths.sql script located in
  ORACLE_HOME\RDBMS\ADMIN\
    >
    >    as user sys or internal.
    >
    >
    >
    > 3) Make sure for gateway version 8.1.6 (8i) and 9.0.1.0.0 (9iR1) that
  the
    >
    >    Microsoft client is installed on the gateway machine (at least it
is
    >
    >    sufficient that the MS SQL Server Client DLL (ntwdblib.dll ) is
  available
    >
    >    in the search path.
    >
    >    Perhaps copy the file into the bin directory of your Oracle_Home
    >
    >    installation.
    >
    >
    >
    >    For V9.2.0.1.2 (9iR2) gateways, the access method changed from the
  client
    >
    >    library to ODBC. So please make sure to have the MS SQL Server ODBC
    >
    >    driver installed on the gateway machine. If it is not available,
  download
    >
    >    the latest MDAC Microsoft Data Access Components) from the
Microsoft
  Web
    >
    >    page and install it. This package contains a SQL Server ODBC
driver.
    >
    >
    >
    >
    >
    > 4) Tnsnames.ora.
    >
    >    This file is in ORACLE_HOME\NETWORK\ADMIN.
    >
    >    Add the following lines to the file:
    >
    >
    >
    >    tg4msql.de.oracle.com  =         |<- adjust default domain
depending
  on
    >
    >                                         the sqlnet.ora settings
    >
    >       (DESCRIPTION=
    >
    >         (ADDRESS=(PROTOCOL=tcp)
    >
    >         (HOST=<HOSTNAME>)           |<- adjust hostname
    >
    >         (PORT=1521))                |<- adjust port
    >
    >         (CONNECT_DATA=(SID=tg4msql))
    >
    >         (HS=OK)                       |<- attention: HS is outside
    > CONNECT_DATA
    >
    >       )
    >
    >
    >
    >
    >
    >   Note, a sample file is located in ORACLE_HOME\tg4msql\ADMIN.
    >
    >
    >
    > COMMON ERRORS:
    >
    >   Make sure, that there are 2 closing brackets after the SID; the
    >
    >   HS keyword is outside of the Connect Data block.
    >
    >   Further make sure that only the TNS Alias is at the first position
of
  the
    >
    >   line; all other lines must start at least with one SPACE (blank);
    >
    >   otherwise it is identified as an alias and the configuration is not
    > correct.
    >
    >
    >
    > 5) Listener.ora:
    >
    >    This file is in ORACLE_HOME\NETWORK\ADMIN as well.
    >
    >    Add the following line to the SID_List of the listener.ora and
  restart
    > the
    >
    >    listener afterwards. ( After the restart a service handler for
  tg4msql
    >
    >    should exist).
    >
    >
    >
    >         (SID_DESC=
    >
    >            (SID_NAME=tg4msql)
    >
    >            (ORACLE_HOME=e:\ora92)  |<- adjust Oracle_Home directory
    >
    >            (PROGRAM=tg4msql)
    >
    >          )
    >
    >
    >
    >    Note, a sample file is located in ORACLE_HOME\tg4msql\ADMIN.
    >
    >
    >
    > COMMON ERRORS:
    >
    >    After configuring the listener, restart it from the command line
    >
    >    (lsnrctl -> stop, start) and check the service summary. It must
  contain
    >
    >    1 service handler for the TG4MSQL SID.
    >
    >
    >
    > 6) Adjust the configuration file of the gateway.  It is located in
    >
    >    ORACLE_HOME\TG4MSQL\ADMIN. The name depends on the SID you use for
  the
    >
    >    gateway.
    >
    >    In our sample the listener SID is tg4msql and so the configuration
  file
    >
    >    must be named inittg4msql.ora.
    >
    >
    >
    >    # This is a sample agent init file that contains the HS parameters
  that
    > are
    >
    >    # needed for an ODBC Agent.
    >
    >    #
    >
    >    # HS init parameters
    >
    >    #
    >
    >    HS_FDS_CONNECT_INFO = <servername>.<database>  |<- Please specify
the
    > server
    >
    >                                                       hostname and do
  not
    > use
    >
    >                                                       IP addresses.
    >
    >                                                       The dot is the
    > delimeter
    >
    >                                                       and we use it to
    > separate
    >
    >                                                       the servername
  from
    > the
    >
    >                                                       database name.
    >
    >    HS_FDS_TRACE_LEVEL = 0          |<- trace levels are from off to
  debug
    >
    >
    >
    >
    >
    > REMARK: Usually the following key is used to verify the connect
options
    >
    >   to the MS SQL Server:
    >
    >         HKEY_LOCAL_MACHINE\
    >
    >                            SOFTWARE\
    >
    >                                     Microsoft\
    >
    >                                               MSSQLServer\
    >
    >                                                           Client\
    >
    >
  ConnectTo
    >
    >   This information normally specifies the ALIAS, the real server name,
    > instances
    >
    >   (if they are available) and port numbers of the SQL Server.
    >
    >   Further details can be found in [NOTE:231997.1] TG4MSQL and MS SQL
    >
    >   Server Instances.
    >
    >
    >
    >
    >
    > 7) Testing the connectivity between Oracle database and the SQL
Server:
    >
    >    - create a database link within the Oracle database to the SQL
  Server:
    >
    >           create database link tg4msql connect to "sa"
    >
    >                identified by "<password of sa>" using 'tg4msql';
    >
    >    - select * from [EMAIL PROTECTED];
    >
    >
    >
    >   Example selecting a demo table of the MS Northwind database:
    >
    >    select "TerritoryID"  from "EmployeeTerritories"@<link name>;
    >
    >
    >
    > COMMON ERRORS:
    >
    >    The usernames, passwords, table names, views, columns ... are case
    > sensitive.
    >
    >    For creating the database link, make sure you surround the
username,
    > password
    >
    >    by double quotes and write them as they are defined in the MS SQL
  Server.
    >
    >
    >
    >    Another common error is, that the TG4MSQL does not allow OS
    > Authentication
    >
    >    (Windows Authentication) for the SQL Server. Only SQL Server
    > authentication
    >
    >    with a username AND a password is supported. Make sure, that the
SQL
    > Server
    >
    >    Security option is checked to allow both authentication methods.
    >
    >
    >
    >
    >
    > 8) Useful SQLServer commands.
    >
    >    sp_help - gives help on all the commands
    >
    >    sp_addlogin - sets up a login user account
    >
    >    sp_adduser - sets up a userid to use an individual database
    >
    >    use {database} - changes the database which sql is being targetted
    > against.
    >
    >    sp_droplogin - remove a user account
    >
    >    sp_dropuser - remove a user from a database.
    >
    >
    >
    >
    >
    >
    >
    >
    >
    >

############################################################################
    > #######
    >
    >
    >
    > COMMON ERRORS and SOLUTIONS
    >
    >
    >
    >

############################################################################
    > #######
    >
    >
    >
    > /********************************************************************/
    >
    > ORA-28509: unable to establish a connection to non-Oracle system
    >
    > ORA-02063: preceding line from TG4MSQL
    >
    > /********************************************************************/
    >
    > cause:
    >
    >     This indicates a problem with the Oracle configuration files.
    >
    > Action:
    >
    >     Make sure the HOST parameter in the tnsnames.ora file is correct.
    >
    >     Make sure the PORT number is correct.
    >
    >     Make sure the SID name is correct in both the TNSNAMES.ORA and
    > LISTENER.ORA
    >
    >
    >
    > /********************************************************************/
    >
    > ORA-28500: connection from ORACLE to a non-Oracle system returned this
    > message:
    >
    > [Transparent gateway for MS SQL Server] The environment variable
    >
    > <HS_FDS_CONNECT_INFO> is not set.
    >
    > ORA-02063: preceding 2 lines from TG4MSQL
    >
    > /********************************************************************/
    >
    > cause:
    >
    >     Incorrect parameter settings in the HS init.ora file.
    >
    > Action:
    >
    >     Check HS_FDS_CONNECT_INFO in the TG4MSQL init.ora file.
    >
    >     It might be missing or TG4MSQL is not able to find the correct
    >
    >     initialisation file.
    >
    >     Make sure the HS init.ora file exists in the
  ORACLE_HOME\tg4msql\admin
    >
    >     directory and has the same name as the SID in the LISTENER.ORA.
    >
    >     Example: If SID=mssql in the listener.ora file, then the nit.ora
  file
    >
    >     would be named ORACLE_HOME\hs\admin\initmssql.ora
    >
    >
    >
    > /********************************************************************/
    >
    > ORA-00942: table or view does not exist
    >
    > [Transparent gateway for ODBC]DRV_OpenTable: [Mircosoft ][ODBC SQL
  Server
    >
    > Driver][SQL Server]Invalid object name '%table%'. (SQL State: S0002;
SQL
    > Code:
    >
    > 208)
    >
    > ORA-02063: preceding 2 lines from TG4MSQL
    >
    > /********************************************************************/
    >
    > cause:
    >
    >     The init.ora file speciffies the wrong MS SQL Server database.
    >
    >     A second cause could be, that MS SQL Server tables are case
  sensitive
    >
    >     and thus should be surrounded by double quotes.
    >
    >

============================================================================
    > ========================
    >
    > smoga membantu
    >
    > salam,
    >
    > Irawan
    >
    >
    >
    >
    >
    > ----- Original Message -----
    > From: "Clara Devi" <[EMAIL PROTECTED]>
    > To: <[email protected]>
    > Sent: Thursday, August 04, 2005 2:26 PM
    > Subject: [indo-oracle] ODBC
    >
    >
    > > ALlow saya mohon bantuannya donk da pusing nih :)
    > > Saya mau connect dari oracle 8.0.5 ke SQL Server 2000, saya coba
  gunakan
    > ODBC.
    > > di System DNS  saya add berdasarkan SQL server dan step-step saya
  sudah
    > ikuti semua sampai Test Data Source .. Tests Completed successfully.
    > >
    > > Lalu langkah selanjutnya di orcle gimana ya.. pls tolong masukkannya
  donk
    > >
    > >
    > > Thanks B4
    > >
    > >
    > >
    > >
    > >
    > > [Non-text portions of this message have been removed]
    > >
    > >
    > >
    > >
    > > --
    > > -----------I.N.D.O - O.R.A.C.L.E---------------
    > > Keluar: [EMAIL PROTECTED]
    > > Website: http://indo-oracle.lizt.org (NEW)
    > > -----------------------------------------------
    > >
    > > Bergabung dengan Indonesia Thin Client User Groups,
    > > Terminal Server, Citrix, New Moon Caneveral, di:
    > > http://indo-thin.vze.com
    > > Yahoo! Groups Links
    > >
    > >
    > >
    > >
    > >
    > >
    > >
    > >
    > >
    >
    >
    > The contents of this e-mail may be confidential and the unauthorized
  use,
    > copying, or dissemination of it and any attachments to it, is
  prohibited.
    > Internet communications are not secure and Dexa Group companies do
not,
    > therefore, accept legal responsibility for the contents of this
message
  nor
    > for any damage caused by viruses. The views expressed here do not
  necessarily
    > represent those of Dexa Group companies.
    >
    >
    >
    >
    >
    > --
    > -----------I.N.D.O - O.R.A.C.L.E---------------
    > Keluar: [EMAIL PROTECTED]
    > Website: http://indo-oracle.lizt.org (NEW)
    > -----------------------------------------------
    >
    > Bergabung dengan Indonesia Thin Client User Groups,
    > Terminal Server, Citrix, New Moon Caneveral, di:
    > http://indo-thin.vze.com
    > Yahoo! Groups Links
    >
    >
    >
    >
    >
    >
    >
    >





  --
  -----------I.N.D.O - O.R.A.C.L.E---------------
  Keluar: [EMAIL PROTECTED]
  Website: http://indo-oracle.lizt.org (NEW)
  -----------------------------------------------

  Bergabung dengan Indonesia Thin Client User Groups,
  Terminal Server, Citrix, New Moon Caneveral, di:
  http://indo-thin.vze.com
  Yahoo! Groups Links











  --
  -----------I.N.D.O - O.R.A.C.L.E---------------
  Keluar: [EMAIL PROTECTED]
  Website: http://indo-oracle.lizt.org (NEW)
  -----------------------------------------------

  Bergabung dengan Indonesia Thin Client User Groups,
  Terminal Server, Citrix, New Moon Caneveral, di:
  http://indo-thin.vze.com
  Yahoo! Groups Links












--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------

Bergabung dengan Indonesia Thin Client User Groups, 
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com 
Yahoo! Groups Links



 






------------------------ Yahoo! Groups Sponsor --------------------~--> 
<font face=arial size=-1><a 
href="http://us.ard.yahoo.com/SIG=12h5e4th3/M=362335.6886445.7839731.1510227/D=groups/S=1705007183:TM/Y=YAHOO/EXP=1123474465/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In
 low income neighborhoods, 84% do not own computers. At Network for Good, help 
bridge the Digital Divide!</a>.</font>
--------------------------------------------------------------------~-> 

--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------

Bergabung dengan Indonesia Thin Client User Groups, 
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/indo-oracle/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 


Kirim email ke