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
so, I think it may have to do with the driver name not being found. try {PostgreSQL ANSI}; instead of unicode.