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@sgs.o.se                                   |
| Network and Software Engineer                     SGS Datanätgrupp   |
|                                                   Gothenburg, Sweden |
\----------------------------------------------------------------------/