Thread: need dsn less connection provider string

hi

there r 2 ways to connect to the database from the front end either
using
Data source name
or
DSN Less connection

i have managed to connect to the database using dsn from active server
pages

i don't want this extra step of making a dsn.
what i am looking of is a provider string for postgresql like many
another databases.


Provider=MSDASQL.1;Connect Timeout=15;Extended

Properties="DSN=postgresqltest;DATABASE=test;SERVER=localhost;PORT=5432;UID=sysdba;PWD=sysdba;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=";Locale
Identifier=1033


it will be great if anybody can help me out
bye
regards

huzaifa