ecpg: How to connect to host w. user:password?

Started by Larkover 24 years ago2 messagesgeneral
Jump to latest
#1Lark
andrei.boulgakov@nsi.co.il

Hi!
How can i connect to DB, that resides on another host with specific port as
USER w. Password.
EXEC SQL CONNECT TO ???? AS ??? Where to place Host:port, User:password?

#2Lark
andrei.boulgakov@nsi.co.il
In reply to: Lark (#1)
Re: ecpg: How to connect to host w. user:password?

Lark wrote:

Hi!
How can i connect to DB, that resides on another host with specific port
as USER w. Password.
EXEC SQL CONNECT TO ???? AS ??? Where to place Host:port, User:password?

Thank you for a help :)
I discovered it myself.

exec sql connect to testDB user andrei/mypassword;