Postgres Logon Parameters, Examples of IP address Logons Please

Andrew Stolarz stolarz at
Fri Jan 19 15:32:00 EST 2018

Hi Das

Here is a basic rough example on how to establish a connection using MySQL
(I don't have access to Postgresql at the moment). Im pretty sure you can
swap out the MySQL dam references with the postgresql one and it will work
as is.


Calculate %%Host as 'ip_address'
Calculate %%Database as 'database_name'
Calculate %%DBUser as 'username'
Calculate %%DBPwd as 'password'

Do $extobjects.MYSQLDAM.$objects.MYSQLSESS.$new() Returns

Do $ctask.tSessionObject.$database.$assign(%%Database)
Do $ctask.tSessionObject.$logon(%%Host,%%DBUser,%%DBPwd) Returns #F

If flag false
OK message Alert (Icon) {Error connecting to database[kCr][kCr][con('Error
Quit method kFalse
End If



On Fri, Jan 19, 2018 at 2:51 PM, Das Goravani <das at> wrote:

> Hello,
> These are postgres log on parameters as they supply for the Mac App
> version of Postgres
> Can anyone tell me how these work into the Omnis $logon() function, what
> to put where
> Or, show me how you calculate your logon for Postgres with an IP adress as
> I also downloaded their complete server product.
> Host    localhost
> Port    5432
> User    your system user name
> Database        same as user
> Password        none
> Connection URL  postgresql://localhost
> thanks
> Das Goravani
> _____________________________________________________________
> Manage your list subscriptions at

More information about the omnisdev-en mailing list