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

installing DBD-Informix on fedora 6

2007-01-29 Thread Oliver Howe
hi, i am having some problems installing DBD-Informix-2005.02 on fedora6. i get stuck at perl rmautoinst.pl Makefile.PL | perl - when the esqltest program tries to contact my stores database and times out. but i'm pretty sure i am following the right steps as it works fine on other versions

Re: installing DBD-Informix on fedora 6

2007-01-29 Thread Tielman de Villiers
On 29/01/07, Oliver Howe [EMAIL PROTECTED] wrote: i am having some problems installing DBD-Informix-2005.02 on fedora6. i get stuck at perl rmautoinst.pl Makefile.PL | perl - when the esqltest program tries to contact my stores database and times out. this is what I do on fedora 4 perl

Re: installing DBD-Informix on fedora 6

2007-01-29 Thread Tielman de Villiers
On 29/01/07, Oliver Howe [EMAIL PROTECTED] wrote: SQL: -908: Attempt to connect to database server (pmuk2) failed. ISAM: 107: ISAM error: record is locked. Seems to suggest you are connecting to the database. Can you trace any TCP traffic on the server side? no i dont see anything from

Re: installing DBD-Informix on fedora 6

2007-01-29 Thread Oliver Howe
pmuk2 onsoctcp dbpmuk2.uk1.bibliotech.net sqlexec k=1 Seems all right. Can you post the relevant entry from /etc/services? $ tail -4 /etc/services # Local services sqlexec 1526/tcpinformix sqlispy 1527/tcpinformix sqlispy11528/tcp

Re: installing DBD-Informix on fedora 6

2007-01-29 Thread Oliver Howe
hi, here is my sqlhosts file demo_on onipcshmon_hostname on_servername demo_se seipcpipse_hostname sqlexec pmuk2 onsoctcp dbpmuk2.uk1.bibliotech.net sqlexec k=1 Have you exported DBD_INFORMIX_DATABASE DBD_INFORMIX_USERNAME DBD_INFORMIX_PASSWORD no,

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: 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 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 '\\'. You can

RE: DBD::DB2 Error

2007-01-29 Thread Brimacomb, Brent
I finally got past the license issue. It looks as though the DB2 9 I downloaded off the net was an evaluation copy? I had to go back to DB2 8.2, which I had real a CD copy of. That got rid of the License issue, but now I seem to have another issue. It looks like the database name variable

Re: installing DBD-Informix on fedora 6

2007-01-29 Thread Oliver Howe
no i dont see anything from that server when running the esqltest. but on the client i can telnet to the server on port 1526 as the user informix. i have stopped iptables and ip6tables on the client can you snoop on the server to see if any packets reach the interface at all when running

DBD::Oracle-1.19 installation errors

2007-01-29 Thread Pham, Tri
To DBI support group, I try to install DBD::Oracle-1.19 on our IBM AIX 5.3 server. Perl 5.82. I got these errors when I run the command make test. I already ran perl Makefile.PL and make which have no error. I appreciate for your help. [EMAIL PROTECTED]:/workarea/DBI/DBD-Oracle-1.19#

Oracle DBD runtime error

2007-01-29 Thread Terry Maragakis
I just installed DBI and Oracle DBD. I can run the following program without error as root: #!/bin/perl -w use DBI; use DBD::Oracle; my $dbh=DBI-connect(dbi:Oracle:DWHDEVR1,scott,tiger); $dbh-disconnect(); But when I try to run it under my own user ID I get the following

RE: Oracle DBD runtime error

2007-01-29 Thread Matthew Ramadanovic
I don't know about 10 but on 9.2.0.4 you need to make sure to set up your environment correctly. I usually have to set all of the following variables with values like so : LD_LIBRARY_PATH=/export/home/oracle/product/9.2.0/lib:/export/home/oracl

Re: installing DBD-Informix on fedora 6

2007-01-29 Thread Jonathan Leffler
On 1/29/07, Oliver Howe [EMAIL PROTECTED] wrote: no i dont see anything from that server when running the esqltest. but on the client i can telnet to the server on port 1526 as the user informix. i have stopped iptables and ip6tables on the client can you snoop on the server to see if any