RE: Problem running Perl DBD-DB2-0.78 on AIX 5.3 using the DB2 UDB v8.2 (on AIX 5.3) client libraries

Hi, I am having problems running DBI-1.48 using DBD-DB2-0.78. The issue is that when I run a make test prior to running a make install for the compilation of the Perl DBD-DB2-0.78 module on AIX 5.3 using the client libraries that come with DB2 UDB v8.2 (installed on AIX 5.3 as

Pg 'v' Mysql primary_key_info() foreign_key_info()

Hi Folks At http://savage.net.au/Perl/list-indexes.pl you can download a demo program. Comments within the code are: # Set DBI_DSN=dbi:mysql:name-of-db # or DBI_DSN=dbi:Pg:dbname=name-of-db # Set DBI_USER=a-name # Set DBI_PASS=a-password Give the program 1 table name of

DBI installation in windows

Hi, i want to use perl DBI for Using XML and Relational Databases with Perl. I am using a package called apachefriends/xampp, where perl comes with that package,which do not have the DBI package. so i want to install it, but i dont know much about perl as i am a php user. can someone please

Re: Attempt to initiate a new SQL Server operation with results pending.

As far as I am aware this is a limitation of the TDS protocol used and your example code will not work unless you force a server-side cursor (see DBD::ODBC pod and look for odbc_SQL_ROWSET_SIZE but I warn you that you really will need to close everything i.e. force SQLFreeStmt(SQL_CLOSE) or you

´how to install perl DBI for windows

Hi, i want to use perl DBI for Using XML and Relational Databases with Perl. I am using a package called apachefriends/xampp, where perl comes with that package,which do not have the DBI package. so i want to install it, but i dont know much about perl as i am a php user. can someone please

RE: �how to install perl DBI for windows

-Original Message- From: babu [mailto:[EMAIL PROTECTED] Sent: 22 June 2005 09:52 To: dbi-users@perl.org Subject: ´how to install perl DBI for windows Hi, i want to use perl DBI for Using XML and Relational Databases with Perl. I am using a package called

Building DBD::Oracle with Oracle 10g

Just a quick note you might want to add to the README.clients file for DBD::Oracle ... To build DBD::Oracle against a minimally built/configured instalation of Oracle 10g 10.1, download and unzip the Instant Client from Oracle's web site and then either copy the libraries to somewhere your OS

Re: Building DBD::Oracle with Oracle 10g

On Wed, Jun 22, 2005 at 11:45:01AM +0100, David Cantrell wrote: Just a quick note you might want to add to the README.clients file for DBD::Oracle ... To build DBD::Oracle against a minimally built/configured instalation of Oracle 10g 10.1, download and unzip the Instant Client from

export in perl

Hi Conrad, I have a doubt regarding the usage of export.pm. The doubt is I have an xx.pl file which uses yy.pm (use yy;) Now this yy.pm has all subroutines and it tooo uses some other packages.. Now the doubt is, if I call some subroutine of yy.pm in xx.pl which isn't

Re: Attempt to initiate a new SQL Server operation with results pending.

Hi, You should only have to clear the statement if you are fetching a single row or fetching into a set variables. This will happen even if the result set on the backend contains only one record. If you are fetching row by row in a loop, fetching one more time beyond the last record should

OCI.dll cannot be found

Thanks for all the great help! When I try and connect to the Oracle server I get the following Unable to Locate Component error box: This application has failed to start because OCI.dll was not found. Re-installing the application may fix this problem. The OCI.dll is installed as part

RE: OCI.dll cannot be found

Can you log in via sqlplus from the \OCI directory? Also did you make sure you set the proper environmental variables in your environment? On XP you need (at least) NLS_LANG=american_america.we8iso8859p1 (or you may have funky script issues) ORACLE_HOME=c:\orahome1 (or whatever yours is)

Connection Issue with DBI::DBD::mysql

Hi everyone, Trying to connect to a MySQL database from a Linux Server using PERL to a Windows Machine with a MySQL database (5.0.6). I can connect successfully on the windows box but cannot on the Linux server! I ran a SQLTRACE (DBD) with the following output: imp_dbh-connect: dsn =

Re: Connection Issue with DBI::DBD::mysql

Sounds like a windows feature, does user1 have an account on the windows host ? are you using any type of firewall or other security related software ? [EMAIL PROTECTED] wrote: Hi everyone, Trying to connect to a MySQL database from a Linux Server using PERL to a Windows Machine with a

Re: Attempt to initiate a new SQL Server operation with results pending.

Terence, I could be wrong but from what little I remember from TDS I think that unless you enable a server-side cursor, once you start retrieving data from the server you have no choice but to keep reading it until it is exhausted - this is why SQL Server ODBC driver only supports 1 active

Re: Attempt to initiate a new SQL Server operation with results pending.

Martin J. Evans wrote: As far as I am aware this is a limitation of the TDS protocol used and your example code will not work unless you force a server-side cursor (see DBD::ODBC pod and look for odbc_SQL_ROWSET_SIZE but I warn you that you really will need to close everything i.e. force

Re: Problem running Perl DBD-DB2-0.78 on AIX 5.3 using the DB2 UDB v8.2 (on AIX 5.3) client libraries

Chris: This sounds very much like the problem noted under Hints at http://www-306.ibm.com/software/data/db2/perl/: Having trouble running perl with DB2 UDB Version 8 64-bit for AIX 5.2? Check out this technote.

Re: export in perl

On 06/22/2005 04:06 AM, Vamsi_Doddapaneni said: I have a doubt regarding the usage of export.pm. This is not a DBI question, you would be better off asking on a general Perl forum. -- Mac :}) ** I usually forward private questions to the appropriate mail list. ** Ask Smarter: