Re: Remote ODBC connection

DoBBs wrote: > > We are looking at creating a website for a customer, who runs a Strategix > (based on Informix) DB. > They wish to have a website that accesses data from this DB, and displays > the results. We are well used to achieving this with SQL Server, but have > little experience with other platforms. > The client has SCO Vision SQL Retriever running with ODBC drivers, and I > need to know how we can query the database via this or alternatively through > Informix ODBC driver, from an externally held web server. > This will be running through a firewall aswell for obvious reasons. SQL-Retriever has a JDBC driver included already which means you will be able to display data from the database on a web-page. Effectively, a Java applet running in a webpage connects to the SQL-Retriever process running on the UNIX box already which connects to the database. Be careful about design and security (although you note you are familiar with doing this with SQL Server, so please excuse the "grandmother" and "eggs" scenario: apology offered if necessary!). It would appear you already have enough software to make the connection, you shouldn't need to buy any more. You will, however, need to do some Java coding! For more info on SQL-Retriever, see http://www.sql-retriever.freeserve.co.uk/ or more explicitly for SQL-Retriever & JDBC http://www.sql-retriever.freeserve.co.uk/library/README.HTM Enjoy! Haddock!