Re: DSN-Less - Mailing list pgsql-general

From rolf.ostvik@axxessit.no
Subject Re: DSN-Less
Date
Msg-id OF3158E08E.ED389770-ONC1256DAA.003DB3DF@axxessit.no
Whole thread Raw
In response to DSN-Less  (victor silalahi <thesinbook@bassplayer.cc>)
List pgsql-general
victor silalahi <thesinbook@bassplayer.cc> wrote:
>get any information about DSN less according to
>ConnectionString property in my VB6 application. is there
>possible to use DSN Less to connect to postgresql dbms ?
>and what kind of ConnectionString that i will use
>to connect postgresql dbms (with DSN less) ?


In LabVIEW (with database connectivity toolset) i use (i think it uses
ADO):
------- Start --
Provider=MSDASQL.1;
Extended
Properties="DRIVER={PostgreSQL};SERVER=ServerName;UID=UserName;PWD=Password;READONLY=0;DATABASE=DatabaseName;
-------- Stop (No linefeeds in string) --------

In Microsoft Access 97:
------- Start --
ODBC;DRIVER={PostgreSQL};SERVER=ServerName;UID=UserName;PWD=Password;READONLY=0;DATABASE=DatabaseName;
-------- Stop (No linefeeds in string) --------

Put in appropriate values for
        ServerName
        UserName
        Password
        DatabaseName

Hope this helps
--
Rolf

pgsql-general by date:

Previous
From: "Nigel J. Andrews"
Date:
Subject: Re: PostgreSQL query failed: ERROR: pg_atoi: zero-length
Next
From: Bruce Momjian
Date:
Subject: Re: after postgres upgrade - ERROR: current transaction