 Connecting to PostgresSQL serverHi,
I have been dragged back from retirement to fix a small Paradox database we use for design.
Previously I used the Paradox ODBC to connect to the DB and all was well. The DB is now a PostgreSQL databse.
I have installed the ODBC connection and can connect useing Access. PostgreSQL35W ODBC System DSN
On the paradox form I have a button to connect to the DB useing the following Code
dynalias["UserName"] = "aaaaa", dynalias["Password"] = "XXXXXX"
if not db.open(":PostgreSQL35W:", dynalias) then ;Which Is the ODBC System DSN, , msginfo("Caliach Database Not Open", "stop")
else
message.visible = true ;UPDATE NEW PARTS, message = ("UPDATING PARTS DATA")
sqlvar = sql
SELECT PTMPTNO, PTMP1CD, PTMSTUM, PTMSEQ,PTMSATX , PTMUSE1, PTMUSE2, FROM altro.PTMFILE altro_ptmfile, WHERE PTMSEQ > ~oldptmseq, endsql
executeSql(db, sqlvar, ":caliachData:NewParts"), , endif
How do I change this to connect to the Postsgres35 DYN?
| 1 Reply: | 
Steven.G | > ":PostgreSQL35W:"
are you certain that the alias itself is correctly defined in the BDE and/or the app?
> msginfo("Caliach Database Not Open", "stop")
throw in an errorshow(), too.. might answer the question
|
| 
Print This
