RE: Solution to perl falling over randomly on Windows ODBC

essage- > From: Ian Summers [mailto:ian@;isdata.co.uk] > Sent: Thursday, October 31, 2002 11:24 AM > To: [EMAIL PROTECTED] > Subject: Solution to perl falling over randomly on Windows ODBC > > > Hi > > I have been searching for the solution to perl falling over randoml

Solution to perl falling over randomly on Windows ODBC

Hi I have been searching for the solution to perl falling over randomly for two or three years. By increasing the buffer size to 15 times the default (to 30720) it now behaves correctly. The value chosen may need to vary according to the complexity of the application. I also changed the Page T

Re: System Shuts Down Perl When Fetching Records With DBD-ODBC

Hi Have you tried running this in Win NT. I've had similar problems and I don't think that there is a solution - but it works ok on Win 95 and Win NT but not Win 98 and 2000. I've got a machine with Win XP but haven't had a chance to try it. Good luck and I'd love to know what the problem is

Re: Script for Directory Permissions on NT Filesystem

pdir c: 100 #pdir c: 0 0 1 c:\log.txt #pdir c: 0 512 0 c:\log.txt # #To print this message enter ? as the first parameter # #Author: Ian Summers [EMAIL PROTECTED] #Date: 27 January 2001 # # #

RE: Problem with DBI::trace on MSWin32

Richy Does the same error occur when you run this in WinNT? I've had a similar problem with the Win 98 and Win 2000 ODBC drivers but every thing is OK with Win NT (sometimes it falls over but never before it's finished) and Win 95. I've yet to try on Win XP :-) Ian At 08:26 17/10/2001 -0600,

Extracting FileMaker data

Hi Has anyone extracted data from FileMaker on a Windows platform? What module does it require - DBI:ODBC ? Ian ++ This email and any files transmitted with it are confidential and intended solely for the use of the individual or

Re: DBI::Pg avoiding OUTER JOIN

Hi >I understand that OUTER JOINS are not supported with the DBD::Pg driver.. > >1) will it be supported any time soon ?? >2) if not, then what are some of the ways one would perform an outer join >in a cgi script using postgresql for a database ?? Try rephrasing the SQL without any joins at al

Re: how to run perl from MS Access Form

Hi The easiest way is to shell out to a batch file from a command button. . In the form's design view add a command button. . In the command button's On-Click property put [Event Procedure] from the drop-down list. . Double click just to the right of the white area (on a [...] button that will

Re: Writing LONG to DBI::Pg

Alessio Thank you for your reply - I'm trying to insert data with up to 4000 characters in a single column. Can you have columns defined to allow 4000 characters? More to the point, can you insert data into them with DBI::Pg? The code that produces an error looks like this (trimmed to the bar

Writing LONG to DBI::Pg

Hi Can anyone enlighten me? I'm trying to insert a field with 4000 characters into a Pg database which is specified as varchar(4000). I've overcome various hurdles but it produces the following error as soon as it encounters the LONG field: DBD::Pg::st execute failed: PQsendQuery() -- There i

Re: Bind Parameters with MS Access - Thanks Bodo

Bodo Thank you very, very much for your e-mail. That's just what I needed. I know that I should have been using placeholders for a long time and never got round to it - it seemed complicated. I've just spent a couple of hours getting them into my brain for an application that I thought was too

Re: Bind Parameters with MS Access

Thanks for the response and the request for code. Original request: A lot is mailed on this list extolling the virtues of binding parameters. Can this be done with an MS Access Database? I just get an error. Answer: Yes, binding parameters work with MS Access. The real problem is that I'm tr

Bind Parameters with MS Access

Hi A lot is mailed on this list extolling the virtues of binding parameters. Can this be done with an MS Access Database? I just get an error. Ian

MS SQL through MS Access using DBI:ODBC

Hi When connecting an MS SQL database from MS Access it is necessary to use the option dbSeeChanges with db.openrecordset. This is ok when using Visual Basic but is it possible to access the data using DBI:ODBC. Win2000 MS SQL version 7 MS Access 97 perl 5.005 (

Re: Authentication.

Sikkandar Put the script in a folder that is not directly accessible on the website, eg: Web Server | ___ cgi-bin/test.pl | ___docroot/home.htlm If site visitors do not have rights to anywhere but docroot they will not be able to get at your script.

Re: Find Autonum just Entered

I use SELECT MAX(OrderID) FROM tblOrder which should work ok if no one else has updated the table Ian At 22:02 03/04/2001 +0100, you wrote: >On Tue, Apr 03, 2001 at 12:08:03PM +0100, Roland Corbet wrote: > > I'm Using DBI::ODBC with MS Access 200. > > > > Can anyone tell me what is th

Re: Composing a SQL statement

Stacy Try something like this: At 16:26 04/04/2001 +1000, you wrote: > Hi all, > > I have a perl CGI form like thus: > > X | Call No | Call No textfield > X | Problem | Problem textfield > > The X's represent checkboxes. > > In the backend, I have two arrays: > > @fields: check

re: unicode support

Hi Along with Ketan Bajaj I too am interested in knowing how to do return unicode using DBI. Can any one enlighten us? Ian