Received: from smtp.interlog.com (root@smtp.interlog.com [207.34.202.37]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA22280 for ; Sun, 6 Jun 1999 10:22:25 -0400 (EDT) (envelope-from pharvey@codebydesign.com) Received: from codebydesign.com (IDENT:pharvey@209-20-7-180.dialin.interlog.com [209.20.7.180]) by smtp.interlog.com (8.9.1/8.9.1) with ESMTP id KAA04306 for ; Sun, 6 Jun 1999 10:22:24 -0400 (EDT) Sender: pharvey@interlog.com Message-ID: <375A8519.7618659F@codebydesign.com> Date: Sun, 06 Jun 1999 14:26:34 +0000 From: Peter Harvey Organization: CodeByDesign X-Mailer: Mozilla 4.5 [en] (X11; I; Linux 2.0.35 i586) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-interfaces Subject: unixODBC - php Content-Type: multipart/mixed; boundary="------------F5CCE45B6271887BCCE4484B" This is a multi-part message in MIME format. --------------F5CCE45B6271887BCCE4484B Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit --------------F5CCE45B6271887BCCE4484B Content-Type: message/rfc822 Content-Transfer-Encoding: 7bit Content-Disposition: inline Return-path: <> Envelope-to: pharvey@interlog.com Delivery-date: Sun, 6 Jun 1999 09:42:42 -0400 Received: from plus.interlog.com ([207.34.202.21] ident=root) by mailhub2.interlog.com with esmtp (Exim 2.05 #1) id 10qdCD-0005x9-00 for pharvey@interlog.com; Sun, 6 Jun 1999 09:42:41 -0400 Received: from smtp.interlog.com (root@smtp.interlog.com [207.34.202.37]) by plus.interlog.com (8.9.3/8.9.3) with ESMTP id JAA09927 for ; Sun, 6 Jun 1999 09:43:19 -0400 (EDT) Received: from localhost (localhost) by smtp.interlog.com (8.9.1/8.9.1) with internal id JAA00603; Sun, 6 Jun 1999 09:43:18 -0400 (EDT) Date: Sun, 6 Jun 1999 09:43:18 -0400 (EDT) From: Mail Delivery Subsystem Message-Id: <199906061343.JAA00603@smtp.interlog.com> To: MIME-Version: 1.0 Content-Type: multipart/report; report-type=delivery-status; boundary="JAA00603.928676598/smtp.interlog.com" Subject: Returned mail: User unknown Auto-Submitted: auto-generated (failure) X-Mozilla-Status2: 00000000 This is a MIME-encapsulated message --JAA00603.928676598/smtp.interlog.com The original message was received at Sun, 6 Jun 1999 09:43:14 -0400 (EDT) from IDENT:pharvey@209-20-7-180.dialin.interlog.com [209.20.7.180] ----- The following addresses had permanent fatal errors ----- ----- Transcript of session follows ----- ... while talking to postgresql.org.: >>> RCPT To: <<< 550 ... User unknown 550 ... User unknown --JAA00603.928676598/smtp.interlog.com Content-Type: message/delivery-status Reporting-MTA: dns; smtp.interlog.com Received-From-MTA: DNS; 209-20-7-180.dialin.interlog.com Arrival-Date: Sun, 6 Jun 1999 09:43:14 -0400 (EDT) Final-Recipient: RFC822; postgresql-interfaces@postgresql.org Action: failed Status: 5.1.1 Remote-MTA: DNS; postgresql.org Diagnostic-Code: SMTP; 550 ... User unknown Last-Attempt-Date: Sun, 6 Jun 1999 09:43:18 -0400 (EDT) --JAA00603.928676598/smtp.interlog.com Content-Type: message/rfc822 Return-Path: Received: from codebydesign.com (IDENT:pharvey@209-20-7-180.dialin.interlog.com [209.20.7.180]) by smtp.interlog.com (8.9.1/8.9.1) with ESMTP id JAA00599; Sun, 6 Jun 1999 09:43:14 -0400 (EDT) Sender: pharvey Message-ID: <375A7BEC.5663F235@codebydesign.com> Date: Sun, 06 Jun 1999 13:47:24 +0000 From: Peter Harvey Organization: CodeByDesign X-Mailer: Mozilla 4.5 [en] (X11; I; Linux 2.0.35 i586) X-Accept-Language: en MIME-Version: 1.0 To: "George Henry C. Daswani" CC: postgresql-interfaces@postgresql.org Subject: Re: [INTERFACES] Perl_ODBC access of 6.4.2 References: <008501beaf90$a74ac840$0a01a8c0@portalworks.com> <3759E688.2D9D8713@codebydesign.com> <000d01beafd0$2a0854c0$0a01a8c0@portalworks.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit > > Now, if I can only get it working with php-3.0.8 :) That would be even > nicer.. > compiling php-3.0.8 with the iodbc support and linking in the odbc lib that > comes with unixodbc > gives me this result on odbc_connect.. Doesn't happen when I use iodbc, > most likely a problem with php-3.0.8.. > George, Ok. I am not familiar with php stuff so you will have to help me out. The unixODBC DM and iODBC are not, yet, 100% compatible. The principle concern here may be different data type declares in the header files (I am not sure this is the problem). However; it seems that there may be some iODBC specific stuff in php. I suggest tracking down the iODBC specific stuff (probably just a few lines) and seeing if it uses i*.h includes (isqlext.h etc). If so, then you may have to put in an option to compile for UNIXODBC and set the includes (and whatever code changes there may be) for unixODBC. I found, with the PostgreSQL ODBC driver that I almost could use the WIN32... except for the login dialog code (and a few other UNIX include specifics).... because unixODBC is very compatible with Windows (ie uses standard ODBC include files and supports calls such as SQLGetPrivateProfileString()). Please advise if you feel that unixODBC needs to change in some way to get php working. Peter Harvey --JAA00603.928676598/smtp.interlog.com-- --------------F5CCE45B6271887BCCE4484B--