Jeff Urlwin wrote:
>Please read DBD::ODBC pod. Specifically the section on the odbc_cursortype.
>
>Jeff
>
>
I just added odbc_cursortype=> DBI::SQL_CURSOR_DYNAMIC to our
connection string, and that didn't help things at all.
Martin J. Evans ( see other post on topic ) says that this won't w
Martin J. Evans wrote:
>>Just tried that. Doesn't seem to have any effect on my system. Here's
>>the line I added right after create $dbh :
>>$dbh->{odbc_SQL_ROWSET_SIZE} = 2;
>>
>>
>
>Didn't you say something about using FreeTDS? If so that hack might not work
>for FreeTDS. Against MS SQL Ser
On Wed, 2005-06-08 at 16:48 -0500, Jay Hannah wrote:
> > > Not us. We use DBD::Sybase and FreeTDS to connect to MS-SQL from Linux.
>
> > Could you give me a pointer on how to set this up?
> > I did a couple of tests the other day but I couldn't make it work.
>
> Maybe our Intranet document will
What seemed to work well was this: select the rows I
want to keep into a new table; truncate the old table;
drop the old table; rename the new table to the old;
redo indices, etc. The part that surprised me was the
truncate. Simply dropping a table without first
truncating it seemed to take a l
Yes. A TRUNCATE operation is a data dictionary reset of the table's storage to
the initial size (the high-water mark). This operation is unrecoverable and
does not involve redo, rollback, index operations, trigger firing, etc. All of
this is covered to some degree in the concepts manual for y
Reidy, Ron wrote:
Why don't you speak with the DBAs at your site? They can tell you
> what they want, and if it goes south, they will have themselves
> to blame.
We have some ongoing dialogue. Mostly they want me to stop
hammering their database. ;-)
What seemed to work well was this: sel
Thanks for all the suggestions. Steve's solution below seemed to work for
me.
Not sure how the capital I in "Install" made the difference though.
Regards,
Jennifer
-Original Message-
From: steve hatfield [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 25, 2005 3:23 AM
To: [EMAIL PROTECTED
Hi,
I try to install ODBC driver for DBI module but I can't find
DBD-ODBC.ppd anywhere.
The hyper-link to the download seems to be broken
(http://archive.apache.org/dist/perl/win32-bin/ppmpackages/DBD-ODBC.ppd)
Thank you for your help.
Karine
---
Ce message et to
Why don't you speak with the DBAs at your site? They can tell you what they
want, and if it goes south, they will have themselves to blame.
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Steve Sapovits [mailto:[EMAIL PROTECTED]
Sent: Saturday, June
