Re: DBD::ODBC SQL-08S01 On Multiple Database Joins

2009-06-30 Thread Martin J. Evans
Chase Putans wrote: Finding some odd and intermittent issues with DBD::ODBC when doing multiple database joins. If I do a multiple database join as in the SQL below, and do not have a where clause, or have a where clause and do not bind values, I get an SQL-08S01: "Read from SQL server failed".

DBD::ODBC SQL-08S01 On Multiple Database Joins

2009-06-30 Thread Chase Putans
Finding some odd and intermittent issues with DBD::ODBC when doing multiple database joins. If I do a multiple database join as in the SQL below, and do not have a where clause, or have a where clause and do not bind values, I get an SQL-08S01: "Read from SQL server failed". If I remove one of th

Re: DBD::ODBC make test fails - unixODBC/Easysoft/SQL Server 2008

2009-06-30 Thread Scott Stansbury
Yes. Thank you again. Best regards, Scott... On Jun 30, 2009, at 11:52 AM, Martin Evans wrote: Scott Stansbury wrote: Getting closer :) I'm trying to connect to a SQL Server 2008 instance from a CentOS5 box: unixODBC: 2.2.14 FreeTDS:0.82 Easysoft: odbc-sqlserver-1.1.26-linux-x

Re: DBD::CSV - UPDATE corrupts data!

2009-06-30 Thread Alexander Foken
Hello, On 30.06.2009 14:41, Robert Roggenbuck wrote: Hi all, I stumbled over somthing very strange: When I try to update data in a table, the input parameters are going into the right fields - exept the first data row in the table / file. Below is a script which demonstrate the thing. Runni

Re: DBD::ODBC make test fails - unixODBC/Easysoft/SQL Server 2008

2009-06-30 Thread Martin Evans
Scott Stansbury wrote: > Getting closer :) > > I'm trying to connect to a SQL Server 2008 instance from a CentOS5 box: > > unixODBC: 2.2.14 > FreeTDS:0.82 > Easysoft: odbc-sqlserver-1.1.26-linux-x86 (this morning, thank you > again Martin and Wez...) > > osql/isql work fine with both t

Re: Very slow mail-transport to the list

2009-06-30 Thread Éric Cholet
Le 30 juin 09 à 15:02, Robert Roggenbuck a écrit : During the last months I recogrise that Emails I sent to the list needing an unusual long time to sent back to me - around 4 hours, sometimes some hours more. But yesturday my mail needed more than 21 hours to reach the list (or at least me

Very slow mail-transport to the list

2009-06-30 Thread Robert Roggenbuck
During the last months I recogrise that Emails I sent to the list needing an unusual long time to sent back to me - around 4 hours, sometimes some hours more. But yesturday my mail needed more than 21 hours to reach the list (or at least me). I sent it an 10:10 GMT and reached my today at 7:20 G

Out of memory! error

2009-06-30 Thread sanju thomas
Hi, I am not sure if this is the right location to post this question. I am relatively new user to perl DBI DBD. I am presently getting an "Out of memory!" error when i run a perl script. Please find the details regarding the same I have two applications( consider application A and B)I am not a

DBD::CSV - UPDATE corrupts data!

2009-06-30 Thread Robert Roggenbuck
Hi all, I stumbled over somthing very strange: When I try to update data in a table, the input parameters are going into the right fields - exept the first data row in the table / file. Below is a script which demonstrate the thing. Running the first time, it creates the table 'Projects' and

RE: Setting up ODBC connection on Linux for using DBD::ODBC

2009-06-30 Thread Dhanashri Bhate
Hi Martin, There were 3 problems - Permissions on .so file were not right , I was using a wrong .ini (the one with a wrong .so file name instead of libsqora.so), Library path did not include Oracle lib. After correcting that things are working well - with isql and Perl scripts using DBD::ODBC. T

Re: Setting up ODBC connection on Linux for using DBD::ODBC

2009-06-30 Thread Martin Evans
Dhanashri Bhate wrote: > Thanks Martin, > After setting up the ODBC, I am trying to connect to the database, with a > script as below > --- > #!/usr/bin/perl > use strict; > use warnings; > > use DBI; > > my $dbh;# the database handle > > my $dsn = "DBI:ODBC:orcl" ;

Re: Insert records in table with perl DBD::Mysql

2009-06-30 Thread Robert Roggenbuck
If You use do() with placeholers / bind variables, You have to put a 'undef' between the SQL-statement and the variable list. This gap is reserved for a poiter to an argument hash (which is very seldom used). You see this in the second example of the DBD::Mysql-documentation. Greetings Robert