X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 94DFC53526 for ; Wed, 4 May 2005 07:10:39 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 24809-02 for ; Wed, 4 May 2005 10:10:36 +0000 (GMT) Received: from hightowergroup.com (mail005.readyhosting.com [63.99.209.11]) by svr1.postgresql.org (Postfix) with ESMTP id 8191A53657 for ; Wed, 4 May 2005 07:10:32 -0300 (ADT) Received: from hightower10.mail.hightowergroup.com [66.109.231.196] by hightowergroup.com with ESMTP (SMTPD32-8.05) id AF9714CD0150; Wed, 04 May 2005 05:10:31 -0500 Message-Id: <6.1.2.0.2.20050504061156.030b23b8@mail.hightowergroup.com> X-Sender: dleedom@hightowergroup.com@mail.hightowergroup.com X-Mailer: QUALCOMM Windows Eudora Version 6.1.2.0 Date: Wed, 04 May 2005 06:16:19 -0400 To: weigelt@metux.de, pgsql-admin From: "David A. Leedom" Subject: Re: ODBC + pgsql on win32 In-Reply-To: <20050504015558.GD8051@nibiru.borg.metux.de> References: <20050504015558.GD8051@nibiru.borg.metux.de> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.678 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200505/41 X-Sequence-Number: 17470 I don't claim to be an export in this area, but here is how I am doing things: ADO connection snipit: Set oTargetConn = New ADODB.Connection oTargetConn.ConnectionString = "DRIVER={PostgreSQL};" _ & "SERVER=" & Me.txtHost & ";" _ & "UID=" & Me.txtLogin & ";" _ & "PWD=" & Me.txtPassword & ";" _ & "PORT=" & Me.txtPort & ";" _ & "Database=" & Me.txtDatabase & ";" I specifically tried to avoid using a defined ODBC definition. Also I am not using bound controls in my application so I don't do anything with the built in vb data objects. Enthusiastically, Dave Leedom At 09:55 PM 5/3/2005, Enrico Weigelt wrote: >Hi folks, > >i'm trying to use an odbc-based win32 application (biet-o-matic) >with postgresql. (afaik its written in vb) >I've installed the latest odbc driver and set up an datasource >(in fact an user-dsn and an system-dsn), and of course created >user + database for the app. > >The application wants to know provider-string, dbname, dbuser, .. >As provider string i've tried the dsn's as well as the driver >name (PostgreSQL), but this didnt work: the application shouts >out that the provider string could not be found. > >What am I doing wrong ? > > >thx >-- >--------------------------------------------------------------------- > Enrico Weigelt == metux IT service > phone: +49 36207 519931 www: http://www.metux.de/ > fax: +49 36207 519932 email: contact@metux.de >--------------------------------------------------------------------- > Realtime Forex/Stock Exchange trading powered by postgresSQL :)) > http://www.fxignal.net/ >--------------------------------------------------------------------- > >---------------------------(end of broadcast)--------------------------- >TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) The Hightower Group, Inc. Custom Software Solutions Designed To Fit Your Business Like A Glove. 165 West Airport Road, Suite B/Lititz, PA 17543 V:717-560-4002, 877-560-4002 x: 114 F:717-560-2825 www.hightowergroup.com