Re: Weird Problem: Execute fails unless run through the debugger

On Wed, Nov 28, 2001 at 05:10:54PM -0800, Alan Hogue wrote: > I am really baffled by this behavior. Does anyone have any idea what's > going on? > > I have to get some data from a visual foxpro db. I'm using activestate > perl 5.6.1 on Windows 2000. DBI 1.14, DBD::ODBC 0.28. > > As far as I can

Re: examples of type_info

Hello Dan, Look at the tests for DBD::ADO and DBD::ODBC. The type_info is used to convert a standard SQL type to a source specific. An example would be a SQL_VARCHAR. When you type_info(SQL_VARCHAR) you get the "best" possible data type match for that so

examples of type_info

Hi I know the definitions, syntax are in the doco, but can someone send me some concrete examples of type_info being used? Thanks Dan

Weird Problem: Execute fails unless run through the debugger

Hello, I am really baffled by this behavior. Does anyone have any idea what's going on? I have to get some data from a visual foxpro db. I'm using activestate perl 5.6.1 on Windows 2000. DBI 1.14, DBD::ODBC 0.28. As far as I can tell, the code is perfectly ordinary and straightforward: ___

RE: HP-UX 11.0

Ja, I have offered to include this in the README.hpux (with appropriate credits to the person who provides the recipe), if someone will provide the recipe. The recipe must be step by step, and include all the steps necessary to get it to work. No one has provided this. (And I do not have time t

Copying Informix Databases across servers

Hi all, I am not sure if I will find answer here, but I am going to try anyways. We want to copy a huge database from one informix server to another one, both server are on the same LAN newtork. What we are thinking to do is, writing a perl script that uses DBI and DBD::Informix, this script wi

Re: HP-UX 11.0

On Wed, Nov 28, 2001 at 10:48:07AM -0800, "Wilson, Doug" <[EMAIL PROTECTED]> wrote: > > > From: David L. Good [mailto:[EMAIL PROTECTED]] > > > > Unfortunately, the problem is that there is no generally > > known way to build > > DBD::Oracle with gcc. There are rumors that it is possible, > >

DBD-Oracle and Cygwin

Hi has anyone got dbd-roacle to work with Cygwin? I tried the following dlltool --input-def oci.def --output-lib liboci.a before running perl Makefile.PL, which returned the following Checking if your kit is complete... Looks good Note (probably harmless): No library found for -loci <--

RE: HP-UX 11.0

> From: David L. Good [mailto:[EMAIL PROTECTED]] > > Unfortunately, the problem is that there is no generally > known way to build > DBD::Oracle with gcc. There are rumors that it is possible, > but nobody has > published a procedure to get it to work. Are you talking about just on HP-UX spec

Re: HP-UX 11.0

On Tue, Nov 27, 2001 at 10:25:10PM -0800, Jonathan Leffler <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > > Did you see README.hpux in DBD::Oracle? > > > > If you are using the cc that comes with HP-UX (and not one of the > > compilers you have to pay for), you are out of luck. That

RE: Problem installing DBI on WIN2000

Why are you trying to compile DBI. Use ppm to install the binary. The latest 1.20 is on www.xmlproj.com/PPM repository. Use these commands to install ppm set repository XMLPROJ www.xmlproj.com/PPM ppm install DBI-1_20 This should install the latest DBI. Ilya -Original Message- Fro

RE: Problem installing DBI on WIN2000

Not a perl or dbi question, but from the ActiveState docs... You can get nmake from http://download.microsoft.com/download/vc15/Patch/1.52/W95/EN-US/Nmake15.exe .. Nmake comes with VC++ if you have that. If you do, you need to put it in your PATH or copy it somewhere that's already included in

Problem installing DBI on WIN2000

I'm trying to install DBI on my win2000 machine. I've sucesfully executed perl makefile.pl and I'm unable to execute make or nmake or dmake after. I searched my machine and didn't find make/nmake/dmake. What did I do wrong ? Thank you fro your help. Sam Tuen Muk

Oracle.so prob on AIX

hi i am having the Oracle.so file not found prob on AIX anyone knows from where and how i can rum the makefile.pl of perl on AIX __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/in

RE: Red Brick Perl on Linux

Attached is an old email I have that helped others. On 28-Nov-01 Patrick Dennis wrote: > Hello, > > I've seen a few messages in here a while back explaining how to setup Perl > DBI, DBD::ODBC using the Red Brick ODBC driver (and either the iODBC or > unixODBC driver manager) to gain access to

Re: Change current selected database with Postgres

On Wed, 28 Nov 2001, Joern Reder wrote: > Thanks for your answer. With other words: there exists no SQL command in > PostgreSQL to switch the current selected database? There is no SQL command. Some PostgreSQL clients support this with their own built-in command (like psql's /c command). > Is

Re: Change current selected database with Postgres

"Brett W. McCoy" wrote: > That's going to be database specific and not implemented via the DBD. I > think you are better off opening a new connection to the separate > database. Thanks for your answer. With other words: there exists no SQL command in PostgreSQL to switch the current selected da

Red Brick Perl on Linux

Hello, I've seen a few messages in here a while back explaining how to setup Perl DBI, DBD::ODBC using the Red Brick ODBC driver (and either the iODBC or unixODBC driver manager) to gain access to the Red Brick database. There seems to be some issues around SQLDescribeParam which requires some a