Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Iamblue

    Insert/update on Informix db through linked server

    Hi! This is the configuration: System DSN: -Name: Geminix -Controler: Tun32 driver The controler is configured as follows: -Data Source name: Geminix (this is the name of the informix database) -Description:Geminix -Server:the IP address of the server -Service:TUNODBC200.ifx...
  2. Iamblue

    Insert/update on Informix db through linked server

    Hi! Thanks for you answer! Well, I tryed what you said, but it did´t work.This is the error I always get: Servidor: mensaje 7399, nivel 16, estado 1, línea 3 El proveedor OLE DB 'MSDASQL' informa de un error. [OLE/DB provider returned message: Error no especificado] [OLE/DB provider returned...
  3. Iamblue

    Insert/update on Informix db through linked server

    Ops!, by the way, this is the sql sintax I am using to perform querys: 1-SELECT select * from openquery(Linked_server_name,'select * from Informix_Table'). This works fine 2-UPDATE update openquery(Linked_server_name,'select * from Informix_Table') set Informix_Table.col2 = 'value2'...
  4. Iamblue

    Insert/update on Informix db through linked server

    Hi everybody! I have the following problem: I need to perform inserts and updates on an Informix database through a linked server. The linked server uses esker's Tun 2005 odbc connector to connect to informix (Tunodbc200.ifx). I am able to perform selects to Informix database, but when...

Part and Inventory Search

Back
Top