Thread: DSN-Less

DSN-Less

From
victor silalahi
Date:
hi, i'm new in this copmmunity. i usualy use ms sql 2000 to develope Database in every project. But since Microsoft
makean office in my city, there is big difficulties to get a copy of ms sql 2000 cd in my city (illegally hehehe). i
thinkpostgresql more powerfull than ms sql 2000, but i didnt get any information about DSN less according to
ConnectionStringproperty in my VB6 application. is there possible to use DSN Less to connect to postgresql dbms ? and
whatkind of ConnectionString that i will use to connect postgresql dbms (with DSN less) ? 

thanks

_____________________________________________________________
-------------------------
Bass Player?
Get your Free Web Mail @
http://bassplayer.cc
-------------------------

Re: DSN-Less

From
rolf.ostvik@axxessit.no
Date:
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