Re: "Relocation error"

2002-09-13 Thread Waldemar Zurowski
On Thu, 12 Sep 2002 11:08:57 -0400 "Rich DeSimone" <[EMAIL PROTECTED]> wrote: > Ok so you are suggesting an "apt-get remove libdbd-mysql-perl" then an > "apt-get install libdbd-mysql-perl"? No. Remove: /usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBD/mysql /usr/local/lib/perl5/site_perl

RE: help!

2002-09-13 Thread Jeff Urlwin
You need to setup a DSN. If you are on Windows platforms, then start with a System DSN if possible (instead of a User DSN or File DSN). Create the DSN to "point" to the database. Example: Create A DSN named SQLSERVER1 which connects to the sql server database and Create a DSN na

RE: Result of a stored procedure.

2002-09-13 Thread Jeff Urlwin
Translating: instead of do(), use prepare() and execute(). DBD::ODBC has examples for this in the mytest directory and in t/20SqlServer.t ... they may even work with little/no modification on DBD::ADO, however, in VERY many of them I'm testing multiple result sets and the difficulties that go al

Re: Problem connecting to Oracle Server

2002-09-13 Thread Hardy Merrill
Michael A Chase [[EMAIL PROTECTED]] wrote: > > It's in the fine manual. Run 'perldoc DBI::FAQ' and look at question 4.4. I'm embarrassed to say that I don't think I've ever read through DBI::FAQ before - there's a LOT of excellent info in there. Thanks Michael! -- Hardy Merrill Senior Softwa

help!

2002-09-13 Thread Janarthanan, Prasanna
Hi all.. I have to use ODBC to connect to the sql server (db_server) also using the same ODBC i have to connect to sybase database also. Iam not able to understand the driver concept. Will the ODBC driver be able to connect to both the server. I have DBIODBC.pm file. So i guess while using DBI

Re: DBD::Oracle patch that allows it to build properly in cygwin

2002-09-13 Thread Tim Bunce
Thanks. Can you (or someone) confirm that it doesn't cause problems for non-cygwin Win32? Tim. On Thu, Sep 12, 2002 at 08:45:38PM -0500, Chris R. Donnelly wrote: > I have made a patch to Makefile.PL for DBD::Oracle 1.12 that allows it to > build properly in cygwin without user intervention (asi

Re: How do I detect non-select statements after calling $sth->execute()

2002-09-13 Thread Tim Bunce
On Thu, Sep 12, 2002 at 10:12:29PM -0700, Jonathan Leffler wrote: > Tim Bunce wrote: > > >On Tue, Sep 10, 2002 at 01:49:35PM +0200, Roger Perttu wrote: > >>Tim Bunce wrote: > >>>It has to as it's the "standard" way to check. The DBI docs specifically > >>>say "Non-C statements will have C." > > >

Re: MS SQL Issue

2002-09-13 Thread Michael Peppler
On Thu, 2002-09-12 at 09:37, Cheryl Duggan wrote: > I have a cgi script that runs a query using DBI::Sybase to connect to SQL > Server 2000. This works if I use one DB but not another. Here is the error > from the apache logs: > > DBD::Sybase::st execute failed: Server message number=208 severi

DBD::Oracle patch that allows it to build properly in cygwin

2002-09-13 Thread Chris R. Donnelly
I have made a patch to Makefile.PL for DBD::Oracle 1.12 that allows it to build properly in cygwin without user intervention (aside from configuring the environment properly). It builds liboci.a in the local build directory, then adds the build directory (and -loci) to the link list. I did this

Re: Result of a stored procedure.

2002-09-13 Thread chris
Microsoft Knowledge Base Article - Q194792 RETURN values in a stored procedure must be associated with at least one resultset. On Tue, 10 Sep 2002 12:37:09 -0400, [EMAIL PROTECTED] (Joel Gwynn) wrote: >Sorry if this is too much of an rtfm question but here goes anyway. > >I'm connecting to SQL