perl DBD on Linux -> MS SQL

[TheHobbit]

Has anyone managed to do this?

I normally use DBD to talk to a MySQL server, but I need to throw some rows across to a MS SQL box.

I'm attempting to use DBD::ODBC (unixODBC) and FreeTDS. isql can connect no problems, and tsql can connect no problems. I can select rows (to prove a point) in either.

Having tried many combinations, and having done a lot of RTFM and STFW, I can't get perl DBD to talk to it at all. It says "dbd_db_login/SQLSetConnectOption err=-2" as an error code....

Anyone done this? All and any help gratefully received.

Cheers,

Karl