PB2019R2
Windows10 64 bit platform
PostgreSQL 10 driver installed
PostgewSQL 10 database named "dev12c"
Summary
Q: How can I stop the "Select Data Source" popup window from being displayed every time a
CONNECT statement is called?
Background
I installed a DSN in order to connect to the PG database from the PB2019R2 IDE - and it worked.
Details
I am now running the application from the IDE to the same database using the DSN-less connection posted by Sivaprakash BKR. Here's what he said:
@ RunTime
SQLCA.DBMS=ODBC
SQLCA.DBParm="ConnectString='Driver=PostgreSQL ODBC Driver(UNICODE);Database=<Database>;Server=<ServerName>;Port=5432;UID=<UserID>;PWD=<Password>;',DisableBind=1"
SQLCA.Lock="RC"
SQLCA.AutoCommit = False
* Substitute <Database>, <ServerName>, <UserID>, <Password> with correct values.
When any CONNECT is called, this dialog box pops up, asking me to select the Data Source.
I scroll down to the PG entry and select it:
Click OK, and it connects successfully.
As I proceed through the code and add another tranasction object, the "Select Data Source" window pops up again when the CONNECT is called.
Thank You,
Olan
I tried this and got a failure with a "999 sqlca.sqlDBCode error.
ConnectString='Driver={PostgreSQL UNICODE}; Server=10.10.10.243;Database=dev12c; Port=5444;UID=devusr;PWD=devusr',OJSyntax='UNICODE',StripParmNames='Yes',INIT_PROMPT='DBPROMPT_NOPROMPT',CommitOnDisconnect='No',DelimitIdentifier='No',PBTrimCharColumns='YES',StaticBind=0,DisableBind=1,ConnectOption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'
It also failed when server=accdevxd0022.sp.dev.com.
ConnectString='Driver={PostgreSQL UNICODE}; Server=10.10.10.243;Database=dev12c; Port=5444;UID=devusr;
PWD=devusr',OJSyntax='UNICODE',StripParmNames='Yes',INIT_PROMPT='DBPROMPT_NOPROMPT',
CommitOnDisconnect='No',DelimitIdentifier='No',PBTrimCharColumns='YES',StaticBind=0,DisableBind=1,
ConnectOption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'