SQL Server and IDS

Posted in 2006

Keith Simmons — Thu, 28 Sep 2006 15:02:06 +0100 — source: Usenet: comp.databases.informix

My application programmers have a requirement to run parametised queries from SQL Server/Access against an IDS 9.4 engine on AIX. Using IBM ODBC drivers isn't working as SQL Server seems to insist on pulling entire tables back and filtering itself. openquery() is not an option as its queries cannot be parametised or built 'on the fly'. Anyone encountered a similar problem? How did you reslove it, any product known that handles this type of connection more gracefully allowing IDS to do its work and just return the results of a query? Keith