[EMAIL PROTECTED] wrote:
> Big Brother tells me that Neil Lunn wrote:
> >
> > Umm Jack. The main point was to see if there was a difference between isql
> > and DBD::ODBC.
> > isql should allow you to use the same connect string that you are suppling
> > to DBD::ODBC, so if you can supply a DSN'less connect to isql, the same
> > string can be used for DBD::ODBC.
>
> EXACTLY!! This is the point I have been trying to make. The DSN works
> just fine.
>
> > Now at the end of the day, if this fails as before there is something wrong
> > with DBD::ODBC, but if it works then something is up with how odbc.ini is
> > being processed.
>
> This has been my conclusion. Since unixODBC+FreeTDS is working outside
> of perl, the only new element is DBD::ODBC.
Yes, but ODBC is not that clear cut. There are many ways to do the same thing,
one set of ways may work using isql (for instance), but DBD::ODBC may use another
set of ways, this doesn't mean its DBD at fault, it could still be the driver,
not doing what it should.
Have you tried creating a ODBC trace of what is going on, that may help (send me
a copy if you want.)
--
Nick Gorham
Easysoft Ltd
