RE: Undefined symbol "SQLFreeHandle"

2002-02-09 Thread Will Spencer
It occured to me that it wuld probably be better if I showed the output of a manual build: # make realclean rm -rf ODBC.c ODBC.xsi dbdodbc.h ./blib Makefile.aperl blib/arch/auto/DBD/ODBC/extralibs.all perlmain.c mon.out core core.*perl.*.? *perl.core so_locations pm_to_blib *.o *.a perl.exe ODBC.

Undefined symbol "SQLFreeHandle"

2002-02-09 Thread Will Spencer
I am having difficulty installing the DBD::ODBC module. The trouble seems to be related to an undefined symbol "SQLFreeHandle" I am attempting to install via CPAN: cpan> install DBD::ODBC Going to read /root/.cpan/sources/authors/01mailrc.txt.gz CPAN: Compress::Zlib loaded ok Going to read /roo

Re: Re: Re: Oracle DBI commit/rollback question...

2002-02-09 Thread Jared Still
Maybe you can't rollback a SELECT statement, but it can be part of a transaction. Using Oracle as an example: Session 1: create table x ( x number ); insert into x values(1); commit; Session 2: commit; set transaction read only; select * from x; X -- 1 1 rows sele

FW: CPAN Upload: J/JU/JURL/DBD-ODBC-0.35.tar.gz

2002-02-09 Thread Jeff Urlwin
Whew. I think the multiple result set stuff is finally fixed. Thanks to all involved for both their patience and help! Here are the notes: Fixed (finally) multiple result sets with differing numbers of columns. The final fix was to call SQLFreeStmt(SQL_UNBIND) before repreparing the stat

Re: fetchrow_array problem

2002-02-09 Thread Bodo Eing
Ashwini, > hi, > > I have a perl script here which fetches data from the mysql database > using the fetchrow_array method. I have this script running on 2 > different machines. unfortunately this fetchrow_array call works on > one machine and not on another. I used the rows calls to check how >