From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: (qmail 117443 invoked by alias); 17 Jun 2018 06:22:35 -0000 Mailing-List: contact cygwin-help@cygwin.com; run by ezmlm Precedence: bulk List-Id: List-Subscribe: List-Archive: List-Post: List-Help: , Sender: cygwin-owner@cygwin.com Mail-Followup-To: cygwin@cygwin.com Received: (qmail 117339 invoked by uid 89); 17 Jun 2018 06:22:30 -0000 Authentication-Results: sourceware.org; auth=none X-Virus-Found: No X-Spam-SWARE-Status: No, score=-1.8 required=5.0 tests=AWL,BAYES_00,KAM_LAZY_DOMAIN_SECURITY,RCVD_IN_DNSWL_LOW autolearn=no version=3.3.2 spammy=Baker, baker, company, UD:php X-HELO: smtp-out-so.shaw.ca Received: from smtp-out-so.shaw.ca (HELO smtp-out-so.shaw.ca) (64.59.136.139) by sourceware.org (qpsmtpd/0.93/v0.84-503-g423c35a) with ESMTP; Sun, 17 Jun 2018 06:22:25 +0000 Received: from [192.168.1.100] ([24.64.240.204]) by shaw.ca with ESMTP id UR4wf29OBSzNNUR4xfHcNh; Sun, 17 Jun 2018 00:22:23 -0600 X-Authority-Analysis: v=2.3 cv=KuxjJ1eN c=1 sm=1 tr=0 a=MVEHjbUiAHxQW0jfcDq5EA==:117 a=MVEHjbUiAHxQW0jfcDq5EA==:17 a=IkcTkHD0fZMA:10 a=bJwSpXA5FX-tpRAfG6QA:9 a=QEXdDO2ut3YA:10 Reply-To: Brian.Inglis@SystematicSw.ab.ca Subject: Re: PHP 7.1.16 (cli) (built: Apr 10 2018 18:09:30) ( NTS ) To: cygwin@cygwin.com References: <1672540905.728828.1529197725579.ref@mail.yahoo.com> <1672540905.728828.1529197725579@mail.yahoo.com> From: Brian Inglis Openpgp: preference=signencrypt Message-ID: Date: Sun, 17 Jun 2018 22:31:00 -0000 User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101 Thunderbird/52.8.0 MIME-Version: 1.0 In-Reply-To: <1672540905.728828.1529197725579@mail.yahoo.com> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-CMAE-Envelope: MS4wfLn/QySfc++mPu79KdywVuLLLoZQTM12pH7TfFYk1rlhh1VHuDh5kfZdnxG4MMEGQtD1J8RdwMA7FG/L/MUWwHnMBOHiM8hdWyfej9hiIV3/QrtQzyo+ reFSNP/RzV81OEYdD5XfxLz7SxvPf9TqjXoTVR2IQgs9G4w4oBjO26+OTzOldzMjr3ZlluC0bkOzlw== X-IsSubscribed: yes X-SW-Source: 2018-06/txt/msg00205.txt.bz2 On 2018-06-16 19:08, Larry Baker via cygwin wrote: > I have been battling this issue for many weeks now and hoping to get some > direction on what to try next. > I have installed php, everything seems to be working except: > /usr/lib/php/20160303/php_com_dotnet.dll. > Cygwin PHP does not come with php_com_dotnet.dll so I downloaded from > Microsoft. I'm trying to pull data from Visual Fox Pro 8.0 files. > My php.ini file looks like this: > [COM] > [PHP_COM_DOTNET] > extension=php_com_dotnet.dll > But when I execute my code, I get this error: > PHP Warning: PHP Startup: Unable to load dynamic library > '/usr/lib/php/20160303/php_com_dotnet.dll' - No such file or directory in > Unknown on line 0 > PHP Fatal error: Uncaught Error: Class 'COM' not found in > /cygdrive/f/php/postcard.php:13 > Stack trace: > #0 {main} > thrown in /cygdrive/f/php/postcard.php on line 13 > I have searched forever and can't find a solution. > Why would PHP installation have this dll included for this version of PHP? > $conn = new COM("ADODB.Connection"); > $conn->Open("Provider=VFPOLEDB.1;Data Source=/cygdrive/f/php;Collating Sequence=Machine"); > // open in read-only mode > $db = dbase_open('postcard.dbf', 0); > // do some stuff > ?> > Any help would be greatly appreciated!! You probably need to install and run native Windows PHP under a native Windows web server to use MS COM DLLs, as I don't believe Cygwin supports Windows COM or ODBC; the Data Source should be the VFP data file path (....vbc?) Alternatively you could convert the VFP data to a PHP supported data format e.g. FOX2X, FOXPLUS, DBASE/DBF, or CSV, or move it into a PHP supported DBMS. You should seriously consider moving from VFP, which has been EoL for 10 years, to something being maintained currently, while there are still systems, converters, tools, services, and knowledge available to do so. Unless you are running in a VM, MS next Windows update could kill your app. The cost/effort and repercussions from dealing with that could outweigh the cost/effort of proactive replacement, if this is a company app. -- Take care. Thanks, Brian Inglis, Calgary, Alberta, Canada -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple