Has anybody been able to connect to Postgres from a mobile app?
The app works fine on Desktop and the PostgreSQL35W profile connects OK from both the ODBC admin and PowerServer`s Toolkit, but when the app is deployed to mobile, it doesn`t recognize the DSN name:
"key=value argument incorrect in ConnectString Parameter name: dsn".
I tried using both the name of the data source that was used when creating the SQLCA, and the name used by ODBC administrator (PosgreSQL35W). In both cases the result is the same. Any ideas?
Here is the connectstring I am using:
SQLCA.DBParm = "ConnectString='DSN=PostgreSQL35W;UID=postgres;PWD=sql' "
Thanks in advance for your thoughts :)