RE: Solution to perl falling over randomly on Windows ODBC

: 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 randomly for two or three years. By increasing the buffer size

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

: 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

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

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

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

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

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

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

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

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

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 the best