Re: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server

2007-02-28 Thread Martin Evans
det: Dienstag, 30. Januar 2007 15:54 An: dbi-users@perl.org Betreff: Re: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server Mickautsch, Alfred wrote: -Ursprüngliche Nachricht- Von: Martin Evans [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 30. Januar 2007 12:40 An: dbi-users@perl.org Be

AW: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server

2007-02-28 Thread Mickautsch, Alfred
ECTED] > Gesendet: Dienstag, 30. Januar 2007 15:54 > An: dbi-users@perl.org > Betreff: Re: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server > > > Mickautsch, Alfred wrote: > >> -Ursprüngliche Nachricht- > >> Von: Martin Evans [mailto:[EMAIL PROTECTED

Re: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server

2007-01-30 Thread Martin Evans
Mickautsch, Alfred wrote: -Ursprüngliche Nachricht- Von: Martin Evans [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 30. Januar 2007 12:40 An: dbi-users@perl.org Betreff: Re: AW: AW: Re: AW: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server [...] I insert 24 chars (16 \ and 8 line

AW: AW: AW: Re: AW: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server

2007-01-30 Thread Mickautsch, Alfred
> -Ursprüngliche Nachricht- > Von: Martin Evans [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 30. Januar 2007 12:40 > An: dbi-users@perl.org > Betreff: Re: AW: AW: Re: AW: CLOB Problem with DBD::ODBC/DBD::ADO for > SQL Server [...] > I insert 24 chars (16 \ and 8

Re: AW: AW: Re: AW: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server

2007-01-30 Thread Martin Evans
Mickautsch, Alfred wrote: -Ursprüngliche Nachricht- Von: Martin Evans [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 30. Januar 2007 10:44 An: dbi-users@perl.org Betreff: Re: AW: Re: AW: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server [...] what version of sql server are you using

AW: AW: Re: AW: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server

2007-01-30 Thread Mickautsch, Alfred
> -Ursprüngliche Nachricht- > Von: Martin Evans [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 30. Januar 2007 10:44 > An: dbi-users@perl.org > Betreff: Re: AW: Re: AW: CLOB Problem with DBD::ODBC/DBD::ADO for SQL > Server [...] > > what version of sql serv

Re: AW: Re: AW: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server

2007-01-30 Thread Martin Evans
Mickautsch, Alfred wrote: -Ursprüngliche Nachricht- Von: Martin Evans [mailto:[EMAIL PROTECTED] Gesendet: Montag, 29. Januar 2007 17:25 An: dbi-users@perl.org Betreff: [EMAIL PROTECTED] - Bayesian Filter detected spam - Re: AW: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server

AW: Re: AW: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server

2007-01-30 Thread Mickautsch, Alfred
> -Ursprüngliche Nachricht- > Von: Martin Evans [mailto:[EMAIL PROTECTED] > Gesendet: Montag, 29. Januar 2007 17:25 > An: dbi-users@perl.org > Betreff: [EMAIL PROTECTED] - Bayesian Filter > detected spam - Re: AW: CLOB Problem with DBD::ODBC/DBD::ADO > for SQL Ser

RE: AW: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server

2007-01-29 Thread Ronald Kimball
Martin Evans [mailto:[EMAIL PROTECTED] wrote: > > The first issue is the back slashes in the here document. > > my $text = <<_EOF; > hello > _EOF > print length($text), "\n"; > > prints 8 not 10 because \\ in a here document ends up as \. > So half of > your '' go straight away to '\

Re: AW: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server

2007-01-29 Thread Martin Evans
Martin Evans wrote: Mickautsch, Alfred wrote: -Ursprüngliche Nachricht- Von: Martin Evans [mailto:[EMAIL PROTECTED] Gesendet: Montag, 29. Januar 2007 09:43 An: dbi-users@perl.org Betreff: Re: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server [...] As no one else seems to have

Re: AW: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server

2007-01-29 Thread Martin Evans
Mickautsch, Alfred wrote: -Ursprüngliche Nachricht- Von: Martin Evans [mailto:[EMAIL PROTECTED] Gesendet: Montag, 29. Januar 2007 09:43 An: dbi-users@perl.org Betreff: Re: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server [...] As no one else seems to have replied to you, if you can

Re: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server

2007-01-29 Thread Martin Evans
Mickautsch, Alfred wrote: Hello, I have a problem with inserting CLOBS into a SQL Server database. With the attached scripts, we replicate table data schema between different databases. These databases are located on different servers running Oracle, DB2 and SQL Server. We use Activestate perl

CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server

2007-01-26 Thread Mickautsch, Alfred
Hello, I have a problem with inserting CLOBS into a SQL Server database. With the attached scripts, we replicate table data schema between different databases. These databases are located on different servers running Oracle, DB2 and SQL Server. We use Activestate perl 5.8.0 on Windows 2000 and X