From: | rolf(dot)ostvik(at)axxessit(dot)no |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: DSN-Less |
Date: | 2003-09-23 11:26:19 |
Message-ID: | OF3158E08E.ED389770-ONC1256DAA.003DB3DF@axxessit.no |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
victor silalahi <thesinbook(at)bassplayer(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Nigel J. Andrews | 2003-09-23 11:30:58 | Re: [GENERAL] PostgreSQL query failed: ERROR: pg_atoi: zero-length |
Previous Message | Ron Johnson | 2003-09-23 11:14:31 | Re: PostgreSQL query failed: ERROR: pg_atoi: zero-length |