Perl: the Markov chain saw | |
PerlMonks |
Re^2: module & MSSQL driver recommendations for linuxby ksublondie (Friar) |
on Sep 19, 2012 at 19:19 UTC ( [id://994504]=note: print w/replies, xml ) | Need Help?? |
It looks like the sql server is running v 10.0.1600.
I've tried this in multiple tables and multiple dbs, all on the same sql server, using a modified version of the code from the DBD::Sybase documentation. One of my attempts is shown in the node referenced in my OP: sql2008 Filestream. The current table configuration in this example has col 1 varchar(40), col 2 datetime, col 3 uniqueidentifier, col 4 varchar(50), and col 5 varbinary(MAX) where col 5 is the column I'm trying to use as the blob column. My latest attempt is on a different db, same server, into col 7 where the table is as follows: col 1 int, col 2, int, col 3 varchar(50), col 4 money, col 5 varchar(20), col 6 bit, col 7 image, col 8 varchar(MAX).
(Forgive the obvious sql injection problems. I plan on fixing this once I can get the d@mned thing to work!) In all my attempts so far, I get the identical error as I posted in sql2008 Filestream and with the poster in inserting images in ms sql server.
I've been able to successfully insert/update blobs from windows scripts to this server on the same tables, but haven't had any luck with the FreeTDS/mssql combination. Pray tell, WHICH drivers work?
In Section
Seekers of Perl Wisdom
|
|