[archive] mssql connectioin on unix server

[Migrated content. Thread originally posted on 28 February 2008]

Hi,
We have a unix server where we use vision files. Now I need to read data from a MSSQL database on a windows NT server.
Can anybody tell which product I can use best. I am trying Acu4Gl for MSSQL but I can't get it to work. Is it possible to use this product for unix ?

No, you can not use Acu4GL on Unix to access MSSQL as Microsoft does not provide drivers for Unix to access MSSQL. To do what you want to do, you need to have your file i-o operations be in stand alone programs. Once you have your file i-o in these spearate programs, you can then use AcuConnect distributed processing. ProgramA on Unix calls "file-io" and file-io gets executed on a remote machine (Windows) where you have the Acu4GL for MSSQL runtime configured to use your MSSQL database.