Re: SQL server application porting headache

Gregory Seidman wrote:
> Oskar Berggren sez:
> [...]
> } I'm getting ready to give up and recommend to my bosses that we hire
> } a consultant to run the darn thing on Windows and SQL Server. Which
> } I suppose means that Microsoft has succeeded with their little strange
> } case-sensitivity trick. Anyway, I will talk to the head developer
> } at the company that made the application tomorrow and we'll see what
> } happens.
>
> Hm. Perhaps you could mess with the ODBC driver (and install it under a
> different name, I expect) so that it lowercases everything not in single
> quotes, and strips double quotes. It's a hack, but it sounds like it would
> work plausibly at a small performance cost.

Perhaps, but only if I can use the open driver. Right now I'm
using a commercial driver from openlinksw.com because I couldn't get
the open one to support dynasets.

regards,
Oskar

--
/----------------------------------------------------------------------\
| Oskar Berggren beo(at)sgs(dot)o(dot)se |
| Network and Software Engineer SGS Datanätgrupp |
| Gothenburg, Sweden |
\----------------------------------------------------------------------/