delorie.com/archives/browse.cgi   search  
Mail Archives: cygwin/2018/06/17/02:22:49

X-Recipient: archive-cygwin AT delorie DOT com
DomainKey-Signature: a=rsa-sha1; c=nofws; d=sourceware.org; h=list-id
:list-unsubscribe:list-subscribe:list-archive:list-post
:list-help:sender:reply-to:subject:to:references:from:message-id
:date:mime-version:in-reply-to:content-type
:content-transfer-encoding; q=dns; s=default; b=Uutfumsh/BhjEjAr
xU1QEXkfy1uKFo8gdX9QKeobux618zPFOmWtYQAFTvcqbn9lOQgpPGn1hre8aN6Q
MuS9M72H1RJi2YT90tq45Epql3eGaGYuwpykzcN04JtXON9H85wcqXySSREQiB2z
bRFOLKBaWj/28UZcqiTtu0xZth8=
DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=sourceware.org; h=list-id
:list-unsubscribe:list-subscribe:list-archive:list-post
:list-help:sender:reply-to:subject:to:references:from:message-id
:date:mime-version:in-reply-to:content-type
:content-transfer-encoding; s=default; bh=GoTtWpCcaq1puUCyzL0azO
BSDxI=; b=SDWR1hm76DvtDZpIZNjMtEQ7F1g/KUe+1acS5qOUHliqCLauihxIaU
iGpri4GlDIJ+O2VWfTueqcJLz5HxP84/OLhYzawwzT5u+5BFQk5U+qBXFiuG89Bb
RbnN2/MVybJyYerWwdesvtdgU97CfKfpgOVD97Yf49v6CA21AjjBY=
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Id: <cygwin.cygwin.com>
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sourceware.org/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com
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
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 DOT Inglis AT SystematicSw DOT ab DOT ca
Subject: Re: PHP 7.1.16 (cli) (built: Apr 10 2018 18:09:30) ( NTS )
To: cygwin AT cygwin DOT com
References: <1672540905 DOT 728828 DOT 1529197725579 DOT ref AT mail DOT yahoo DOT com> <1672540905 DOT 728828 DOT 1529197725579 AT mail DOT yahoo DOT com>
From: Brian Inglis <Brian DOT Inglis AT SystematicSw DOT ab DOT ca>
Openpgp: preference=signencrypt
Message-ID: <c80b2ce8-7332-e28e-c0b6-aee6318cba93@SystematicSw.ab.ca>
Date: Sun, 17 Jun 2018 00:22:22 -0600
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>
X-CMAE-Envelope: MS4wfLn/QySfc++mPu79KdywVuLLLoZQTM12pH7TfFYk1rlhh1VHuDh5kfZdnxG4MMEGQtD1J8RdwMA7FG/L/MUWwHnMBOHiM8hdWyfej9hiIV3/QrtQzyo+ reFSNP/RzV81OEYdD5XfxLz7SxvPf9TqjXoTVR2IQgs9G4w4oBjO26+OTzOldzMjr3ZlluC0bkOzlw==
X-IsSubscribed: yes

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?
> <?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

- Raw text -


  webmaster     delorie software   privacy  
  Copyright © 2019   by DJ Delorie     Updated Jul 2019