Linked tables


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Linked tables

  1. #1
    Danny Depecker Guest

    Linked tables


    Colleagues,

    I have the following situation:

    On a Windows NT platform, a program developped in Visual Basic 6.0 with an
    ODBC-connection to an Access-database. But in the Access-database, there
    are several linked tables to an ORACLE database.
    In the ACCESS environment, there's is no problem writing in the linked tables
    towards ORACLE.
    But, out of my VB6 application it is only possible to read data in linked
    access table . Writing or modifying into this linked table to ORACLE always
    returns an ODBC error call.

    When I make the same setup on a Windows 2000 platform, everything (reading,
    writing in the ORACLE linked Access-table) works just perfect!

    QUESTION:

    Can anyone give me a hint how I can make this work on the NT4.0 platform
    or why it is not possible to make it work on NT4.0?


    Thanks.


  2. #2
    Michael McGrath emtsolutions.com Guest

    Re: Linked tables


    It sounds like you are using a newer version of the ODBC drivers with Windows
    2000, however there are better ways to get to the data besides using linked
    tables in Access buy going through vb6/ado directly.

    Mike


    "Danny Depecker" <dd@vanas.be> wrote:
    >
    >Colleagues,
    >
    >I have the following situation:
    >
    >On a Windows NT platform, a program developped in Visual Basic 6.0 with

    an
    >ODBC-connection to an Access-database. But in the Access-database, there
    >are several linked tables to an ORACLE database.
    >In the ACCESS environment, there's is no problem writing in the linked tables
    >towards ORACLE.
    >But, out of my VB6 application it is only possible to read data in linked
    >access table . Writing or modifying into this linked table to ORACLE always
    >returns an ODBC error call.
    >
    >When I make the same setup on a Windows 2000 platform, everything (reading,
    >writing in the ORACLE linked Access-table) works just perfect!
    >
    >QUESTION:
    >
    >Can anyone give me a hint how I can make this work on the NT4.0 platform
    >or why it is not possible to make it work on NT4.0?
    >
    >
    >Thanks.
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center