pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: David A. Leedom <daleedom@hightowergroup.com>
To: weigelt@metux.de, pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: ODBC + pgsql on win32
Date: Wed, 04 May 2005 06:16:19 -0400
Message-ID: <6.1.2.0.2.20050504061156.030b23b8@mail.hightowergroup.com> (raw)
In-Reply-To: <20050504015558.GD8051@nibiru.borg.metux.de>
References: <20050504015558.GD8051@nibiru.borg.metux.de>


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  




view thread (2+ messages)

Message-ID: <6.1.2.0.2.20050504061156.030b23b8@mail.hightowergroup.com>
Permalink:  ../6.1.2.0.2.20050504061156.030b23b8@mail.hightowergroup.com/
Also on:    postgresql.org/message-id/6.1.2.0.2.20050504061156.030b23b8@mail.hightowergroup.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: daleedom@hightowergroup.com
  Subject: Re: ODBC + pgsql on win32
  In-Reply-To: <6.1.2.0.2.20050504061156.030b23b8@mail.hightowergroup.com>
  References: <20050504015558.GD8051@nibiru.borg.metux.de> <6.1.2.0.2.20050504061156.030b23b8@mail.hightowergroup.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox