DSN-Less
hi, i'm new in this copmmunity. i usualy use ms sql 2000 to develope Database in every project. But since Microsoft make an office in my city, there is big difficulties to get a copy of ms sql 2000 cd in my city (illegally hehehe). i think postgresql more powerfull than ms sql 2000, but i didnt 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) ?
thanks
_____________________________________________________________
-------------------------
Bass Player?
Get your Free Web Mail @
http://bassplayer.cc
-------------------------
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
Import Notes
Resolved by subject fallback