Re: Configure Informix Enterprise Gateway example

Posted in 2006

Pero — Tue, 28 Mar 2006 13:50:22 +0200 — source: Usenet: comp.databases.informix

It works. Now I have problem with code page. When I try to insert data with 8 bits content 8859-1 I receive error message, ordinary data works correctly. Do You have any idea ? Pero On Thu, 16 Mar 2006 17:05:59 +0100, Marion Sussujew <marions777@online.de> wrote: >Hi, > >1. configure Oracle for ODBC >This includes defining a datasource and starting a listener. > I did it some time ago and don't remember all the details. > >2. Configure the informix side: > >example sqlhosts >---------------- ># IDS >on940fc7 onipcshm sunny on940fc7 >on940fc7tcp ontlitcp sunny 1801> ># Gateway >idsgw ontlitcp sunny 1900> >3. Configure the gateway side > >- edit odbc.ini >- configure gateway and start the daemon as desribed in the user's guide > >4. Connecting to Oracle from dbaccess: > >SELECT * FROM oradsn@idsgw:"INFORMIX".oratable> >where oradsn is the Oracle data source. > >Please ask again if you consider problems. Especially executing stored >procedures is a little bit tricky. > >Have a lot of fun :-) >Marion > >Pero wrote: > >>Does anybody know how sholuld I configure >>informix enterprise gateway for oracle connection ? >> >>Pero >> >> >>