Re: using DBD::CSV with REAL numbers

2004-04-13 Thread Jeff Zucker
Joseph Paish wrote: does DBD::CSV not work with REAL numbers? Yes, it works fine with REAL numbers. $sth = $dbh->prepare("CREATE TABLE customer (custID INTEGER NOT NULL, family CHAR(30) NOT NULL, given CHAR(30

Navision Attain

2004-04-13 Thread Anton Tokar
Hello, is there someone, who sucessfully connected to Navision Attain native database engine? I tried hard, but I can't do it. I think problem is in the connect string, DSN definition, or maybe I'm using wrong driver? DBD::ODBC Thanks Tono

Re: Connecting to MS SQL 2000

2004-04-13 Thread Michael Peppler
On Tue, 2004-04-13 at 13:47, Elliott, Andrew wrote: > >From the information I have gathered, I need freeTDS, and the > DBD::Sybase module. The problem is that I am having a heck of a time > getting the freeTDS to compile. Part of the problem may be due to the > fact that all the documentation I c

Connecting to MS SQL 2000

2004-04-13 Thread Elliott, Andrew
This question may have been asked before, but I have been unable to find any specific references to it. I am running Solaris 8 and want to know what to install to get Perl DBI to talk to MS SQL 2000. >From the information I have gathered, I need freeTDS, and the DBD::Sybase module. The problem i

RE: DBI connect('','/',...) failed: ERROR OCIEnvInit

2004-04-13 Thread Andy Hassall
You can happily connect to an 8i instance with a 9i-compiled DBD::Oracle, and vice versa. But your libraries must match those that DBD::Oracle was compiled against. If it was 8i, your ORACLE_HOME and LD_LIBRARY_PATH have to point to the 8i home. > When making a connection to an 8i instance, all w

RE: DBI connect('','/',...) failed: ERROR OCIEnvInit

2004-04-13 Thread Reidy, Ron
Andy, Thanks for the reply. DBD::Oracle was originally compiled against 8i only. When making a connection to an 8i instance, all works well.When making a connection against 9i, the error occurs. I was wondering if there may be a difference in libs, and this seems to point to that. Do I

RE: DBI connect('','/',...) failed: ERROR OCIEnvInit

2004-04-13 Thread Andy Hassall
> I am getting the above error when attempting to connect to > anOracle 9.2 instance (9.2.0.4.0). This instance was > recently upgraded from Oracle 8.1.7.4.0 The first thing to check is that perhaps you're trying to run a DBD::Oracle compiled against 8i with a 9i set of libraries - or vice vers

RE: Compiling and running DBD for Oracle 10g without installing Oracle

2004-04-13 Thread Andy Hassall
>the Oracle installer was > complaining about my version of Linux. It wasn't red-hat > enough for it's > taste. FYI, you can bypass this using the -IGNORESYSPREREQS flag to runInstaller. Or search Google for the other more elegant method, which involves editing a parameter file to include your op

using DBD::CSV with REAL numbers

2004-04-13 Thread Joseph Paish
does DBD::CSV not work with REAL numbers? the reason i ask is that the following piece of code works : (apologies for the word wrap) #!/usr/bin/perl -w use DBI; $dbh = DBI->connect("DBI:CSV:f_dir=./db") or die "Cannot connect :" . $DBI::errstr ; $sth = $dbh->prepare

Compiling and running DBD for Oracle 10g without installing Oracle

2004-04-13 Thread BLACH Johannes
Hello, I recently had to compile the DBD modules for Oracle 10g on machines, where I wasn't able to install Oracle. To save others the pain of figuring out this on their own, here's a short article of the type I was hoping to find in the first place. These instructions worked on Sun Solaris 9 and

Compiling and running DBD for Oracle 10g without installing Oracle

2004-04-13 Thread BLACH Johannes
Hello, I recently had to compile the DBD modules for Oracle 10g on machines, where I wasn't able to install Oracle. To save others the pain of figuring out this on their own, here's a short article of the type I was hoping to find in the first place. These instructions worked on Sun Solaris 9

Re: DBD::Oracle: which Oracle9i client components needed?

2004-04-13 Thread Marko Asplund
i managed to solve my problem. the missing component was 'Oracle Call Interfaces'. strangely, on Solaris 8 this component was not available in the Oracle9i (64-bit) installer if i chose the client installation (though it is available on Linux and 64-bit HP-UX)! i had to first choose Oracle9i Cl

Re: Problem with rename function call in perl

2004-04-13 Thread Tim Bunce
Please do not abuse the dbi-users list by asking non-DBI related questions. Thank you. Tim. On Tue, Apr 13, 2004 at 10:02:06AM +0530, Thutika, Srinivas (ODC - Satyam) wrote: > HI, > > The rename function in perl having some limitation as below.(Will > not work across file system boundarie