RE: SQL Server
I use DBD::ODBC almost exclusively in WIN32 environments using a variety of DBMS's. It works beautifully with MS SQL 7 (which is actually my main area of focus). Have fun. Steve Howard -Original Message- From: Alisa Mills [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 8:07 AM To: [EMAIL PROTECTED] Subject: SQL Server I am trying to port an application from Unix to Windows 2000. The Unix version used Oracle, and the Windows 2000 version will use MS SQL Server 2000. I found a DBI for ODBC, ADO, and a very old one for MS SQL Server. Does anyone know of a DBI that will work with MS SQL Server 2000? Thanks in advance. Ci-Ci [EMAIL PROTECTED]
RE: Connection is busy
I've encountered this problem before while using DBD::ODBC. It usually is how I am dealing with the results of a previous query. The way to handle it is to open another connection. Works fine like that. Steve Howard -Original Message- From: Michael Peppler [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 11:59 AM To: [EMAIL PROTECTED] Subject: Re: Connection is busy roberto l writes: > And since this is dependant on the protocol changing the odbc driver won't work. So > what would be the best workaround? Depends. I think some ODBC drivers have support for this "under the covers", possibly by opening a second connection for you. I don't know much about ODBC, unfortunately. DBD::Sybase gets around the problem (not very nicely) by opening a new connection for the sth if the dbh already has an active sth. Michael > Michael Peppler wrote: > > > Sterin, Ilya writes: > > > I would imaging that that is either the SQLServer config or ODBD config that > > > is not allowing multiple connections. > > > > Actually it's not allowing multiple statement handlers on the same > > connection. This is the default for the TDS protocol (the underlying > > protocol that MS-SQL and Sybase use to communicate between the client > > and the server.) > > > > Michael > > > > > -Original Message- > > > From: roberto l > > > To: [EMAIL PROTECTED] > > > Sent: 05/17/2001 10:03 AM > > > Subject: Connection is busy > > > > > > We've recently ported an application from MSaccess to SQL Server 7 and > > > now many programs are failing producing the following error: > > > > > > [Microsoft][ODBC SQL Server Driver] > > > Connection is busy with results for another hstmt > > > (SQL-S1000)(DBD: st_execute/SQLExecute err=-1) > > > > > > Should I use another ODBC driver? > > > > > > Any suggestion will be greatly appreciated. The platform: perl 5.6.0, nt > > > 4.0 sp 6 and sql server 7. > > > > > > bests > > > > > > > > > > > > > > > -- > > > De duobus malis, minus est semper eligendum > > > > > > > -- > > Michael Peppler - Data Migrations Inc. - [EMAIL PROTECTED] > > http://www.mbay.net/~mpeppler - [EMAIL PROTECTED] > > International Sybase User Group - http://www.isug.com > > Sybase on Linux mailing list: [EMAIL PROTECTED] > > -- > De duobus malis, minus est semper eligendum > > -- Michael Peppler - Data Migrations Inc. - [EMAIL PROTECTED] http://www.mbay.net/~mpeppler - [EMAIL PROTECTED] International Sybase User Group - http://www.isug.com Sybase on Linux mailing list: [EMAIL PROTECTED]
Re: (Fwd) Calling Stored Procedure with RowType Param
Still can't. -- Mac :}) ** I normally forward private database questions to the DBI mail lists. ** Give a hobbit a fish and he'll eat fish for a day. Give a hobbit a ring and he'll eat fish for an age. - Original Message - From: "Tim Bunce" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, May 17, 2001 12:34 Subject: (Fwd) Calling Stored Procedure with RowType Param > - Forwarded message from "Keith A. Humphrey" <[EMAIL PROTECTED]> - > > From: "Keith A. Humphrey" <[EMAIL PROTECTED]> > To: "Tim.Bunce" <[EMAIL PROTECTED]> > Subject: Calling Stored Procedure with RowType Param > Date: Thu, 17 May 2001 15:20:35 -0400 > > > Is it possible to call a stored procedure using a RowType parameter in > Oracle? If so, how?
$VERSION changes in lib/DBD/ADO.pm confuse CPAN
There seems to be some version mismatches between CPAN
and DBD
When I install T/TI/TIMB/DBI-1.14.tar.gz
and do the cpan "r" command it reports that
there is a new version:
Package namespace installedlatest in CPAN file
DBD::ExampleP 10.11 10.13 T/TI/TIMB/DBI-1.15.tar.gz
So I install the latest DBI-1.15.tar.gz as recomended, and
then cpan "r" indicates that the latest version is DBI-1.14.tar.gz
Package namespace installedlatest in CPAN file
DBD::ADO 0.419 1.17 T/TI/TIMB/DBI-1.14.tar.gz
Is this a bug in the CPAN module, or did your version numbering
scheme for lib/DBD/ADO.pm change
lib/DBD/ADO.pm from DBI-1.14 contained
$VERSION = sprintf("%d.%02d", q$Revision: 1.17 $ =~ /(\d+)\.(\d+)/o);
lib/DBD/ADO.pm from DBI-1.15 containes
$VERSION = '0.4'.sprintf("%02d",substr(q$Revision: 1.19 $, 12,-1));
I can see the the RCS/CVS Revision incremented from 1.17 to 1.19,
but the 'reported $VERSION seems to have dropped down
from 1.17 to 0.419, which triggers CPAN to report that I should
upgrade using a downgrade.
connecting to postgresql
Hi all,
I can't seem to make a valid DBI connection to PostgreSQL 7.1 unless my current
login name matches a Postgresql user. It seems to ignore the username I'm
passing it. The initial problem came up under mod_perl and HTML::Mason, but
I've duplicated it in a plain script as well, narrow it down. Here's a snippet:
use DBI;
use DBD::Pg;
my $dbh;
$dbh = DBI->connect("dbi:Pg:dbname=mydb", "www", "secret") || die $dbh->errstr;
[code to select a record follows this, but it never gets that far]
The error message is:
DBI->connect(dbname=mydb) failed: FATAL 1: user "root" does not exist at testdbi
line [line number with the connect statement]
In Postgresql, two users are defined: my own linux username, and "www" for web
access. "www" doesn't have a unix account, just exists in Postgresql with
appropriate permissions. Web clients connect as "nobody". When I was testing
Mason code, the error message said that "nobody" doesn't exist. The above
snippet works fine if I'm logged in as me, since my login also exists in the
database. Do I need to go into PostgreSQL and grant permissions to "nobody" so
it will match the logged-in user, or is there a way to get it to pay attention
to the connect() parms?
Version info:
DBI: 1.15
DBD::Pg: 0.96
PostgreSQL:7.1
Thanks for your help.
Re: DBD error
- Original Message - From: Theja Rajakumar <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 17, 2001 10:34 PM Subject: DBD error > I've been getting this error while connecting to an Oracle database > thro' DBI. and don't know what's happening. > Can anybody help? > > ORA-12500: TNS:listener failed to start a dedicated server process (DBD > ERROR: OCIServerAttach) at DbUtils.pm line 104. > For some reason the Oracle dispatcher process wasnt able to start a dedicated process for you on the server. This is an server side error. Ask your DBA to investigate this. You might wanna try to connect to a shared server process rather than a dedicated process. To do this put (SERVER = SHARED) in your tnsname.ora file on the client. See example: SOME_SID.SOMEHOST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = SOMEHOST)(PORT = 1526)) ) (CONNECT_DATA = (SERVICE_NAME = SOME_SID) (SERVER = SHARED) ) ) maarten
DBD error
I've been getting this error while connecting to an Oracle database thro' DBI. and don't know what's happening. Can anybody help? ORA-12500: TNS:listener failed to start a dedicated server process (DBD ERROR: OCIServerAttach) at DbUtils.pm line 104. Thanks.
DBD Oracle on Linux problem
Hello! This is my first time posting to any mailing list. I am trying to install DBD-Oracle-1.06 with DBI-1.14 (I've also tried 1.15). I am running Redhat Linux 6.2 and Oracle8i 8.15.0.0. The DBI installation went smoothly. I've run into problems with the DBD install. I've run perl Makefile.PL and I get the following error. * ERROR MESSAGE 1 You have a wait.ph file generated by perl h2ph utility. It does not define a WCOREDUMP function. That's probably an error. If a DBD::Oracle test fails then you will probably see a message from Test::Harness about WCOREDUMP being undefined. You can either ignore it or try to fix your wait.ph file. The message does not reflect the cause of the test failure, it's just a problem interpreting the failure. ** I've read other messages from people with the same problem. It seems that some people ignore it which I did but then I get the following error each time I try to run "make". It is an error stating that it could not find -lsql. Can anyone help with this? * ERROR MESSAGE 2 mkdir blib mkdir blib/lib mkdir blib/lib/DBD mkdir blib/arch mkdir blib/arch/auto mkdir blib/arch/auto/DBD mkdir blib/arch/auto/DBD/Oracle mkdir blib/lib/auto mkdir blib/lib/auto/DBD mkdir blib/lib/auto/DBD/Oracle mkdir blib/man1 mkdir blib/man3 cp Oraperl.pm blib/lib/Oraperl.pm cp Oracle.pm blib/lib/DBD/Oracle.pm cp oraperl.ph blib/lib/oraperl.ph /usr/bin/perl -p -e "s/~DRIVER~/Oracle/g" < /usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBI/Driver.xst > Oracle.xsi /usr/bin/perl -I/usr/lib/perl5/5.00503/i386-linux -I/usr/lib/perl5/5.00503 /usr/lib/perl5/5.00503/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.00503/ExtUtils/typemap Oracle.xs >xstmp.c && mv xstmp.c Oracle.c cc -c -I/var/OraHome/rdbms/demo -I/var/OraHome/rdbms/public -I/var/OraHome/plsql/public -I/var/OraHome/network/public -I/var/OraHome/rdbms/demo -I/var/OraHome/rdbms/demo -I/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBI -Dbool=char -DHAS_BOOL -I/usr/local/include -O2 -m486 -fno-strength-reduce-DVERSION=\"1.06\" -DXS_VERSION=\"1.06\" -fpic -I/usr/lib/perl5/5.00503/i386-linux/CORE Oracle.c cc -c -I/var/OraHome/rdbms/demo -I/var/OraHome/rdbms/public -I/var/OraHome/plsql/public -I/var/OraHome/network/public -I/var/OraHome/rdbms/demo -I/var/OraHome/rdbms/demo -I/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBI -Dbool=char -DHAS_BOOL -I/usr/local/include -O2 -m486 -fno-strength-reduce-DVERSION=\"1.06\" -DXS_VERSION=\"1.06\" -fpic -I/usr/lib/perl5/5.00503/i386-linux/CORE dbdimp.c cc -c -I/var/OraHome/rdbms/demo -I/var/OraHome/rdbms/public -I/var/OraHome/plsql/public -I/var/OraHome/network/public -I/var/OraHome/rdbms/demo -I/var/OraHome/rdbms/demo -I/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBI -Dbool=char -DHAS_BOOL -I/usr/local/include -O2 -m486 -fno-strength-reduce-DVERSION=\"1.06\" -DXS_VERSION=\"1.06\" -fpic -I/usr/lib/perl5/5.00503/i386-linux/CORE oci7.c cc -c -I/var/OraHome/rdbms/demo -I/var/OraHome/rdbms/public -I/var/OraHome/plsql/public -I/var/OraHome/network/public -I/var/OraHome/rdbms/demo -I/var/OraHome/rdbms/demo -I/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBI -Dbool=char -DHAS_BOOL -I/usr/local/include -O2 -m486 -fno-strength-reduce-DVERSION=\"1.06\" -DXS_VERSION=\"1.06\" -fpic -I/usr/lib/perl5/5.00503/i386-linux/CORE oci8.c Running Mkbootstrap for DBD::Oracle () chmod 644 Oracle.bs LD_RUN_PATH="" cc -o blib/arch/auto/DBD/Oracle/Oracle.so -shared -L/usr/local/lib Oracle.o dbdimp.o oci7.o oci8.o -L/var/OraHome/lib/ -L/var/OraHome/rdbms/lib -lclntsh /var/OraHome/lib/nautab.o /var/OraHome/lib/naeet.o /var/OraHome/lib/naect.o /var/OraHome/lib/naedhs.o `cat /var/OraHome/network/lib/ldflags` -ln8 -lnl8 -lnro8 `cat /var/OraHome/network/lib/ldflags` -ln8 -lnl8 -lclient8 -lvsn8 -lcommon8 -lskgxp8 -lgeneric8 -lmm -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 `cat /var/OraHome/network/lib/ldflags` -ln8 -lnl8 -lnro8 `cat /var/OraHome/network/lib/ldflags` -ln8 -lnl8 -lclient8 -lvsn8 -lcommon8 -lskgxp8 -lgeneric8 -ltrace8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lclient8 -lvsn8 -lcommon8 -lskgxp8 -lgeneric8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8`cat /var/OraHome/lib/sysliblist` `if [ -f /usr/lib/libsched.so ] ; then echo -lsched ; else true; fi` -ldl -lm -ldl `cat /var/OraHome/network/lib/ldflags` -ln8 -lnl8 -lnro8 `cat /var/OraHome/network/lib/ldflags` -ln8 -lnl8 `cat /var/OraHome/network/lib/ldflags` -ln8 -lnl8 -lnro8 `cat /var/OraHome/network/lib/ldflags` -ln8 -lnl8 `cat /var/OraHome/network/lib/ldflags` -ln8 -lnl8 -lnro8 `cat /var/OraHome/network/lib/ldflags` -ln8 -lnl8 `cat /var/OraHome/network/lib/ldflags` -ln8 -lnl8 -lnro8 `cat /var/OraHome/network/lib/ldflags` -ln8 -lnl8 `cat /var/OraHome/network/lib/ldflags` -ln8 -lnl8 -lnro8 `cat /var/OraHome/network/lib/ldflags` -ln8 -lnl8 -lsql -lsql /usr/bin/ld: cannot find -lsql collect2: ld returned 1 exit status make: *** [blib/a
Re: Inserting/Updating to ADO (.MDB file)
Matthew,
I use the ADO driver with Access but use insert and delete SQL statements. I haven't
had any problems doing so and the code is more portable as well. Here's a quick
example of an insert:
# Prepare the statement for execution
$sth = $dbh->prepare("
INSERT INTO PAGES (Page_ID, Template_ID, Body, Title, Meta_Keywords,
Meta_Description)
VALUES ('$FILE', $qtemplate, $qbody, $qpage_title, $qkeywords, $qdescription)
") or die "Can't prepare statement: $dbh->errstr\n";
# Check if statement prepared correctly
die "ERROR: Cannot prepare statement: $DBI::errstr\n" unless (defined $sth);
# Execute statement at database level
$sth->execute or die $sth->errstr;
# Clean up before exiting
$sth->finish;# release the statement handle resources
-Jim
Matthew Tedder wrote:
> Could someone potentiall help me.. I'm getting a message saying that this
>operation is not supported. It appears to be on the ->AddNew(); method. How can I
>insert and update data in Access databases in my question. What syntax can be used?
>I've already got reading solved.
> =
>
> $rs->AddNew();
> $rs->Fields('User')->{Value} = "Bubba";
> $rs->Update();
(Fwd) Calling Stored Procedure with RowType Param
- Forwarded message from "Keith A. Humphrey" <[EMAIL PROTECTED]> - From: "Keith A. Humphrey" <[EMAIL PROTECTED]> To: "Tim.Bunce" <[EMAIL PROTECTED]> Subject: Calling Stored Procedure with RowType Param Date: Thu, 17 May 2001 15:20:35 -0400 Is it possible to call a stored procedure using a RowType parameter in Oracle? If so, how? Thanks Keith Humphrey Software Engineer NetRail, Inc. 1-888-NETRAIL ext. 4215 - End forwarded message -
Inserting/Updating to ADO (.MDB file)
Could someone potentiall help me.. I'm getting a message saying that this operation
is not supported. It appears to be on the ->AddNew(); method. How can I insert and
update data in Access databases in my question. What syntax can be used? I've
already got reading solved.
=
$rs->AddNew();
$rs->Fields('User')->{Value} = "Bubba";
$rs->Update();
DBI-1.15 `__builtin_va_alist' undeclared plus perl -V
I am having trouble compiling DBI-1.15 on a solaris 2.6 sparc box. I get the following error: DBI.xs: In function `dbih_logmsg': DBI.(first use in this function)xs:419: `__builtin_va_alist' undeclared I am using the following (which I have recompiled all) : perl5.6.0 DBI-1.15 gcc-2.95.2 GNUmake-3.78.1 #make test TEST_VERBOSE=1 gcc -c -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.15\" -DXS_VERSION=\"1.15\" -fPIC -I/usr/local/lib/perl5/5.6.0/sun4-solaris/CORE -DDBI_NO_THREADS DBI.c DBI.xs: In function `dbih_logmsg': DBI.(first use in this function)xs:419: `__builtin_va_alist' undeclared DBI.xs:419: (Each undeclared identifier is reported only once DBI.xs:419: for each function it appears in.) make: *** [DBI.o] Error 1 ANY HELP WOULD BE APPRECIATED. Sorry to be repetitive but here is also my perl -V output #perl -V Summary of my perl5 (revision 5.0 version 6 subversion 0) configuration: Platform: osname=solaris, osvers=2.6, archname=sun4-solaris uname='sunos orion 5.6 generic_105181-05 sun4m sparc sunw,sparcstation-4 ' config_args='-Dcc=gcc -Dprefix=/usr/local -Uinstallusrbinperl -de' hint=recommended, useposix=true, d_sigaction=define usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef useperlio=undef d_sfio=undef uselargefiles=define use64bitint=undef use64bitall=undef uselongdouble=undef usesocks=undef Compiler: cc='gcc', optimize='-O', gccversion=2.95.2 19991024 (release) cppflags='-fno-strict-aliasing -I/usr/local/include' ccflags ='-fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64' stdchar='unsigned char', d_stdstdio=define, usevfork=false intsize=4, longsize=4, ptrsize=4, doublesize=8 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16 ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8 alignbytes=8, usemymalloc=y, prototype=define Linker and Libraries: ld='gcc', ldflags =' -L/usr/local/lib ' libpth=/usr/local/lib /lib /usr/lib /usr/ccs/lib libs=-lsocket -lnsl -lgdbm -ldb -ldl -lm -lc -lcrypt -lsec libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' ' cccdlflags='-fPIC', lddlflags='-G -L/usr/local/lib' Characteristics of this binary (from libperl): Compile-time options: USE_LARGE_FILES Built under solaris Compiled at Apr 14 2000 01:46:43 @INC: /usr/local/lib/perl5/5.6.0/sun4-solaris /usr/local/lib/perl5/5.6.0 /usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris /usr/local/lib/perl5/site_perl/5.6.0 /usr/local/lib/perl5/site_perl
DBI-1.15 `__builtin_va_alist' undeclared
I am having trouble compiling DBI-1.15 on a solaris 2.6 sparc box. I get the following error: DBI.xs: In function `dbih_logmsg': DBI.(first use in this function)xs:419: `__builtin_va_alist' undeclared I am using the following (which I have recompiled all) : perl5.6.0 DBI-1.15 gcc-2.95.2 GNUmake-3.78.1 #make test TEST_VERBOSE=1 gcc -c -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.15\" -DXS_VERSION=\"1.15\" -fPIC -I/usr/local/lib/perl5/5.6.0/sun4-solaris/CORE -DDBI_NO_THREADS DBI.c DBI.xs: In function `dbih_logmsg': DBI.(first use in this function)xs:419: `__builtin_va_alist' undeclared DBI.xs:419: (Each undeclared identifier is reported only once DBI.xs:419: for each function it appears in.) make: *** [DBI.o] Error 1 ANY HELP WOULD BE APPRECIATED.
Re: Connection is busy
roberto l writes: > And since this is dependant on the protocol changing the odbc driver won't work. So > what would be the best workaround? Depends. I think some ODBC drivers have support for this "under the covers", possibly by opening a second connection for you. I don't know much about ODBC, unfortunately. DBD::Sybase gets around the problem (not very nicely) by opening a new connection for the sth if the dbh already has an active sth. Michael > Michael Peppler wrote: > > > Sterin, Ilya writes: > > > I would imaging that that is either the SQLServer config or ODBD config that > > > is not allowing multiple connections. > > > > Actually it's not allowing multiple statement handlers on the same > > connection. This is the default for the TDS protocol (the underlying > > protocol that MS-SQL and Sybase use to communicate between the client > > and the server.) > > > > Michael > > > > > -Original Message- > > > From: roberto l > > > To: [EMAIL PROTECTED] > > > Sent: 05/17/2001 10:03 AM > > > Subject: Connection is busy > > > > > > We've recently ported an application from MSaccess to SQL Server 7 and > > > now many programs are failing producing the following error: > > > > > > [Microsoft][ODBC SQL Server Driver] > > > Connection is busy with results for another hstmt > > > (SQL-S1000)(DBD: st_execute/SQLExecute err=-1) > > > > > > Should I use another ODBC driver? > > > > > > Any suggestion will be greatly appreciated. The platform: perl 5.6.0, nt > > > 4.0 sp 6 and sql server 7. > > > > > > bests > > > > > > > > > > > > > > > -- > > > De duobus malis, minus est semper eligendum > > > > > > > -- > > Michael Peppler - Data Migrations Inc. - [EMAIL PROTECTED] > > http://www.mbay.net/~mpeppler - [EMAIL PROTECTED] > > International Sybase User Group - http://www.isug.com > > Sybase on Linux mailing list: [EMAIL PROTECTED] > > -- > De duobus malis, minus est semper eligendum > > -- Michael Peppler - Data Migrations Inc. - [EMAIL PROTECTED] http://www.mbay.net/~mpeppler - [EMAIL PROTECTED] International Sybase User Group - http://www.isug.com Sybase on Linux mailing list: [EMAIL PROTECTED]
Re: Connection is busy
And since this is dependant on the protocol changing the odbc driver won't work. So what would be the best workaround? Michael Peppler wrote: > Sterin, Ilya writes: > > I would imaging that that is either the SQLServer config or ODBD config that > > is not allowing multiple connections. > > Actually it's not allowing multiple statement handlers on the same > connection. This is the default for the TDS protocol (the underlying > protocol that MS-SQL and Sybase use to communicate between the client > and the server.) > > Michael > > > -Original Message- > > From: roberto l > > To: [EMAIL PROTECTED] > > Sent: 05/17/2001 10:03 AM > > Subject: Connection is busy > > > > We've recently ported an application from MSaccess to SQL Server 7 and > > now many programs are failing producing the following error: > > > > [Microsoft][ODBC SQL Server Driver] > > Connection is busy with results for another hstmt > > (SQL-S1000)(DBD: st_execute/SQLExecute err=-1) > > > > Should I use another ODBC driver? > > > > Any suggestion will be greatly appreciated. The platform: perl 5.6.0, nt > > 4.0 sp 6 and sql server 7. > > > > bests > > > > > > > > > > -- > > De duobus malis, minus est semper eligendum > > > > -- > Michael Peppler - Data Migrations Inc. - [EMAIL PROTECTED] > http://www.mbay.net/~mpeppler - [EMAIL PROTECTED] > International Sybase User Group - http://www.isug.com > Sybase on Linux mailing list: [EMAIL PROTECTED] -- De duobus malis, minus est semper eligendum
RE: Connection is busy
Thanks, Michael. Ilya -Original Message- From: Michael Peppler To: [EMAIL PROTECTED] Sent: 05/17/2001 10:20 AM Subject: RE: Connection is busy Sterin, Ilya writes: > I would imaging that that is either the SQLServer config or ODBD config that > is not allowing multiple connections. Actually it's not allowing multiple statement handlers on the same connection. This is the default for the TDS protocol (the underlying protocol that MS-SQL and Sybase use to communicate between the client and the server.) Michael > -Original Message- > From: roberto l > To: [EMAIL PROTECTED] > Sent: 05/17/2001 10:03 AM > Subject: Connection is busy > > We've recently ported an application from MSaccess to SQL Server 7 and > now many programs are failing producing the following error: > > [Microsoft][ODBC SQL Server Driver] > Connection is busy with results for another hstmt > (SQL-S1000)(DBD: st_execute/SQLExecute err=-1) > > Should I use another ODBC driver? > > Any suggestion will be greatly appreciated. The platform: perl 5.6.0, nt > 4.0 sp 6 and sql server 7. > > bests > > > > > -- > De duobus malis, minus est semper eligendum > -- Michael Peppler - Data Migrations Inc. - [EMAIL PROTECTED] http://www.mbay.net/~mpeppler - [EMAIL PROTECTED] International Sybase User Group - http://www.isug.com Sybase on Linux mailing list: [EMAIL PROTECTED]
RE: :Sybase installation error!!!
In my case, the client installation. I routinely connect to various servers with isql, sqsh, etc. with no problems. The version is 11.9.2. Thanks, Al Al Spohn Publishing and Media Technology Services Mayo Clinic 507-284-1666 > -Original Message- > From: De Simone, Andrew (CAP, FGI) > [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 17, 2001 9:18 AM > To: 'Spohn, Albert F.'; [EMAIL PROTECTED] > Subject: RE: :Sybase installation error!!! > > > These kinds of errors seem to come about when proper > connections can't be made or the driver install is flawed. > Can you connect with ISQL to the server? What version of Sybase is > on the machine? Is it the server or client install? > > -Original Message- > From: Spohn, Albert F. [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 17, 2001 8:52 AM > To: '? ?'; [EMAIL PROTECTED] > Subject: RE: :Sybase installation error!!! > > > That's the exact same error I'm getting (re:Initial Install > Issue), then it > was pointed out that I had two perl installations on my machine, so I > strongly suspected that was the issue. I haven't had a > chance to pursue > that as of yet, so I'd be very interested in what the > determination is in > your case - in the meantime I'll keep you informed as to my > progress as to > whether conflicting perl installations was the root of my problem. > > Thanks, > Al > > Al Spohn > Publishing and Media Technology Services > Mayo Clinic 507-284-1666 > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, May 16, 2001 7:56 PM > > To: [EMAIL PROTECTED] > > Subject: DBD::Sybase installation error!!! > > > > > > hello ,everyone. > > I have installed DBI-1.14 successfully on my linux system(Red > > Hat Linux release 6.1,kernel 2.2.12-20 on an i686).But I have > > a problem when I install DBD::Sybase-0.91 on my system.Will > > you be so kind as to help me?Thanks a lot. > > *ERROR MESSAGE*** > > I have no problem when I run "perl Makefile.PL" and "make" > > the error message of "make test" is following up. > > #make test > > PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib > > -I/usr/lib/perl5/5.00503/ > > i386-linux -I/usr/lib/perl5/5.00503 -e 'use Test::Harness > > qw(&runtests $verbose) > > ; $verbose=0; runtests @ARGV;' t/*.t > > t/autocommitdubious > > Test returned status 0 (wstat 139, 0x8b) > > Undefined subroutine &Test::Harness::WCOREDUMP called at > > /usr/lib/perl5/5.00503/ > > Test/Harness.pm line 288. > > make: *** [test_dynamic] Error 255 > > ~ > > **ENVIROMENT > > #perl -V > > Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration: > > Platform: > > osname=linux, osvers=2.2.5-22smp, archname=i386-linux > > uname='linux porky.devel.redhat.com 2.2.5-22smp #1 smp > > wed jun 2 09:11:51 ed > > t 1999 i686 unknown ' > > hint=recommended, useposix=true, d_sigaction=define > > usethreads=undef useperlio=undef d_sfio=undef > > Compiler: > > cc='cc', optimize='-O2', gccversion=egcs-2.91.66 > > 19990314/Linux (egcs-1.1.2 > > release) > > cppflags='-Dbool=char -DHAS_BOOL -I/usr/local/include' > > ccflags ='-Dbool=char -DHAS_BOOL -I/usr/local/include' > > stdchar='char', d_stdstdio=undef, usevfork=false > > intsize=4, longsize=4, ptrsize=4, doublesize=8 > > d_longlong=define, longlongsize=8, d_longdbl=define, > > longdblsize=12 > > alignbytes=4, usemymalloc=n, prototype=define > > Linker and Libraries: > > ld='cc', ldflags =' -L/usr/local/lib' > > libpth=/usr/local/lib /lib /usr/lib > > libs=-lnsl -ldl -lm -lc -lposix -lcrypt > > libc=, so=so, useshrplib=false, libperl=libperl.a > > Dynamic Linking: > > dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, > > ccdlflags='-rdynamic' > > cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib' > > > > > > Characteristics of this binary (from libperl): > > Built under linux > > Compiled at Aug 30 1999 23:09:51 > > @INC: > > /usr/lib/perl5/5.00503/i386-linux > > /usr/lib/perl5/5.00503 > > /usr/lib/perl5/site_perl/5.005/i386-linux > > /usr/lib/perl5/site_perl/5.005 > > . > > > > > > >
RE: Connection is busy
Sterin, Ilya writes: > I would imaging that that is either the SQLServer config or ODBD config that > is not allowing multiple connections. Actually it's not allowing multiple statement handlers on the same connection. This is the default for the TDS protocol (the underlying protocol that MS-SQL and Sybase use to communicate between the client and the server.) Michael > -Original Message- > From: roberto l > To: [EMAIL PROTECTED] > Sent: 05/17/2001 10:03 AM > Subject: Connection is busy > > We've recently ported an application from MSaccess to SQL Server 7 and > now many programs are failing producing the following error: > > [Microsoft][ODBC SQL Server Driver] > Connection is busy with results for another hstmt > (SQL-S1000)(DBD: st_execute/SQLExecute err=-1) > > Should I use another ODBC driver? > > Any suggestion will be greatly appreciated. The platform: perl 5.6.0, nt > 4.0 sp 6 and sql server 7. > > bests > > > > > -- > De duobus malis, minus est semper eligendum > -- Michael Peppler - Data Migrations Inc. - [EMAIL PROTECTED] http://www.mbay.net/~mpeppler - [EMAIL PROTECTED] International Sybase User Group - http://www.isug.com Sybase on Linux mailing list: [EMAIL PROTECTED]
Re: Help with INSERT INTO table VALUES @array
From: "Bodo Eing" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Date sent: Thu, 17 May 2001 18:16:17 +0200
Subject:Re: Help with INSERT INTO table VALUES @array
Priority: normal
Arrghh!! Sorry for that typo in my last post (see below)
>
>
> > > $dbh = DBI->connect("DBI:mysql:$db",$servuser,$servpass) or die "Unable to
> > > connect to inventory database: $dbh->errstr\n";
>
> $dbh->errstr is not a variable but method call, thus it will not
> interpolate. Say
>
> $dbh = DBI->connect("DBI:mysql:$db",$servuser,$servpass) or die
> "Unable to connect to inventory database: " . $dbh->errstr . "\n";
>
>
> > > my $obj = new CGI;
> > > my @values = map { $obj->param($_) } $obj->param();
> > > my @all = join(",", @values);
>
> join() joins the elements of an array into a string, so it is not
> clear to me what @all does here
>
> > > foreach (@all) {s/addvehicle,//;}
>
> I guess this should read
>
> for (@values) { s/addvehicle,//; }
>
>
> > > my $all = "@all";
>
> and here you should
>
> my @all = join ', ', @values;
^
this is
my $all = join ', ', @values;
of course
Bodo
Dr. med. Bodo Eing
Institut fuer Medizinische Mikrobiologie
Klinische Virologie
v.-Stauffenbergstr. 36
48151 Muenster
Germany
Phone: ++49 251 7793 111 Fax: ++49 251 7793-104
Re: Help with INSERT INTO table VALUES @array
Date sent: Thu, 17 May 2001 10:39:29 -0400 (EDT)
From: Joe Grastara <[EMAIL PROTECTED]>
To: Ray Cuzzart II <[EMAIL PROTECTED]>
Copies to: [EMAIL PROTECTED]
Subject:Re: Help with INSERT INTO table VALUES @array
Ray,
> > $dbh = DBI->connect("DBI:mysql:$db",$servuser,$servpass) or die "Unable to
> > connect to inventory database: $dbh->errstr\n";
$dbh->errstr is not a variable but method call, thus it will not
interpolate. Say
$dbh = DBI->connect("DBI:mysql:$db",$servuser,$servpass) or die
"Unable to connect to inventory database: " . $dbh->errstr . "\n";
> > my $obj = new CGI;
> > my @values = map { $obj->param($_) } $obj->param();
> > my @all = join(",", @values);
join() joins the elements of an array into a string, so it is not
clear to me what @all does here
> > foreach (@all) {s/addvehicle,//;}
I guess this should read
for (@values) { s/addvehicle,//; }
> > my $all = "@all";
and here you should
my @all = join ', ', @values;
> > my $success = $dbh->do("INSERT INTO $tbl VALUES $all") or die "Unable to
> > write information to inventory database: $dbh->errstr\n";
and here:
my $success = $dbh->do("INSERT INTO $tbl VALUES ($all)") or die
"Unable to write information to inventory database: " . $dbh->errstr
. "\n";
> >
> > $dbh->disconnect;
> >
confirm that $tbl has a useful value
HTH
Bodo
[EMAIL PROTECTED]
RE: please remove me from the mailing list
Send email to [EMAIL PROTECTED] Ilya -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 05/17/2001 10:14 AM Subject: please remove me from the mailing list The information in this Email belongs to HFC Bank. It is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or the taking of any action in reliance on the contents of this Email is prohibited. If you have received this Email in error, please notify us immediately by telephone and delete the Email from your system and destroy all copies which you have made of the same. Thank you. HFC Bank plc Company Registration Number - 1117305 England Registered Office: North Street, Winkfield, Berkshire SL4 4TD.
please remove me from the mailing list
The information in this Email belongs to HFC Bank. It is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or the taking of any action in reliance on the contents of this Email is prohibited. If you have received this Email in error, please notify us immediately by telephone and delete the Email from your system and destroy all copies which you have made of the same. Thank you. HFC Bank plc Company Registration Number - 1117305 England Registered Office: North Street, Winkfield, Berkshire SL4 4TD.
RE: unsuscribe
Try [EMAIL PROTECTED] Ilya -Original Message- From: haddad Cc: [EMAIL PROTECTED] Sent: 05/17/2001 10:09 AM Subject: unsuscribe unsuscribe
unsuscribe
unsuscribe
RE: Connection is busy
I would imaging that that is either the SQLServer config or ODBD config that is not allowing multiple connections. Ilya Sterin -Original Message- From: roberto l To: [EMAIL PROTECTED] Sent: 05/17/2001 10:03 AM Subject: Connection is busy We've recently ported an application from MSaccess to SQL Server 7 and now many programs are failing producing the following error: [Microsoft][ODBC SQL Server Driver] Connection is busy with results for another hstmt (SQL-S1000)(DBD: st_execute/SQLExecute err=-1) Should I use another ODBC driver? Any suggestion will be greatly appreciated. The platform: perl 5.6.0, nt 4.0 sp 6 and sql server 7. bests -- De duobus malis, minus est semper eligendum
Connection is busy
We've recently ported an application from MSaccess to SQL Server 7 and now many programs are failing producing the following error: [Microsoft][ODBC SQL Server Driver] Connection is busy with results for another hstmt (SQL-S1000)(DBD: st_execute/SQLExecute err=-1) Should I use another ODBC driver? Any suggestion will be greatly appreciated. The platform: perl 5.6.0, nt 4.0 sp 6 and sql server 7. bests -- De duobus malis, minus est semper eligendum
Re: Help with INSERT INTO table VALUES @array
I think that you are having problems because you are using a reference to
the array. The reference won't evaluate to the values in your array, but
rather to the location of your actual array. You probably need to
dereference the array before you use it in the SQL statement. However You
probably don't even need to make a reference to it in the first place.
Joe Grastara
Project Assistant
Digital Media Center
The Skirball Institute Of Biomolecular Medicine
New York University Medical Center
540 First Ave., New York City, NY 10016 USA
[EMAIL PROTECTED]
http://www.med.nyu.edu/graphics
On Wed, 16 May 2001, Ray Cuzzart II wrote:
> Hello,
> What I am trying to do is insert form fields into a mySQL database
> table by using them in an array. I have the array setup properly it collects
> all the fields but when I try to insert it into the table I get and error.
> Below
> is the information on what I am running as well as the code snippet and
> error
> message. Any help would be greatly appreciated. The reason for using an
> array
> is because there is 32 fields and I would rather use it this way then to say
> my $field = param('field'); for 32 lines.
>
> Environment Information:
> mySQL Version: 3.23.33
> Server Apache Version: 1.3.19
> OS: Windows
>
> DBI Version: Most current
> DBD::mysql version: most current
>
> Script:
>
> Top:
> use strict;
>
> use CGI::Carp "fatalsToBrowser";
> use CGI ":all";
> use DBI;
>
> my $servname = "localhost";
> my $servuser = "inventory";
> my $servpass = "inventory";
> my $db = "inventory";
> my $tbl = "vehicles";
>
> my ($dbh);
>
> $dbh = DBI->connect("DBI:mysql:$db",$servuser,$servpass) or die "Unable to
> connect to inventory database: $dbh->errstr\n";
>
> my $obj = new CGI;
> my @values = map { $obj->param($_) } $obj->param();
> my @all = join(",", @values);
>
> foreach (@all) {s/addvehicle,//;}
> my $all = "@all";
>
>
> my $success = $dbh->do("INSERT INTO $tbl VALUES $all") or die "Unable to
> write information to inventory database: $dbh->errstr\n";
>
> $dbh->disconnect;
>
> if($success != 1) {
> print header, start_html("Entry Added");
> print "Sorry, the database was unable to add your entry. Please try
>again
> later.";
> } else {
> print header, start_html("Entry Added");
> print "Information Added\n";
> }
>
> That is what I am using I get an error at the my $success = $dbh->do("INSERT
> INTO $tbl VALUES $all") or die "Unable to write information to inventory
> database: $dbh->errstr\n"; process.
>
> Error Message:
>
> Unable to write information to inventory database:
> DBI::db=HASH(0x1a94a1c)->errstr
>
> I have tried every way possible I can think of and I cannot get it to work
> at all.
> Any help with this would be greatly appreciated.
>
> Thanks in advance,
> Ray
>
RE: DBD-Oracle instalation problem on solaris 2.6
Oooppsss. Sorry didn't see the attachment. Ilya -Original Message- From: oscar perez perez To: [EMAIL PROTECTED] Sent: 05/17/2001 2:27 AM Subject: DBD-Oracle instalation problem on solaris 2.6 Hello, I am trying to install the perl module DBD-Oracle and I've having problem in the test part of the installation. I am installing DBD-Oracle module on solaris 2.6 with Oracle 8.1.7 , perl 5.6.1 and DBI 1.15 Could anyone help me? Thanks in advance. The attached file is the result of executing perl Makefile.PL -v make make test make test TEST_VERBOSE=1 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. <>
RE: DBD-Oracle instalation problem on solaris 2.6
What's the problem? Ilya -Original Message- From: oscar perez perez To: [EMAIL PROTECTED] Sent: 05/17/2001 2:27 AM Subject: DBD-Oracle instalation problem on solaris 2.6 Hello, I am trying to install the perl module DBD-Oracle and I've having problem in the test part of the installation. I am installing DBD-Oracle module on solaris 2.6 with Oracle 8.1.7 , perl 5.6.1 and DBI 1.15 Could anyone help me? Thanks in advance. The attached file is the result of executing perl Makefile.PL -v make make test make test TEST_VERBOSE=1 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. <>
RE: SQL Server
You can use DBD::ODBC, probably the best choice (in my opinion). You can also use DBD::Sybase. Ilya Sterin -Original Message- From: Alisa Mills To: [EMAIL PROTECTED] Sent: 05/17/2001 7:06 AM Subject: SQL Server I am trying to port an application from Unix to Windows 2000. The Unix version used Oracle, and the Windows 2000 version will use MS SQL Server 2000. I found a DBI for ODBC, ADO, and a very old one for MS SQL Server. Does anyone know of a DBI that will work with MS SQL Server 2000? Thanks in advance. Ci-Ci [EMAIL PROTECTED]
RE: :Sybase installation error!!!
These kinds of errors seem to come about when proper connections can't be made or the driver install is flawed. Can you connect with ISQL to the server? What version of Sybase is on the machine? Is it the server or client install? -Original Message- From: Spohn, Albert F. [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 8:52 AM To: '? ?'; [EMAIL PROTECTED] Subject: RE: :Sybase installation error!!! That's the exact same error I'm getting (re:Initial Install Issue), then it was pointed out that I had two perl installations on my machine, so I strongly suspected that was the issue. I haven't had a chance to pursue that as of yet, so I'd be very interested in what the determination is in your case - in the meantime I'll keep you informed as to my progress as to whether conflicting perl installations was the root of my problem. Thanks, Al Al Spohn Publishing and Media Technology Services Mayo Clinic 507-284-1666 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 16, 2001 7:56 PM > To: [EMAIL PROTECTED] > Subject: DBD::Sybase installation error!!! > > > hello ,everyone. > I have installed DBI-1.14 successfully on my linux system(Red > Hat Linux release 6.1,kernel 2.2.12-20 on an i686).But I have > a problem when I install DBD::Sybase-0.91 on my system.Will > you be so kind as to help me?Thanks a lot. > *ERROR MESSAGE*** > I have no problem when I run "perl Makefile.PL" and "make" > the error message of "make test" is following up. > #make test > PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib > -I/usr/lib/perl5/5.00503/ > i386-linux -I/usr/lib/perl5/5.00503 -e 'use Test::Harness > qw(&runtests $verbose) > ; $verbose=0; runtests @ARGV;' t/*.t > t/autocommitdubious > Test returned status 0 (wstat 139, 0x8b) > Undefined subroutine &Test::Harness::WCOREDUMP called at > /usr/lib/perl5/5.00503/ > Test/Harness.pm line 288. > make: *** [test_dynamic] Error 255 > ~ > **ENVIROMENT > #perl -V > Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration: > Platform: > osname=linux, osvers=2.2.5-22smp, archname=i386-linux > uname='linux porky.devel.redhat.com 2.2.5-22smp #1 smp > wed jun 2 09:11:51 ed > t 1999 i686 unknown ' > hint=recommended, useposix=true, d_sigaction=define > usethreads=undef useperlio=undef d_sfio=undef > Compiler: > cc='cc', optimize='-O2', gccversion=egcs-2.91.66 > 19990314/Linux (egcs-1.1.2 > release) > cppflags='-Dbool=char -DHAS_BOOL -I/usr/local/include' > ccflags ='-Dbool=char -DHAS_BOOL -I/usr/local/include' > stdchar='char', d_stdstdio=undef, usevfork=false > intsize=4, longsize=4, ptrsize=4, doublesize=8 > d_longlong=define, longlongsize=8, d_longdbl=define, > longdblsize=12 > alignbytes=4, usemymalloc=n, prototype=define > Linker and Libraries: > ld='cc', ldflags =' -L/usr/local/lib' > libpth=/usr/local/lib /lib /usr/lib > libs=-lnsl -ldl -lm -lc -lposix -lcrypt > libc=, so=so, useshrplib=false, libperl=libperl.a > Dynamic Linking: > dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, > ccdlflags='-rdynamic' > cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib' > > > Characteristics of this binary (from libperl): > Built under linux > Compiled at Aug 30 1999 23:09:51 > @INC: > /usr/lib/perl5/5.00503/i386-linux > /usr/lib/perl5/5.00503 > /usr/lib/perl5/site_perl/5.005/i386-linux > /usr/lib/perl5/site_perl/5.005 > . > > >
SQL Server
I am trying to port an application from Unix to Windows 2000. The Unix version used Oracle, and the Windows 2000 version will use MS SQL Server 2000. I found a DBI for ODBC, ADO, and a very old one for MS SQL Server. Does anyone know of a DBI that will work with MS SQL Server 2000? Thanks in advance. Ci-Ci [EMAIL PROTECTED]
RE: :Sybase installation error!!!
That's the exact same error I'm getting (re:Initial Install Issue), then it was pointed out that I had two perl installations on my machine, so I strongly suspected that was the issue. I haven't had a chance to pursue that as of yet, so I'd be very interested in what the determination is in your case - in the meantime I'll keep you informed as to my progress as to whether conflicting perl installations was the root of my problem. Thanks, Al Al Spohn Publishing and Media Technology Services Mayo Clinic 507-284-1666 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 16, 2001 7:56 PM > To: [EMAIL PROTECTED] > Subject: DBD::Sybase installation error!!! > > > hello ,everyone. > I have installed DBI-1.14 successfully on my linux system(Red > Hat Linux release 6.1,kernel 2.2.12-20 on an i686).But I have > a problem when I install DBD::Sybase-0.91 on my system.Will > you be so kind as to help me?Thanks a lot. > *ERROR MESSAGE*** > I have no problem when I run "perl Makefile.PL" and "make" > the error message of "make test" is following up. > #make test > PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib > -I/usr/lib/perl5/5.00503/ > i386-linux -I/usr/lib/perl5/5.00503 -e 'use Test::Harness > qw(&runtests $verbose) > ; $verbose=0; runtests @ARGV;' t/*.t > t/autocommitdubious > Test returned status 0 (wstat 139, 0x8b) > Undefined subroutine &Test::Harness::WCOREDUMP called at > /usr/lib/perl5/5.00503/ > Test/Harness.pm line 288. > make: *** [test_dynamic] Error 255 > ~ > **ENVIROMENT > #perl -V > Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration: > Platform: > osname=linux, osvers=2.2.5-22smp, archname=i386-linux > uname='linux porky.devel.redhat.com 2.2.5-22smp #1 smp > wed jun 2 09:11:51 ed > t 1999 i686 unknown ' > hint=recommended, useposix=true, d_sigaction=define > usethreads=undef useperlio=undef d_sfio=undef > Compiler: > cc='cc', optimize='-O2', gccversion=egcs-2.91.66 > 19990314/Linux (egcs-1.1.2 > release) > cppflags='-Dbool=char -DHAS_BOOL -I/usr/local/include' > ccflags ='-Dbool=char -DHAS_BOOL -I/usr/local/include' > stdchar='char', d_stdstdio=undef, usevfork=false > intsize=4, longsize=4, ptrsize=4, doublesize=8 > d_longlong=define, longlongsize=8, d_longdbl=define, > longdblsize=12 > alignbytes=4, usemymalloc=n, prototype=define > Linker and Libraries: > ld='cc', ldflags =' -L/usr/local/lib' > libpth=/usr/local/lib /lib /usr/lib > libs=-lnsl -ldl -lm -lc -lposix -lcrypt > libc=, so=so, useshrplib=false, libperl=libperl.a > Dynamic Linking: > dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, > ccdlflags='-rdynamic' > cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib' > > > Characteristics of this binary (from libperl): > Built under linux > Compiled at Aug 30 1999 23:09:51 > @INC: > /usr/lib/perl5/5.00503/i386-linux > /usr/lib/perl5/5.00503 > /usr/lib/perl5/site_perl/5.005/i386-linux > /usr/lib/perl5/site_perl/5.005 > . > > >
Re: DBD-Oracle instalation problem on solaris 2.6
The failure you are getting in plsql.t is a known problem between DBI 1.15 and DBD::Oracle's ORA_RSET return handling. If you don't need to return cursors from PL/SQL, ignore the error and install, otherwise drop back to DBI 1.14. -- Mac :}) ** I normally forward private database questions to the DBI mail lists. ** Give a hobbit a fish and he'll eat fish for a day. Give a hobbit a ring and he'll eat fish for an age. - Original Message - From: "oscar perez perez" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 17, 2001 01:27 Subject: DBD-Oracle instalation problem on solaris 2.6 > I am trying to install the perl module DBD-Oracle and I've having problem in > the test part of the installation. I am installing DBD-Oracle module on > solaris 2.6 with Oracle 8.1.7 , perl 5.6.1 and DBI 1.15
Re: DBI:mysql
This is what I use in a UNIX/Perl DBI/MySql environment where the database is on the
same machine and it works:
# Connect to the database
use DBI;
# Replace databasename with the name of your database below
my ($dsn) = "DBI:mysql:databasename:localhost";
# Replace "username" with your database login name below
my ($user_name) = "username";
# Replace "userpwd" with your database password below
my ($password) = "userpwd";
my ($dbh, $sth);
my (@ary);
$dbh = DBI->connect ($dsn, $user_name, $password, {RaiseError => 1});
I hope this helps.
Mike Calabrese
Web Developer,
IT Point of Sales
SatoTravel
http://www.satotravel.com
Sterling, VA USA
703-736-9038
FAX 703-736-9035
>>> "Simon Chan" <[EMAIL PROTECTED]> 05/16/01 07:14PM >>>
Does anyone know the correct syntax to connect to a mysql database with DBI?
I tried the syntax mentioned in the Perl DBI O'Reilly book, but I got
errors.
thanks
simon
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
DBI::Proxy with ADO/Access on WinNT
Hi
I'm trying to use the DBI::Proxy / ProxyServer modules in order to move some
perl scripts to Unix, yet maintain a link to an access database. While I've
managed to run the ProxyServer on NT and connect to it with Proxy.pm I'm
getting errors when I attempt to use it. (using DBI->trace(9))
On a delete query the query executes on the database but the following call
stack is returned:
Carp::croak(\'Cannot restore overloading on SCALAR(0xd0a60c)
(package Win32::O...\') called at (eval 7) line 4
Storable::logcroak(\'Cannot restore overloading on SCALAR(0xd0a60c)
(package Win32::O...\') called at blib\\lib\\Storable.pm (autosplit into
blib\\lib\\auto/Storable/thaw.al) line 343
Storable::thaw(\'^E^D^B^@^@^@^F^J$DBI::ProxyServer::st=HASH(0x168a694)^J^A0^
J^A0^E^E^T^Q^SWin32::O...\') called at
c:\\perl\\site\\lib/RPC/PlServer/Comm.pm line 144
RPC::PlServer::Comm::Read(\'RPC::PlClient=HASH(0xd6ca14)\') called
at c:\\perl\\site\\lib/RPC/PlClient.pm line 112
RPC::PlClient::Call(\'RPC::PlClient=HASH(0xd6ca14)\',
\'CallMethod\', \'DBI::ProxyServer::db=HASH(0xd42024)\', \'prepare\',
\'DELETE FROM tAqtorTrade where TradeDate = #17-May-2001# AND Sour...\',
undef, \'ARRAY(0xd099ac)\') called at (eval 16) line 5
RPC::PlClient::Object::DBI::ProxyServer::db::prepare(\'RPC::PlClient::Object
::DBI::ProxyServer::db=HASH(0x1332664)\', \'DELETE FROM tAqtorTrade where
TradeDate = #17-May-2001# AND Sour...\', undef, \'ARRAY(0xd099ac)\') called
at c:\\perl\\site\\lib/DBD/Proxy.pm line 366
eval {...} called at c:\\perl\\site\\lib/DBD/Proxy.pm line 366
DBD::Proxy::st::execute(\'DBI::st=HASH(0xd09994)\') called at
c:/Dev/AqtorExport/Source/DTS/Aqtor/PerlModules/AqtorExportDecoder.pm line
188
Then, on a second Delete statement, there are errors writing to the socket
and the ProxyServer dies as follows
Thu May 17 09:47:28 2001 debug, Client executes method CallMethod
Thu May 17 09:47:28 2001 debug, CallMethod: =>
DBI::ProxyServer::db=HASH(0xd42024),prepare,DELETE FROM tIntradayTrade where
TradeDate = #17-May-2001# AND Source =
'AqtorExportReader_NonIndex',,ARRAY(0x168924c)
Thu May 17 09:47:28 2001 debug, CallMethod: <=
DBI::ProxyServer::st=HASH(0x16891a4),0,0,,,0
Thu May 17 09:47:28 2001 err, Child died: Storable binary image v92.0 more
recent than I am (v2.4) at blib\lib\Storable.pm (autosplit into
blib\lib\auto/Storable/thaw.al) line 342, chunk 1, at
c:\perl\site\lib/RPC/PlServer/Comm.pm line 144
Thu May 17 09:47:28 2001 debug, Child terminating.
I'm especially concerned about the version error - but I cannot find other
versions of Storable (1.0.11)
Has anyone had like errors and found solutions to these or is there
something wrong I'm doing. The ProxyServer is running in single-connection
mode but there is only one connection on it. Ans as far as I know the port
I'm using should not be used elsewhere. Any hints, tips, suggestions are
welcome.
Thanks,
Jeff Butler
