From fred@redhotpenguin.com Wed Dec 7 06:16:52 2005 Return-Path: X-Original-To: odbcng-general@pgfoundry.org Delivered-To: odbcng-general@pgfoundry.org Received: from localhost (av.hub.org [200.46.204.144]) by pgfoundry.org (Postfix) with ESMTP id DF1C91125026 for ; Wed, 7 Dec 2005 06:16:51 +0000 (GMT) Received: from pgfoundry.org ([200.46.204.130]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 17565-02 for ; Wed, 7 Dec 2005 02:16:49 -0400 (AST) Received: from app.redhotpenguin.com (app.redhotpenguin.com [64.127.99.51]) by pgfoundry.org (Postfix) with ESMTP id BAA811125004 for ; Wed, 7 Dec 2005 06:16:48 +0000 (GMT) Received: (qmail 14867 invoked by uid 1005); 6 Dec 2005 22:13:36 -0800 X-Spam-Check-By: app.redhotpenguin.com Received: from [67.188.239.8] (HELO [192.168.2.6]) (67.188.239.8) (smtp-auth username fred@redhotpenguin.com, mechanism plain) by app.redhotpenguin.com (qpsmtpd/0.28) with ESMTP; Tue, 06 Dec 2005 22:13:34 -0800 Message-ID: <43967E51.6090803@redhotpenguin.com> Date: Tue, 06 Dec 2005 22:16:49 -0800 From: Fred Moyer User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051129) X-Accept-Language: en-us, en MIME-Version: 1.0 To: odbcng-general@pgfoundry.org Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Old-Spam-Check-By: app.redhotpenguin.com X-Old-Spam-Status: No, hits=0.0 required=5.0 tests= X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: Subject: [Odbcng-general] OIDs added to query clause X-BeenThere: odbcng-general@pgfoundry.org X-Mailman-Version: 2.2a0 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 07 Dec 2005 06:16:52 -0000 Hello odbcng list, I've setup and got odbcng working and it appears to be adding OID and CTID clauses to the queries I'm passing to it. From my postgres log: LOG: statement: SELECT * , CTID, OID FROM "foo" where ctid in ('(0, 1)') when my query was "SELECT * from foo". - Fred From cgg007@yahoo.com Tue Feb 14 21:15:41 2006 Return-Path: X-Original-To: odbcng-general@pgfoundry.org Delivered-To: odbcng-general@pgfoundry.org Received: from localhost (av.hub.org [200.46.204.144]) by pgfoundry.org (Postfix) with ESMTP id CB534103384E for ; Tue, 14 Feb 2006 21:15:40 +0000 (GMT) Received: from pgfoundry.org ([200.46.204.130]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 66750-08 for ; Tue, 14 Feb 2006 17:15:38 -0400 (AST) Received: from web32514.mail.mud.yahoo.com (web32514.mail.mud.yahoo.com [68.142.207.224]) by pgfoundry.org (Postfix) with SMTP id 1EFB71033001 for ; Tue, 14 Feb 2006 21:15:37 +0000 (GMT) Received: (qmail 77374 invoked by uid 60001); 14 Feb 2006 21:15:36 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=0XqldQ+C6wpz/r9JK+w2e/6QZ4PbBDuIQsefDOtwAMEmarPiLof5Mct9KtTLnM/EMe+ejA9BehLuE0+wpHpUjbZO6aAtLgznC+yVetzB9ed1+gUDUYFQxmmfjgYZwSwpbItloe2s8jZ01h3SZBY3gQFF05NfbF/Sapy94+fZ3QQ= ; Message-ID: <20060214211536.77372.qmail@web32514.mail.mud.yahoo.com> Received: from [216.173.173.66] by web32514.mail.mud.yahoo.com via HTTP; Tue, 14 Feb 2006 13:15:36 PST Date: Tue, 14 Feb 2006 13:15:36 -0800 (PST) From: CG To: odbcng-general@pgfoundry.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.525 required=5 tests=[AWL=0.046, DNS_FROM_RFC_ABUSE=0.479] X-Spam-Score: 0.525 X-Spam-Level: Subject: [Odbcng-general] Driver Name and Params for a DSN-Less connection X-BeenThere: odbcng-general@pgfoundry.org X-Mailman-Version: 2.2a0 Precedence: list Reply-To: cgg007@yahoo.com List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 14 Feb 2006 21:15:41 -0000 I'm trying to test out the ODBCng driver... What is the correct driver name and what are all possible parameters that can be given in the connection string for a DSN-less connection? CG __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com From cgg007@yahoo.com Thu Feb 16 18:58:41 2006 Return-Path: X-Original-To: odbcng-general@pgfoundry.org Delivered-To: odbcng-general@pgfoundry.org Received: from localhost (av.hub.org [200.46.204.144]) by pgfoundry.org (Postfix) with ESMTP id A7A48103382F for ; Thu, 16 Feb 2006 18:58:41 +0000 (GMT) Received: from pgfoundry.org ([200.46.204.130]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 58561-04 for ; Thu, 16 Feb 2006 14:58:39 -0400 (AST) Received: from web32508.mail.mud.yahoo.com (web32508.mail.mud.yahoo.com [68.142.207.218]) by pgfoundry.org (Postfix) with SMTP id BD9E7103382D for ; Thu, 16 Feb 2006 18:58:38 +0000 (GMT) Received: (qmail 53408 invoked by uid 60001); 16 Feb 2006 18:58:37 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=ESX+D5ULgzjf7MOmSy3zCj2nstumBQcqv2eh2NaloWIocO1adXH4/orNbDiE2CQe8epo6W/7nThhQ9Dx7Ev4EVry3hJ1Acjm7+ydOA+9EdF27drrtskVdaPlFbSOLJFmydGFtwIOIZNn98FyQYoSxCGKmWkYu7XD9JDFR5aFMdU= ; Message-ID: <20060216185837.53406.qmail@web32508.mail.mud.yahoo.com> Received: from [216.173.173.66] by web32508.mail.mud.yahoo.com via HTTP; Thu, 16 Feb 2006 10:58:37 PST Date: Thu, 16 Feb 2006 10:58:37 -0800 (PST) From: CG To: odbcng-general@pgfoundry.org In-Reply-To: <20060214211536.77372.qmail@web32514.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.558 required=5 tests=[AWL=-1.000, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_WHOIS=0.879, WEIRD_QUOTING=1.2] X-Spam-Score: 1.558 X-Spam-Level: * Cc: jd@commandprompt.com Subject: [Odbcng-general] Unsupported property X-BeenThere: odbcng-general@pgfoundry.org X-Mailman-Version: 2.2a0 Precedence: list Reply-To: cgg007@yahoo.com List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 16 Feb 2006 18:58:41 -0000 Is this really an unsupported property, or am I missing something? [VBSCRIPT CODE] connstr = "Provider=MSDASQL.1;Password=PWD;" & _ "Persist Security Info=True;User ID=USER;" & _ "Extended Properties=""DRIVER={Mammoth ODBCng " & _ "Alpha};DATABASE=data;UID=USER;PWD=PWD;SERVER=192.168.1.2;PORT=5432""" set conn = createobject("adodb.connection") conn.open connstr set rs = conn.execute("Select 1 as ""a"";") 'unsupported property... wscript.echo rs("a").value rs.close set rs = nothing conn.close set conn = nothing [/CODE] C:\Documents and Settings\Administrator\>cscript odbctest.vbs C:\Documents and Settings\Administrator\odbctest.vbs(10, 1) Microsoft OLE DB Provider for ODBC Drivers: ODBC driver does not support the requested properties. If it is an unsupported property, it is a sad thing for me... ".execute" is the only method I use for getting data into and out of PostgreSQL. CG __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com From cgg007@yahoo.com Tue Feb 21 17:00:48 2006 Return-Path: X-Original-To: odbcng-general@pgfoundry.org Delivered-To: odbcng-general@pgfoundry.org Received: from localhost (av.hub.org [200.46.204.144]) by pgfoundry.org (Postfix) with ESMTP id E06D510337F0 for ; Tue, 21 Feb 2006 17:00:46 +0000 (GMT) Received: from pgfoundry.org ([200.46.204.130]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 04009-09 for ; Tue, 21 Feb 2006 13:00:44 -0400 (AST) Received: from web32506.mail.mud.yahoo.com (web32506.mail.mud.yahoo.com [68.142.207.216]) by pgfoundry.org (Postfix) with SMTP id 893E610337F9 for ; Tue, 21 Feb 2006 17:00:43 +0000 (GMT) Received: (qmail 84020 invoked by uid 60001); 21 Feb 2006 17:00:42 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=CS4TFxS12r9G78JvZjBhNq0JpcpzWzLRykHuzCuJP51Lz6/WOQtwfM/4gzSu+w6xxj9e1abDg7rxwOLOpA6WH4gdPEqoXp9pZi7FnBHwtD0DUzTyzAusw4HJmR+5l3EDN1ZmKoxPlEMFTlSGU3Et2OZJRIgLDkjMmCwKVQXCHdY= ; Message-ID: <20060221170042.84016.qmail@web32506.mail.mud.yahoo.com> Received: from [216.173.173.66] by web32506.mail.mud.yahoo.com via HTTP; Tue, 21 Feb 2006 09:00:41 PST Date: Tue, 21 Feb 2006 09:00:41 -0800 (PST) From: CG Subject: Re: [Odbcng-general] Unsupported property To: odbcng-general@pgfoundry.org In-Reply-To: <20060216185837.53406.qmail@web32508.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.821 required=5 tests=[AWL=-1.013, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_WHOIS=0.879, MAILTO_TO_SPAM_ADDR=0.276, WEIRD_QUOTING=1.2] X-Spam-Score: 1.821 X-Spam-Level: * Cc: jd@commandprompt.com X-BeenThere: odbcng-general@pgfoundry.org X-Mailman-Version: 2.2a0 Precedence: list Reply-To: cgg007@yahoo.com List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 21 Feb 2006 17:00:49 -0000 Hmmmm..... I haven't gotten a response to my question yet, on or off the list. Are there others lurking on the list, or am I the only person reading or responding to posts? --- CG wrote: > Is this really an unsupported property, or am I missing something? > > [VBSCRIPT CODE] > > connstr = "Provider=MSDASQL.1;Password=PWD;" & _ > "Persist Security Info=True;User ID=USER;" & _ > "Extended Properties=""DRIVER={Mammoth ODBCng " & _ > "Alpha};DATABASE=data;UID=USER;PWD=PWD;SERVER=192.168.1.2;PORT=5432""" > > > set conn = createobject("adodb.connection") > conn.open connstr > set rs = conn.execute("Select 1 as ""a"";") 'unsupported property... > wscript.echo rs("a").value > rs.close > set rs = nothing > conn.close > set conn = nothing > > [/CODE] > > C:\Documents and Settings\Administrator\>cscript odbctest.vbs > > C:\Documents and Settings\Administrator\odbctest.vbs(10, 1) Microsoft OLE DB > Provider for ODBC Drivers: ODBC driver does not support the requested > properties. > > If it is an unsupported property, it is a sad thing for me... ".execute" is > the > only method I use for getting data into and out of PostgreSQL. > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com