• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • How to suppress the ODBC window on database connect

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved How to suppress the ODBC window on database connect

  1. Issue
0
Votes
Undo
  1. Kevin Barton
    Kevin Barton
  2. PowerBuilder
  3. Friday, 6 July 2018 21:17 PM UTC

I need to test to see if a database is running through a PowerBuilder application. Every time that I test the connection, and the database is down, the ODBC dialog box appears and the application just sits and waits for someone to respond to the window.  Is there a way to suppress the window and just have SQLCA return the error code?

This is my DBParm setting SQLCA.DBParm = "ConnectString='DSN=DATASOURCE_TEST;UID=dba;PWD=sql;ConnectOption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'"

PowerBuilder 2017 and SQL Anywhere 16.

Any Ideas?

  1. ODBC
Como consumir un web servicie en formato json
Appeon Mobile Hide Grey Line Alternative
Responses (1)
Brad Mettee
Brad Mettee Accepted Answer Pending Moderation
  1. Saturday, 7 July 2018 13:02 PM UTC
  2. PowerBuilder
  3. # 1

Your quotes seem to be a bit off.

You have this:

"ConnectString='DSN=DATASOURCE_TEST;UID=dba;PWD=sql;ConnectOption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'"

But it should look like this:

"ConnectString='DSN=DATASOURCE_TEST;UID=dba;PWD=sql',ConnectOption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'"


There's a semi-colon separating the two parts of the string, but it should be an end single quote and a comma

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.