Hi,
I have been using a DSN connection to postgres. I was reading the article for foxpro->MySQL and the author was using a DSN-Less connection. I'd like to use a DSN-Less connection if possible. I have tried the following without success:
I have attempted many different ways but all similar to below.
myconn=sqlstringconnect(Driver=PostgreSQL;UID=root;PWD=mypasswd;DATABASE=acct;SERVER=192.168.1.202;)

mydsn=filetostr(mysql.dsn)
myconn=sqlstringconnect(mydsn)
below is the file "mysql.dsn" which came from using creating a dsn connection file.

DRIVER=PostgreSQL
UID=root
EXTRASYSTABLEPREFIXES=dd_
CANCELASFREESTMT=0
PARSE=0
BOOLSASCHAR=1
UNKNOWNSASLONGVARCHAR=0
TEXTASLONGVARCHAR=1
USEDECLAREFETCH=0
KSQO=1
OPTIMIZER=1
COMMLOG=0
DEBUG=0
MAXLONGVARCHARSIZE=8190
MAXVARCHARSIZE=254
UNKNOWNSIZES=0
SOCKET=4096
FETCH=100
CONNSETTINGS=
SHOWSYSTEMTABLES=0
ROWVERSIONING=0
SHOWOIDCOLUMN=0
FAKEOIDINDEX=0
PROTOCOL=6.4
READONLY=0
PORT=5432
SERVER=192.168.1.202
DATABASE=acct

TIA
John