Oninit cdi / Archive
Talk to an expert →

Re: Along the lines of SQL server (was:General Questions From Informix Newbie)

Posted in 1998

Nils Myklebust — — source: Informix-list mailing list archive (1991-1998)

On 24 Aug 1998 22:23:48 GMT, newhorizon@aol.com (NewHorizon) wrote: >I just hate asking dumb questions - doncha hate reading them? - but... > >A customer has an MS-Access database and MS-SQL server. >We've got Netscape's Entprise Server Pro w/Infomix under IRIX. >My level of knowledge doesn't go deeper than SQL. I can't seem >to get dbaccess to connect to the remote server - tho' I can't say yet >that my sqlhosts or onconfig files are necessarily correct. > >Anyway, I see references to Informix Enterprise Gateway. Do I need >this thingie to connect to a non-Informix database? (In the end, the >connection would be made using Server-Side JavaScript, not dbaccess.) To get dbaccess to connect to your Informix server on IRIX you need nothing but I-Connect on the the machine where you run dbaccess assuming the Informixserver is ver. 7.x or later. If it's version 5.x or earlier you also need I-Star on the server. However I think only version 7.x have been distributed with the Netscape products. For server side JavaScript I don't know exactly what you need. If the web server and the Informix server is on the same machine I assume you should need nothing but the products from Netscape. If the Informixserver is on another machine you probably need only I-Connect on the web server machine. If that isn't included with the Netscape products you can download it for free from http://www.intraware.com if you run your web server on one of the machines that realease is available for. Otherwise you can easily get it from Informix If you intend to connect from an Informix product like dbaccess to your MS-SQL server you would need a product like Informix Enterprise Gateway. I don't know if that supports MS-SQL server. If it doesn't there should be other products available that can give you such connectivity. Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)